金蝶K3应付模块后台反结账语句

最新推荐文章于 2023-06-29 09:44:35 发布

Najd

最新推荐文章于 2023-06-29 09:44:35 发布

阅读量1.6k

点赞数

分类专栏： K3 WISE

本文链接：https://blog.csdn.net/Atonei/article/details/106721126

版权

K3 WISE 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

Update t_subsys set Fused = -1 , FPeriodSynch = 0 , FCheckout = 0 where Fsubsysid = 6 and Fyear= 2020 and Fperiod = 2; //修改应付模块期间状态，应收模块 Fsubsysid = 5

Update t_RP_SystemProfile Set FValue = ‘2’ Where FCategory = ‘ARP’ And FKey = ‘FAPCurPeriod’;
Update t_RP_SystemProfile Set FValue = ‘2020’ Where FCategory = ‘ARP’ And FKey = ‘FAPCurYear’;
//修改应付模块当前期间，应收模块为FARCurPeriod

Delete from t_RP_ContactBal Where FYear = 2020 And FPeriod = 3 and FRP=0 //删除应付余额表数据，应收模块FRP=1