| 解决方案： |
执行下列语句，即可解决供应商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 |