应付单下推付款申请单有bug
金蝶云社区-guangjie_wang
guangjie_wang
0人赞赏了该文章 1,070次浏览 未经作者许可,禁止转载编辑于2015年09月15日 14:36:03


问题描述:应付单可下推金额28231.5,第一次下推300元(保存),第二次下推金额还是28231.5.

重现过程有2中办法: 1)应付单新增金额为28711.31(数量1,单价为28711.31),下推采购发票,单价改小改为28231.5,审核发票。
再对应付单下推付款申请单即可重现问题。

2)执行下面的脚本,单号为AP00118549,即可重现。

/****** Object:Data Script Date: 2015-09-15 14:15:17 ******/
DELETE T_AP_payable WHERE FBILLNO='AP00118549';
INSERT INTO T_AP_payable(FID,FBILLNO,FBILLTYPEID,FDATE,FENDDATE,FSETTLEORGID,FPURCHASEORGID,FCURRENCYID,FSUPPLIERID,FOWNERTYPE,FOWNERID,FACCOUNTSYSTEM,FEXPENSEIV,FALLAMOUNTFOR,FBYVERIFY,FOPENSTATUS,FWRITTENOFFSTATUS,FRELATEHADPAYAMOUNT,FBUSINESSTYPE,FDOCUMENTSTATUS,FCREATORID,FCREATEDATE,FMODIFIERID,FMODIFYDATE,FISTAX,FMOREFIELD,FCANCELSTATUS,FCANCELLERID,FCANCELDATE,FAPPROVERID,FAPPROVEDATE,FPAYCONDITON,FPURCHASEDEPTID,FPURCHASERGROUPID,FPURCHASERID,FSOURCEBILLTYPE,FISINIT,FINSTOCKBUSTYPE,FMRBBUSTYPE,FPAYORGID,FISBYIV,FISGENHSADJ,FISTAXINCOST,F_LS_Shop,F_LS_SENDORDERNO,F_LS_ISUPDATEMONEY,FMATCHMETHODID) VALUES (154560,N'AP00118549','a83c007f22414b399b0ee9b9aafc75f9',{ts'2015-09-01 00:00:00'},{ts'2015-09-01 00:00:00'},100001,100001,1,103243,' ',0,0,'0',28711.3100000000,'0','C','B',0.00,'CG','C',1196113,{ts'2015-09-01 17:08:05'},1196113,{ts'2015-09-01 17:08:05'},'1',0,'A',0,null,1846027,{ts'2015-09-14 15:40:25'},0,100028,182503,100008,' ','0','CG',' ',100001,'0','0','0',0,N'150900001','0',0) ;

/****** Object:Data Script Date: 2015-09-15 14:16:11 ******/
DELETE T_AP_PAYABLEPLAN WHERE FID=154560;
INSERT INTO T_AP_PAYABLEPLAN(FENTRYID,FID,FSEQ,FENDDATE,FPAYAMOUNTFOR,FPAYAMOUNT,FWRITTENOFFSTATUS,FWRITTENOFFAMOUNTFOR,FNOTWRITTENOFFAMOUNTFOR,FRELATEHADPAYAMOUNT,FWRITTENOFFAMOUNT,FNOTWRITTENOFFAMOUNT,FPAYRATE,FAPPLYAMOUNT) VALUES (151897,154560,1,{ts'2015-09-01 00:00:00'},28711.3100000000,28711.3100000000,'B',479.8100000000,0.00,479.8100000000,0.00,0.00,100.0000000000,0.00) ;

有问题qq找我:272448515