服务热线:400-6530-219

知识库

单据记账时不选‘包含未开发票的出库单’选项,筛选出来的单据也包含一些未开发票的

发布于:2018-03-16 09:21:42

问题现象:在[821存货核算]模块中,销售出库单进行单据记账时,不选‘包含未开发票的出库单’选项,筛选出来的单据也包含一些未开发票的,都是以前年度记过帐的
解决方案:若该单据确已在以前年度记过帐,执行以下语句即可: update rdrecord set caccounter=‘吴真‘ where id in SELECT rdrecord.id FROM Warehouse INNER JOIN Rd_Style RIGHT JOIN RdRecord ON Rd_Style.cRdCode = RdRecord.cRdCode ON Warehouse.cWhCode = RdRecord.cWhCode INNER JOIN RdRecords ON RdRecord.ID = RdRecords.ID INNER JOIN Inventory ON RdRecords.cInvCode = Inventory.cInvCodeleft join dispatchlists on rdrecords.idlsid=dispatchlists.idlsid left join dispatchlist on dispatchlists.dlid=dispatchlist.dlid left join salebillvouchs sales1 on dispatchlists.idlsid=sales1.idlsid left join salebillvouch sale1 on sales1.sbvid=sale1.sbvid left join salebillvouchs sales2 on rdrecords.isbsid=sales2.autoid left join salebillvouch sale2 on sales2.sbvid=sale2.sbvid Where IsnullRdRecords.iQuantity,0<>0 And RdRecord.cAccounter IS NULL and sale1.caccounter is null and sale2.caccounter is null and sale1.cinvalider is null and sale2.cinvalider is null and isnullrdrecord.cbustype,‘‘<>‘委托代销‘ and cMonth is null or rightcMonth,2<2 and rdrecord.cVouchType<>‘33‘ and not rdrecord.cVouchType=‘32‘ or rdrecord.cvouchtype=‘34‘ and ISNULLSALES1.IDLSID,0=0 AND ISNULLRDRECORDS.ISBSID,‘‘=‘‘ and RdRecord.cVouchType=‘32‘ and not rdrecords.isbsid is null OR not sales1.autoid is null or RdRecord.cVouchType=‘34‘ and RdRecord.caccounter is null and RdRecord.dDate <= ‘2004-02-29‘

用友知识

用友软件 为您提供最优质的产品和服务

产品报价:

详情请咨询广州用友:020-82116603