| 產品版本: | 85-U6普及版3.2 | 適用產品: | T6系列 |
| 產品模塊: | 18-庫存管理 | 提交時間: | 2012-06-12 |
| 問題現象: |
產成品入庫單審核不通過，提示“單據審核失敗，修改或稍后再試！Violation of UNIQUE KEY constraint 'Currentstock_ind'. Cannot insert duplicate key in object'CurrentStock'. 現存量處理沒有成功，可能有其他用戶正在處理。” | ||
| 原因分析: |
單據的第十三條記錄涉及的自由項3有非法空格，并寫入現存量表，導致單據不能審核。 | ||
| 解決方案: |
請備份好賬套并執行以下語句。 （參考示例語句） update CurrentStock set cFree3='1- 色號XC1/0.2' Where cWhcode='08' And cInvCode ='705003005' And cFree1 ='合格' And cFree2 ='鐵桶(225kg)' And cFree3=' 1- 色號XC1/0.2' And cFree4 ='76.8' And cFree5 ='171.4' And cFree6 ='XC1.8/0.4' And cFree7 ='' And cFree8 ='0.97' And cFree9 ='5.8' And cFree10 ='THAA28.46' And cBatch ='08080702' update RdRecords set cFree3='1- 色號XC1/0.2' Where cInvCode ='705003005' And cFree1 ='合格' And cFree2 ='鐵桶(225kg)' And cFree3=' 1- 色號XC1/0.2' And cFree4 ='76.8' And cFree5 ='171.4' And cFree6 ='XC1.8/0.4' And cFree7 is NULL And cFree8 ='0.97' And cFree9 ='5.8' And cFree10 ='THAA28.46' | ||