用友U8 应付款管理〉帐表管理〉业务帐表〉与总帐对帐,供应商hzzmhd,qdghhy应付票据总帐有400000的贷方发生额,应付系统没有,但实际上应付明细帐可以查询到相应的单据和凭证,为何在对帐时,应付系统不显示?用友U8 应付款管理〉帐表管理〉业务帐表〉与总帐对帐,供应商hzzmhd,qdghhy应付票据总帐有400000的贷方发生额,应付系统没有,但实际上应付明细帐可以查询到相应的单据和凭证,为何在对帐时,应付系统不显示?
问题原因:经检查,发现付款单在生成凭证的时候少生成了一条记录。因此导致与总帐对不平。 解决方法:执行下列语句,即可解决供应商hzzmhd,qdghhy对帐不平的现象。 另,该语句只能执行一遍,并请在执行之前做好数据备份。 INSERT INTO [UFDATA_005_2005].[dbo].[Ap_Detail]([iPeriod], [cVouchType], [cVouchSType], [cVouchID], [dVouchDate], [dRegDate], [cDwCode], [cDeptCode], [cPerson], [cInvCode], [iBVid], [cCode], [cItem_Class], [cItemCode], [csign], [isignseq], [ino_id], [cDigest], [iPrice], [cexch_name], [iExchRate], [iDAmount], [iCAmount], [iDAmount_f], [iCAmount_f], [iDAmount_s], [iCAmount_s], [cOrderNo], [cSSCode], [cPayCode], [cProcStyle], [cCancelNo], [cPZid], [bPrePay], [iFlag], [cCoVouchType], [cCoVouchID], [cFlag], [cDefine1], [cDefine2], [cDefine3], [cDefine4], [cDefine5], [cDefine6], [cDefine7], [cDefine8], [cDefine9], [cDefine10], [iClosesID], [iCoClosesID], [cDefine11], [cDefine12], [cDefine13], [cDefine14], [cDefine15], [cDefine16], [cGLSign], [iGLno_id], [dPZDate], [cItemName], [cContractType], [cContractID], [BalancesGuid], [dHideDate]) select 4,'49','49','2005042700188','2005-04-27','2005-04-27','HZZMHD',NULL,NULL,NULL,0,'2111',NULL,NULL,NULL,4,2,'付款单',0.0,'人民币',1.0,.0000,400000.0000,.0000,400000.0000,0.0,0.0,NULL,null,NULL,'49','AP492005042700188','AP0000000000200',0,3,'49','2005042700188','AP',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,'转',15,'2005-04-28',NULL,NULL,NULL,NULL,NULL INSERT INTO [UFDATA_005_2005].[dbo].[Ap_Detail]([iPeriod], [cVouchType], [cVouchSType], [cVouchID], [dVouchDate], [dRegDate], [cDwCode], [cDeptCode], [cPerson], [cInvCode], [iBVid], [cCode], [cItem_Class], [cItemCode], [csign], [isignseq], [ino_id], [cDigest], [iPrice], [cexch_name], [iExchRate], [iDAmount], [iCAmount], [iDAmount_f], [iCAmount_f], [iDAmount_s], [iCAmount_s], [cOrderNo], [cSSCode], [cPayCode], [cProcStyle], [cCancelNo], [cPZid], [bPrePay], [iFlag], [cCoVouchType], [cCoVouchID], [cFlag], [cDefine1], [cDefine2], [cDefine3], [cDefine4], [cDefine5], [cDefine6], [cDefine7], [cDefine8], [cDefine9], [cDefine10], [iClosesID], [iCoClosesID], [cDefine11], [cDefine12], [cDefine13], [cDefine14], [cDefine15], [cDefine16], [cGLSign], [iGLno_id], [dPZDate], [cItemName], [cContractType], [cContractID], [BalancesGuid], [dHideDate]) select 4,'49','49','2005041500128','2005-04-15' ,'2005-04-15' ,'QDGFHY','01','YWZJH',NULL,0,'2111',NULL,NULL,NULL,4,2,'付248号凭证 支付货款',0.0,'人民币',1.0,.0000,200000.0000,.0000,200000.0000,0.0,0.0,NULL,null,NULL,'49','AP492005041500128','AP0000000000159',0,3,'49','2005041500128','AP',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,'转',11,'2005-04-28',NULL,NULL,NULL,NULL,NULL INSERT INTO [UFDATA_005_2005].[dbo].[Ap_Detail]([iPeriod], [cVouchType], [cVouchSType], [cVouchID], [dVouchDate], [dRegDate], [cDwCode], [cDeptCode], [cPerson], [cInvCode], [iBVid], [cCode], [cItem_Class], [cItemCode], [csign], [isignseq], [ino_id], [cDigest], [iPrice], [cexch_name], [iExchRate], [iDAmount], [iCAmount], [iDAmount_f], [iCAmount_f], [iDAmount_s], [iCAmount_s], [cOrderNo], [cSSCode], [cPayCode], [cProcStyle], [cCancelNo], [cPZid], [bPrePay], [iFlag], [cCoVouchType], [cCoVouchID], [cFlag], [cDefine1], [cDefine2], [cDefine3], [cDefine4], [cDefine5], [cDefine6], [cDefine7], [cDefine8], [cDefine9], [cDefine10], [iClosesID], [iCoClosesID], [cDefine11], [cDefine12], [cDefine13], [cDefine14], [cDefine15], [cDefine16], [cGLSign], [iGLno_id], [dPZDate], [cItemName], [cContractType], [cContractID], [BalancesGuid], [dHideDate]) select 4,'49','49','2005042800189','2005-04-28','2005-04-28 ','QDGFHY',NULL,NULL,NULL,0,'2111',NULL,NULL,NULL,4,2,'付款单',0.0,'人民币',1.0,.0000,200000.0000,.0000,200000.0000,0.0,0.0,NULL,null,NULL,'49','AP492005042800189','AP0000000000201',0,3,'49','2005042800189','AP',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,'转',16,'2005-04-28',NULL,NULL,NULL,NULL,NULL
解决方案:
问题原因:经检查,发现付款单在生成凭证的时候少生成了一条记录。因此导致与总帐对不平。 解决方法:执行下列语句,即可解决供应商hzzmhd,qdghhy对帐不平的现象。 另,该语句只能执行一遍,并请在执行之前做好数据备份。 INSERT INTO [UFDATA_005_2005].[dbo].[Ap_Detail]([iPeriod], [cVouchType], [cVouchSType], [cVouchID], [dVouchDate], [dRegDate], [cDwCode], [cDeptCode], [cPerson], [cInvCode], [iBVid], [cCode], [cItem_Class], [cItemCode], [csign], [isignseq], [ino_id], [cDigest], [iPrice], [cexch_name], [iExchRate], [iDAmount], [iCAmount], [iDAmount_f], [iCAmount_f], [iDAmount_s], [iCAmount_s], [cOrderNo], [cSSCode], [cPayCode], [cProcStyle], [cCancelNo], [cPZid], [bPrePay], [iFlag], [cCoVouchType], [cCoVouchID], [cFlag], [cDefine1], [cDefine2], [cDefine3], [cDefine4], [cDefine5], [cDefine6], [cDefine7], [cDefine8], [cDefine9], [cDefine10], [iClosesID], [iCoClosesID], [cDefine11], [cDefine12], [cDefine13], [cDefine14], [cDefine15], [cDefine16], [cGLSign], [iGLno_id], [dPZDate], [cItemName], [cContractType], [cContractID], [BalancesGuid], [dHideDate]) select 4,'49','49','2005042700188','2005-04-27','2005-04-27','HZZMHD',NULL,NULL,NULL,0,'2111',NULL,NULL,NULL,4,2,'付款单',0.0,'人民币',1.0,.0000,400000.0000,.0000,400000.0000,0.0,0.0,NULL,null,NULL,'49','AP492005042700188','AP0000000000200',0,3,'49','2005042700188','AP',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,'转',15,'2005-04-28',NULL,NULL,NULL,NULL,NULL INSERT INTO [UFDATA_005_2005].[dbo].[Ap_Detail]([iPeriod], [cVouchType], [cVouchSType], [cVouchID], [dVouchDate], [dRegDate], [cDwCode], [cDeptCode], [cPerson], [cInvCode], [iBVid], [cCode], [cItem_Class], [cItemCode], [csign], [isignseq], [ino_id], [cDigest], [iPrice], [cexch_name], [iExchRate], [iDAmount], [iCAmount], [iDAmount_f], [iCAmount_f], [iDAmount_s], [iCAmount_s], [cOrderNo], [cSSCode], [cPayCode], [cProcStyle], [cCancelNo], [cPZid], [bPrePay], [iFlag], [cCoVouchType], [cCoVouchID], [cFlag], [cDefine1], [cDefine2], [cDefine3], [cDefine4], [cDefine5], [cDefine6], [cDefine7], [cDefine8], [cDefine9], [cDefine10], [iClosesID], [iCoClosesID], [cDefine11], [cDefine12], [cDefine13], [cDefine14], [cDefine15], [cDefine16], [cGLSign], [iGLno_id], [dPZDate], [cItemName], [cContractType], [cContractID], [BalancesGuid], [dHideDate]) select 4,'49','49','2005041500128','2005-04-15' ,'2005-04-15' ,'QDGFHY','01','YWZJH',NULL,0,'2111',NULL,NULL,NULL,4,2,'付248号凭证 支付货款',0.0,'人民币',1.0,.0000,200000.0000,.0000,200000.0000,0.0,0.0,NULL,null,NULL,'49','AP492005041500128','AP0000000000159',0,3,'49','2005041500128','AP',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,'转',11,'2005-04-28',NULL,NULL,NULL,NULL,NULL INSERT INTO [UFDATA_005_2005].[dbo].[Ap_Detail]([iPeriod], [cVouchType], [cVouchSType], [cVouchID], [dVouchDate], [dRegDate], [cDwCode], [cDeptCode], [cPerson], [cInvCode], [iBVid], [cCode], [cItem_Class], [cItemCode], [csign], [isignseq], [ino_id], [cDigest], [iPrice], [cexch_name], [iExchRate], [iDAmount], [iCAmount], [iDAmount_f], [iCAmount_f], [iDAmount_s], [iCAmount_s], [cOrderNo], [cSSCode], [cPayCode], [cProcStyle], [cCancelNo], [cPZid], [bPrePay], [iFlag], [cCoVouchType], [cCoVouchID], [cFlag], [cDefine1], [cDefine2], [cDefine3], [cDefine4], [cDefine5], [cDefine6], [cDefine7], [cDefine8], [cDefine9], [cDefine10], [iClosesID], [iCoClosesID], [cDefine11], [cDefine12], [cDefine13], [cDefine14], [cDefine15], [cDefine16], [cGLSign], [iGLno_id], [dPZDate], [cItemName], [cContractType], [cContractID], [BalancesGuid], [dHideDate]) select 4,'49','49','2005042800189','2005-04-28','2005-04-28 ','QDGFHY',NULL,NULL,NULL,0,'2111',NULL,NULL,NULL,4,2,'付款单',0.0,'人民币',1.0,.0000,200000.0000,.0000,200000.0000,0.0,0.0,NULL,null,NULL,'49','AP492005042800189','AP0000000000201',0,3,'49','2005042800189','AP',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,'转',16,'2005-04-28',NULL,NULL,NULL,NULL,NULL
www.kuaiji66.com 天龙瑞德