问题:初始应收单据录入错误,供应链系统已经生成了发票并且审核,如何修改期初应收单据?1.反初始化;2.数据处理;3.其他应收单调整。
原因:应收款管理-初始应收单据录入:本来是预收款,应该在单据上录入负数。但是客户录入了正数,只是在应收科目的借贷方向那里改成了贷方。这个借贷方向不会影响往来报表。
2.数据处理的办法:将这些贷方的数全部更新为负数
处理思路
1.在金蝶表结构中查询相关的数据表
表名 | 表 |
---|---|
期初应收应付表 | t_rp_BegData |
期初应收应付明细表 | t_rp_BegDataEntry |
收款计划表-应收 | t_RP_Plan_Ar |
收款计划表-应付 | t_RP_Plan_Ap |
应收应付往来表 | t_RP_Contact |
往来余额表 | t_RP_ContactBal |
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