| 產品版本: | 1016-用友T6-小企業管理軟件 5.0 | 適用產品: | T6系列 |
| 產品模塊: | 15-采購管理 | 提交時間: | 2012-06-12 |
| 問題現象: | 在錄入BOM子件時無法參照存貨檔案 | ||
| 原因分析: |
通過跟蹤發現，是執行查詢語句select (Inventory.cInvCode) as cInvCode,cInvAddCode,cInvName,cInvStd,(Inventory.cInvCCode) as cInvCCode,(Inventory.dSDate) as dSDate,(Inventory.dEDate) as dEDate from Inventory left join ComputationUnit on ComputationUnit.cComUnitCode=Inventory.cComunitCode where ((cinvcode like '%cm%' OR cinvname like '%cm%' OR cinvaddcode like '%cm%') and (isnull( iPlanPolicy,0)=1 or isnull( iPlanPolicy,0)=0 or isnull( iPlanPolicy,0)=2) and bService = 0 And bInvType = 0 And isnull(dEDate,'2010-11-16 00:00:00.000') >= '2010-11-16 00:00:00.000' And (1=1) ) and (1=1) Order by cInvCode ASC 時不滿足條件，存貨檔案中默認 iPlanPolicy值為-1。
| ||
| 解決方案: |
將所有存貨的 iPlanPolicy列修改為0或者1或者2。update inventory set iPlanPolicy=1 | ||