1/5用友股份-LE支持服务业务本部产品方案--《NC5X库存关帐检查时如何查询自由单据》建立日期：2013-08-01修改日期：xxxx-xx-xx文档属性：客户文控编号：LE-DY-CP-2013-07032/5文档控制创建记录适用范围审阅人日期审阅签字所属部门发布范围内部员工伙伴客户发布人姓名所属部门发布时间日期作者所属部门邮件地址版本2013-08-01何俐产品支持部V1.0版本领域模块备注3/5目录NC5X库存关帐检查时如何查询自由单据..............................................................4一、问题提出的背景................................................................................................4二、解决方法............................................................................................................44/5NC5X库存关帐检查时如何查询自由单据一、问题提出的背景库存开关帐设置，在关帐检查时，系统中有很多自由单据而无法关帐，却无法从前台查询到库存的自由状态的出入库单据。提供以下查询脚本，供顾问参考，适合5X版本。二、解决方法操作步骤：--按照仓库PKselect*fromic_general_hhINNERJOINic_general_bbONh.cgeneralhid=b.cgeneralhidwhereh.cwarehouseid='100111100000000002BJ'--仓库pkANDh.dr=0AND(h.cbilltypecode='40'orh.cbilltypecode='45'orh.cbilltypecode='46'orh.cbilltypecode='47'orh.cbilltypecode='4A'orh.cbilltypecode='4C'orh.cbilltypecode='4D'orh.cbilltypecode='4E'orh.cbilltypecode='4F'orh.cbilltypecode='4I'orh.cbilltypecode='4O')ANDb.dr=0andh.fbillflag=2--1删除2自由(缺省)3库房签字4存货系统审核andb.dbizdate>='2010-10-01'--期间开始日期andb.dbizdate<='2010-10-31'--期间结束日期;--库存查询selectstorcode,storname,storaddr,pk_stordoc5/5frombd_stordocwhere(pk_corp='1001'andpk_calbodyin(selectpk_calbodyfrombd_calbodywheresealflagisnullorsealflag='N'))and(bd_stordoc.sealflag<>'Y')orderbystorcode;--按照库存组织PKselectCOUNT(*)fromic_general_hhINNERJOINic_general_bbONh.cgeneralhid=b.cgeneralhidwhereh.pk_calbody='100111100000000001X5'ANDh.dr=0AND(h.cbilltypecode='40'orh.cbilltypecode='45'orh.cbilltypecode='46'orh.cbilltypecode='47'orh.cbilltypecode='4A'orh.cbilltypecode='4C'orh.cbilltypecode='4D'orh.cbilltypecode='4E'orh.cbilltypecode='4F'orh.cbilltypecode='4I'orh.cbilltypecode='4O')ANDb.dr=0andh.fbillflag=2andb.dbizdate>='2010-09-01'andb.dbizdate<='2010-09-30';--库存组织查询selectbodycode,bodyname,vnote,area,pk_calbodyfrombd_calbodywhere(pk_corp='1001')and(bd_calbody.sealflag='N'orbd_calbody.sealflagisnull)orderbybodycode
