| 解决方案： |
Update JustInvouch Set cAccounter='李上开' Where cJVCode='0000000061'
cBusCode 对应业务单号 出入库单 business
cBusType 业务类型 business
insert 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,cFre
e2,cFree3,cFree4,cFree5,cFree6,cFree7,cFree8,cFree9,cFree10,cdefine22,c
define23,cdefine24,cdefine25,cdefine26,cdefine27,cdefine28,cdefine29,cd
efine30,cdefine31,cdefine32,cdefine33,cdefine34,cdefine35,cdefine36,cde
fine37,citem_class,citemcode,citemcname,cVenCode,cHandler,cOrderCode,cA
RVCode,cName)
values
(0,null,null,'0000000061',63,null,63,'2004-08-31','2004-08-31',8,60,nul
l,null,'21',null,null,'019','1153D100M0405',null,null,null,null,null,nu
ll,null,null,null,null,null,null,null,null,-1604283.44,null,null,null,'
李上开','李上开',null,1,0,'test',null,null,null,null,null,null,0,null,n
ull,null,null,null,null,null,null,0,null,null,null,null,null,null,null,
null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,nu
ll,null,null,null,null,null,null,null,null,null,null,null)
无误
2.最后发现客户仓库同名 但是仓库编码不一样 原因客户从821升级上来 以前编码
为19 现已经改为019 客户调整单做的都是对以前仓库的调整，查询明细帐即可 |