You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Current »

问题

开票通知单金额和重量翻倍了

解决方案

问题原因:【客户开票设置】中有多个开票客户

image-2023-04-20-22-34-45-728.png

解决方法:禁用掉多余的开票用户,删掉开票通知单,然后重置应收单的金额,脚本如下:
update T_AR_OtherBillentry
set CFUNSUBMITAMT=FAMOUNT
 where fparentid in (
select fid from T_AR_OtherBill where fnumber in (
'应收单号')
) and CFUNSUBMITAMT>FAMOUNT

如果是蛋品的,还需要再重置蛋品应收明细的金额,脚本如下:

update CT_AR_YsMaterialDetailentry
set CFUNSUBMITAMT=CFAMOUNT
where fparentid in (
select fid from CT_AR_YsMaterialDetail where fnumber in (
'蛋品应收明细单号')
) and CFUNSUBMITAMT>CFAMOUNT

相关的文章



  • No labels