解决方案: |
问题1、经用以下语句检查在AP_DETAIL表中存在存货编码字段不应该为空但的确为空的记录:
select * from ap_detail where cinvcode is null and ccovouchtype in ‘26‘,‘27‘,‘01‘,‘02‘,‘28,‘29‘
执行如下语句更新即可应收系统对应的销售发票:
UPDATE Ap_Detail
set cInvCode=b.cInvCode,iBVID=AutoID
From SaleBillVouch a INNER JOIN SaleBillVouchs b on a.SBVID=b.SBVID
Where Ap_Detail.cCoVouchType=a.cVouchType
and Ap_Detail.cCoVouchID=a.cSBVCode
and Ap_Detail.cInvCode=‘‘ or Ap_Detail.cInvCode Is Null or iBVID=0 or iBVID is null
and iFlag<3
问题2、经检查2003年度该销售发货单其结算数量为空,bSettleAll字段也并未全部结清。
问题3、存货在记帐时本应该将上年未开票、未记帐的销售出库单显示出来。 |