T3 10.8结转供应链时提示：发货单子表错误

arthurke · 发表于 2013-1-21 15:42:09

马上注册，结交更多好友，享用更多功能，让你轻松玩转社区。

您需要登录才可以下载或查看，没有账号？注册账号

×

T3 10.8结转供应链时提示：发货单子表错误

请哪位大侠帮忙一下啊？

wozengcong · 发表于 2013-1-21 18:34:00

这个必须跟踪数据库才能判断

蓝银草 · 发表于 2013-1-21 18:46:38

{:soso_e199:}

arthurke · 发表于 2013-1-22 14:04:33

请问数据库如何跟踪啊？

arthurke · 发表于 2013-1-22 15:09:28

INSERT INTO Dispatchlists(DLID,iCorID,cWhCode,cInvCode,iQuantity,iNum,iQuotedPrice,iUnitPrice,iTaxUnitPrice,iMoney,iTax,iSum,iDisCount,iNatUnitPrice, iNatMoney,iNatTax,iNatSum,iNatDisCount,iSettleNum,iSettleQuantity,iBatch,cBatch,bSettleAll,cMemo,cFree1,cFree2, RdsID, iTB, dVDate, TBQuantity, TBNum,iSOsID,iDLsID,KL,KL2,cInvName,iTaxRate,cDefine22,cDefine23,cDefine24,cDefine25,cDefine26,cDefine27,fOutQuantity,fOutNum,cItemCode,cItem_Class,cItemName,cItem_CName,fSaleCost,fSalePrice,iInvExchRate) Select DispatchList.DLID,UFDATA_003_2012..DispatchLists.iCorID,UFDATA_003_2012..DispatchLists.cWhCode,UFDATA_003_2012..DispatchLists.cInvCode,UFDATA_003_2012..DispatchLists.iQuantity,UFDATA_003_2012..DispatchLists.iNum,UFDATA_003_2012..DispatchLists.iQuotedPrice,UFDATA_003_2012..DispatchLists.iUnitPrice,UFDATA_003_2012..DispatchLists.iTaxUnitPrice,UFDATA_003_2012..DispatchLists.iMoney,UFDATA_003_2012..DispatchLists.iTax,UFDATA_003_2012..DispatchLists.iSum,UFDATA_003_2012..DispatchLists.iDisCount,UFDATA_003_2012..DispatchLists.iNatUnitPrice,UFDATA_003_2012..DispatchLists.iNatMoney,UFDATA_003_2012..DispatchLists.iNatTax,UFDATA_003_2012..DispatchLists.iNatSum,UFDATA_003_2012..DispatchLists.iNatDisCount,UFDATA_003_2012..DispatchLists.iSettleNum,UFDATA_003_2012..DispatchLists.iSettleQuantity,UFDATA_003_2012..DispatchLists.iBatch,UFDATA_003_2012..DispatchLists.cBatch,UFDATA_003_2012..DispatchLists.bSettleAll,DispatchList.cMemo,UFDATA_003_2012..DispatchLists.cFree1,UFDATA_003_2012..DispatchLists.cFree2, UFDATA_003_2012..DispatchLists.RdsID, UFDATA_003_2012..DispatchLists.iTB, UFDATA_003_2012..DispatchLists.dVDate, UFDATA_003_2012..DispatchLists.TBQuantity, UFDATA_003_2012..DispatchLists.TBNum,UFDATA_003_2012..DispatchLists.iSOsID,UFDATA_003_2012..DispatchLists.iDLsID,UFDATA_003_2012..DispatchLists.KL,UFDATA_003_2012..DispatchLists.KL2,UFDATA_003_2012..DispatchLists.cInvName,DispatchList.iTaxRate,UFDATA_003_2012..DispatchLists.cDefine22,UFDATA_003_2012..DispatchLists.cDefine23,UFDATA_003_2012..DispatchLists.cDefine24,UFDATA_003_2012..DispatchLists.cDefine25,UFDATA_003_2012..DispatchLists.cDefine26,UFDATA_003_2012..DispatchLists.cDefine27,UFDATA_003_2012..DispatchLists.fOutQuantity,UFDATA_003_2012..DispatchLists.fOutNum,UFDATA_003_2012..DispatchLists.cItemCode,UFDATA_003_2012..DispatchLists.cItem_Class, UFDATA_003_2012..DispatchLists.cItemName,UFDATA_003_2012..DispatchLists.cItem_CName, UFDATA_003_2012..DispatchLists.fSaleCost, UFDATA_003_2012..DispatchLists.fSalePrice,UFDATA_003_2012..DispatchLists.iInvExchRate FROM UFDATA_003_2012..DispatchLists INNER JOIN DispatchList ON UFDATA_003_2012..DispatchLists.DLID = DispatchList.DLID WHERE ISNULL(DispatchList.cVerifier,'')<>'' AND DispatchList.cVouchType='05' AND ISNULL(UFDATA_003_2012..DispatchLists.cWhCode,'')<>'' AND ISNULL(DispatchList.cSTCode,'')<>'' AND ISNULL(DispatchList.iSale,0)=0 AND NOT UFDATA_003_2012..DispatchLists.iDLsID IN (SELECT iDLsID FROM UFDATA_003_2013..DispatchLists) AND (CASE WHEN ISNULL(UFDATA_003_2012..DispatchLists.iNum,0) <>0 THEN (ABS(ISNULL(UFDATA_003_2012..DispatchLists.fOutQuantity,0))-ABS(UFDATA_003_2012..DispatchLists.iQuantity))*(ABS(ISNULL(UFDATA_003_2012..DispatchLists.fOutNum,0))-ABS(UFDATA_003_2012..DispatchLists.iNum)) ELSE ABS(ISNULL(UFDATA_003_2012..DispatchLists.fOutQuantity,0))-ABS(UFDATA_003_2012..DispatchLists.iQuantity) END) <>0

数据库跟踪如下，请大侠帮忙看一下哦

arthurke · 发表于 2013-1-23 15:30:34

arthurke 发表于 2013-1-22 15:09

登录/注册后可看大图

INSERT INTO Dispatchlists(DLID,iCorID,cWhCode,cInvCode,iQuantity,iNum,iQuotedPrice,iUnitPrice,iTaxUn ...

自己再顶一下，哪位大侠帮忙分析一下啊！

lqbadboy1 · 发表于 2013-1-23 15:50:55

数据跟踪，然后查询

arthurke · 发表于 2013-1-23 16:11:07

lqbadboy1 发表于 2013-1-23 15:50

登录/注册后可看大图

数据跟踪，然后查询

如何数据跟踪，查询？请大侠明示

wpsdujin · 发表于 2013-1-24 17:20:25

没有提示字段相关错误，应该就是最大单据号出错！！！！

zhezhe2009 · 发表于 2015-1-2 19:00:28

楼主问题处理了吗？怎么处理的？

账号		自动登录	找回密码
密码			注册账号

初学者课程：T3自学\|T6自学\|U8自学	软件下载｜课件下载｜工具下载	资料：通资料\|U8资料\|NC\|培训\|年结	积分规则 \| 使用常见问题Q&A
知识库:U8 \| 通 \| NC \| U9 \| OA \| 政务	U8\|U9\|NCC\|NC65\|NC65客开\|NCC客开	新手必读 \| 任务 \| 快速增金币	用友QQ群[微信群]

[求助] T3 10.8结转供应链时提示：发货单子表错误

马上注册，结交更多好友，享用更多功能，让你轻松玩转社区。

相关帖子

点评