用友U8 采购期初入库单生成发票结算后没有生成红蓝回冲单用友U8 采购期初入库单生成发票结算后没有生成红蓝回冲单
问题原因:这张入库单在07年的数据中并没有找到,所以应该是客户在2008年结转后,恢复了采购的期初记账,手工填了这张期初采购入库单,导致存货核算中没有该期初采购入库单的记录,所以无法结算成本处理,生成回冲单; 解决方法:这张入库单在07年的数据中并没有找到,所以应该是客户在2008年结转后,恢复了采购的期初记账,手工填了这张期初采购入库单,导致存货核算中没有该期初采购入库单的记录,所以无法结算成本处理,生成回冲单;注意在插入记录时注意iaprice、facost不要为NULL否则到年底结转时存货明细帐结转不过去。update b set cbaccounter='吴志强'from rdrecord a inner join rdrecords b on a.id=b.id where bpufirst=1 and autoid not in (select id from ia_subsidiary where cvoutype='33')and cbaccounter is nullinsert into IA_Subsidiary (bRdFlag, cBusType, cBusCode, cVouCode, ID, ValueID, JustID, dVouDate,dKeepDate, iMonth, iPZID, cInvHead, cDifHead, cVouType, cPTCode, cSTCode,cWhCode, cInvCode,cAccDep, cRdCode, cCusCode,cBillCode, cDLCode, cPSPCode, cProCode, cDepCode,cPersonCode,iAInQuantity,iAOutQuantity, iInCost, iOutCost,iAInPrice, iAOutPrice,iDebitDifCost, iCreditDifCost,cBatchCode, cMaker,cAccounter, bFlag, bMoneyFlag, bSale, cMemo,cDefine1, cDefine2, cDefine3,cDefine4, cDefine5, cDefine6,cDefine7, cDefine8, cDefine9,cDefine10, cDefine11,cDefine12,cDefine13,cDefine14,cDefine15,cDefine16,cFree1,cFree2,cFree3,cFree4,cFree5,cFree6,cFree7,cFree8,cFree9,cFree10,cdefine22,cdefine23,cdefine24,cdefine25,cdefine26,cdefine27,cdefine28,cdefine29,cdefine30,cdefine31,cdefine32,cdefine33,cdefine34,cdefine35,cdefine36,cdefine37,citem_class,citemcode,citemcname,cVenCode,cHandler,cOrderCode,imaterialfee,iprocessfee,cSRcVouType)select bRdFlag, cBusType, cBusCode, cCode, autoID, null, 0, dDate,'2008-01-01', 0,b.ID, null, null, '33', cPTCode, cSTCode,cWhCode, cInvCode,cDepcode, cRdCode, cCusCode,null, null, null, null, null,cPersonCode,iQuantity,null, iunitCost, null,iPrice, null,null,null,null, cMaker,cbAccounter, 1, 1, 0, cMemo,cDefine1, cDefine2, cDefine3,cDefine4, cDefine5, cDefine6,cDefine7, cDefine8, cDefine9,cDefine10, cDefine11,cDefine12,cDefine13,cDefine14,cDefine15,cDefine16,cFree1,cFree2,cFree3,cFree4,cFree5,cFree6,cFree7,cFree8,cFree9,cFree10,cdefine22,cdefine23,cdefine24,cdefine25,cdefine26,cdefine27,cdefine28,cdefine29,cdefine30,cdefine31,cdefine32,cdefine33,cdefine34,cdefine35,cdefine36,cdefine37,null,null,null,cVenCode,cHandler,null,0,iaprice,'01' from rdrecord a inner join rdrecords b on a.id=b.id where bpufirst=1 and autoid not in (select id from ia_subsidiary where cvoutype='33')
解决方案:
问题原因:这张入库单在07年的数据中并没有找到,所以应该是客户在2008年结转后,恢复了采购的期初记账,手工填了这张期初采购入库单,导致存货核算中没有该期初采购入库单的记录,所以无法结算成本处理,生成回冲单; 解决方法:这张入库单在07年的数据中并没有找到,所以应该是客户在2008年结转后,恢复了采购的期初记账,手工填了这张期初采购入库单,导致存货核算中没有该期初采购入库单的记录,所以无法结算成本处理,生成回冲单;注意在插入记录时注意iaprice、facost不要为NULL否则到年底结转时存货明细帐结转不过去。update b set cbaccounter='吴志强'from rdrecord a inner join rdrecords b on a.id=b.id where bpufirst=1 and autoid not in (select id from ia_subsidiary where cvoutype='33')and cbaccounter is nullinsert into IA_Subsidiary (bRdFlag, cBusType, cBusCode, cVouCode, ID, ValueID, JustID, dVouDate,dKeepDate, iMonth, iPZID, cInvHead, cDifHead, cVouType, cPTCode, cSTCode,cWhCode, cInvCode,cAccDep, cRdCode, cCusCode,cBillCode, cDLCode, cPSPCode, cProCode, cDepCode,cPersonCode,iAInQuantity,iAOutQuantity, iInCost, iOutCost,iAInPrice, iAOutPrice,iDebitDifCost, iCreditDifCost,cBatchCode, cMaker,cAccounter, bFlag, bMoneyFlag, bSale, cMemo,cDefine1, cDefine2, cDefine3,cDefine4, cDefine5, cDefine6,cDefine7, cDefine8, cDefine9,cDefine10, cDefine11,cDefine12,cDefine13,cDefine14,cDefine15,cDefine16,cFree1,cFree2,cFree3,cFree4,cFree5,cFree6,cFree7,cFree8,cFree9,cFree10,cdefine22,cdefine23,cdefine24,cdefine25,cdefine26,cdefine27,cdefine28,cdefine29,cdefine30,cdefine31,cdefine32,cdefine33,cdefine34,cdefine35,cdefine36,cdefine37,citem_class,citemcode,citemcname,cVenCode,cHandler,cOrderCode,imaterialfee,iprocessfee,cSRcVouType)select bRdFlag, cBusType, cBusCode, cCode, autoID, null, 0, dDate,'2008-01-01', 0,b.ID, null, null, '33', cPTCode, cSTCode,cWhCode, cInvCode,cDepcode, cRdCode, cCusCode,null, null, null, null, null,cPersonCode,iQuantity,null, iunitCost, null,iPrice, null,null,null,null, cMaker,cbAccounter, 1, 1, 0, cMemo,cDefine1, cDefine2, cDefine3,cDefine4, cDefine5, cDefine6,cDefine7, cDefine8, cDefine9,cDefine10, cDefine11,cDefine12,cDefine13,cDefine14,cDefine15,cDefine16,cFree1,cFree2,cFree3,cFree4,cFree5,cFree6,cFree7,cFree8,cFree9,cFree10,cdefine22,cdefine23,cdefine24,cdefine25,cdefine26,cdefine27,cdefine28,cdefine29,cdefine30,cdefine31,cdefine32,cdefine33,cdefine34,cdefine35,cdefine36,cdefine37,null,null,null,cVenCode,cHandler,null,0,iaprice,'01' from rdrecord a inner join rdrecords b on a.id=b.id where bpufirst=1 and autoid not in (select id from ia_subsidiary where cvoutype='33')