发布时间:2024-7-16
特价活动:>>>> 畅云管家新购、续费7折优惠,畅捷通T+cloud、好会计、易代账、好业财、好生意云产品6-8折优惠。
图上的一份附件,对应的两张凭证。一张是对的,一张的附件和凭证完全没有关系。
问题回复:
因为数据有问题引起的。在账套库执行下面脚本。该脚本执行完会影响应收账款19年度余额和2020年度期初余额。操作前请做好账套备份 在19年度执行
insert into ap_detail (iperiod ,cvouchtype,cvouchid,dVouchDate,dRegDate,cdwcode,cdeptcode,cCode,citem_class,cItemCode,isignseq,ino_id,cdigest,iprice,cexch_name,iExchRate,idamount,icamount,idamount_f,icamount_f,idamount_s,icamount_s,cSSCode,cProcStyle,ccancelno,cpzid,bprepay,iFlag,cCoVouchType,cCoVouchID,cFlag,iClosesID,icoclosesid,cglsign,iglno_id,dPZDate,cAccountPDate)values (8,'48','0000003950','2019-08-15 00:00:00.000','2019-08-20 00:00:00.000','SEM653D-1135',NULL,'100201','98','01',8,NULL,'收周朝豪购SEM653D-1135车款',0,'人民币',1,12800.00,0.00,12800.00,0.00,0,0,'202','48','AR480000003950','AR0000000000157',0,6,48,'0000003950','AR',0,0,'金','20','2019-08-15 00:00:00.000','2019-08-20 00:00:00.000') insert into ap_detail (iperiod ,cvouchtype,cvouchid,dVouchDate,dRegDate,cdwcode,cdeptcode,cCode,citem_class,cItemCode,isignseq,ino_id,cdigest,iprice,cexch_name,iExchRate,idamount,icamount,idamount_f,icamount_f,idamount_s,icamount_s,cSSCode,cProcStyle,ccancelno,cpzid,bprepay,iFlag,cCoVouchType,cCoVouchID,cFlag,iClosesID,icoclosesid,cglsign,iglno_id,dPZDate,cAccountPDate)values (8,'48','0000003950','2019-08-15 00:00:00.000','2019-08-20 00:00:00.000','SEM653D-1135',NULL,'112201',NULL,NULL,8,3,'收周朝豪购SEM653D-1135车款',0,'人民币',1,0.00,12800.00,0.00,12800.00,0,0,'202','48','AR480000003950','AR0000000000157',0,0,48,'0000003950','AR',6068,6068,'金','20','2019-08-15 00:00:00.000','2019-08-20 00:00:00.000') 在20年度执行 INSERT INTO Ap_CloseBill(cvouchtype,cvouchid,dvouchdate,iperiod,cdwcode,cItem_Class,cItemCode,cSSCode,cDigest,cexch_name,iexchrate,iamount,iamount_f,iramount,iRAmount_f,cOperator,bPrePay,bStartFlag,ccode,ipayforother,cpzid,cflag,bsend,breceived,iid,bFromBank,btobank,bSure,vt_id,ccheckman,citemname) VALUES ('48','0000003950','2019-08-15 00:00:00.000',0,'SEM653D-1135','98','01','101','收周朝豪购SEM653D-1135车款','人民币',1,12800.00,12800.00,12800.00,12800.00,'张丽萍',0,0,'100201',0,NULL,'AR',0,0,6059,0,0,0,8052,'张丽萍','销售商品、提供劳务收到的现金') INSERT INTO Ap_CloseBills(iid,id,itype,bprepay,ccusven,iamt_f,iAmt,iRAmt_f,iRAmt,ckm) VALUES (6059,6068,0,0,'SEM653D-1135',12800.00,12800.00,12800.00,12800.00,'112201') insert into ap_detail (iperiod ,cvouchtype,cvouchstype,cvouchid,dVouchDate,dRegDate,cdwcode,cdeptcode,cCode,citem_class,cItemCode,isignseq,ino_id,cdigest,iprice,cexch_name,iExchRate,idamount,icamount,idamount_f,icamount_f,idamount_s,icamount_s,cSSCode,cProcStyle,ccancelno,cpzid,bprepay,iFlag,cCoVouchType,cCoVouchID,cFlag,iClosesID,icoclosesid,cglsign,iglno_id,dPZDate,cAccountPDate)values (0,'48',3,'0000003950','2019-08-15 00:00:00.000','2019-08-20 00:00:00.000','SEM653D-1135',NULL,'112201',NULL,NULL,0,NULL,'收周朝豪购SEM653D-1135车款',0,'人民币',1,0.00,12800.00,0.00,12800.00,0,0,'202','48','JZ480000003950',NULL,0,0,48,'0000003950','AR',6068,6068,NULL,NULL,'2019-08-15 00:00:00.000','2019-08-20 00:00:00.000')
客服电话:400-665-0028
关键字:用友财务软件,畅捷通软件,财务软件,进销存软件,U9官网,用友U8,用友T1,用友T+,用友T3,用友T6,畅捷通好会计,好生意,智+好业财,用友培训服务售后公司,畅捷通运营培训服务公司
版权所有:用友畅捷通软件 Copyright © 2025 All rights reserved.