金蝶KIS旗舰版应收初始单据的金额录入错误之数据库修改方法

问题：初始应收单据录入错误，供应链系统已经生成了发票并且审核，如何修改期初应收单据？1.反初始化；2.数据处理；3.其他应收单调整。

原因：应收款管理-初始应收单据录入：本来是预收款，应该在单据上录入负数。但是客户录入了正数，只是在应收科目的借贷方向那里改成了贷方。这个借贷方向不会影响往来报表。

处理思路

1.在金蝶表结构中查询相关的数据表

2.修改期初应收单据的数据

3.修改相关报表的数据

代码如下

-- 期初应收单相关表
select * from t_rp_BegData
select * from t_rp_BegDataEntry
select * from t_RP_Plan_Ar
-- 相关报表
select * from t_RP_Contact
select * from t_RP_ContactBal


update t_rp_BegData set FOccAmount = FOccAmount * FDC,
    FOccAmountFor = FOccAmountFor * FDC,
    FAmount = FAmount * FDC,
    FAmountFor = FAmountFor * FDC
    
update te set te.FAmountIncludeTax = te.FAmountIncludeTax * t.FDC,
    te.FAmountIncludeTaxFor = te.FAmountIncludeTaxFor * t.FDC,
    te.FOccAmount = te.FOccAmount * t.FDC,
    te.FOccAmountFor = te.FOccAmountFor * t.FDC,
    te.FAmount = te.FAmount * t.FDC,
    te.FAmountFor = te.FAmountFor * t.FDC,
    te.FRemainAmount = te.FRemainAmount * t.FDC,
    te.FRemainAmountFor = te.FRemainAmountFor * t.FDC    
from t_rp_BegDataEntry te , t_rp_BegData t 
where te.FInterID = t.FInterID
        
update tp set 
    tp.FAmount = tp.FAmount * t.FDC,
    tp.FAmountFor = tp.FAmountFor * t.FDC,
    tp.FRemainAmount = tp.FRemainAmount * t.FDC,
    tp.FRemainAmountFor = tp.FRemainAmountFor * t.FDC    
from t_RP_Plan_Ar tp , t_rp_BegData t 
where tp.FInterID = t.FInterID
and tp.FDate '2019-12-31 00:00:00.000'

update tc set tc.FAmount = tc.FAmount * t.FDC,
    tc.FAmountFor = tc.FAmountFor * t.FDC,
    tc.FRemainAmount = tc.FRemainAmount * t.FDC,
    tc.FRemainAmountFor = tc.FRemainAmountFor * t.FDC    
from t_RP_Contact tc,t_rp_BegData t
where tc.FBegID = t.FInterID
and tc.FRPDate <= '2019-12-31 00:00:00.000'
and tc.FPeriod = 12

update tcb set tcb.FBeginBalanceFor = tc.famount,
    tcb.FEndBalanceFor = tc.FAmount,
    tcb.FBeginBalance = tc.famount,
    tcb.FEndBalance = tc.FAmount
from t_RP_ContactBal tcb, t_rp_contact tc
where tcb.FCustomer = tc.FCustomer
and tcb.FPeriod = 1
and tc.FPeriod = 12