[原因]

数据异常,t_rp_checkdetai(核销明细表)记录未清除,且t_rp_plan_ar(收款计划表)剩余金额不正确、icsale(销售发票表)中核销金额和剩余金额不正确。

[解决方案]

后台执行以下语句修复:

update t_RP_Plan_Ar set FRemainAmount=famount,FRemainAmountFor=famountfor

where FInterID=4943 and fdetailid=5458

update icsale set FRemainAmount=20925.4500,FRemainAmountFor=20925.4500,FCheckAmount=0,FCheckAmountFor=0

where FBillNo='21510088'

delete from t_Rp_CheckDetail where FCheckID not in (select fid from t_RP_NewCheckInfo)

[概述]

后台数据库执行操作有风险,请勿随意执行。