精細(xì)管理 · 敏捷經(jīng)營 · 快速應(yīng)用
規(guī)范流程 · 提升效益
規(guī)范管理 · 精細(xì)理財(cái)
| 產(chǎn)品版本: | 85-U6普及版3.2 | 適用產(chǎn)品: | T6系列 |
| 產(chǎn)品模塊: | 18-庫存管理 | 提交時(shí)間: | 2012-06-12 |
| 問題現(xiàn)象: |
產(chǎn)成品入庫單審核不通過，提示“單據(jù)審核失敗，修改或稍后再試！Violation of UNIQUE KEY constraint 'Currentstock_ind'. Cannot insert duplicate key in object'CurrentStock'. 現(xiàn)存量處理沒有成功，可能有其他用戶正在處理。” | ||
| 原因分析: |
單據(jù)的第十三條記錄涉及的自由項(xiàng)3有非法空格，并寫入現(xiàn)存量表，導(dǎo)致單據(jù)不能審核。 | ||
| 解決方案: |
請(qǐng)備份好賬套并執(zhí)行以下語句。 （參考示例語句） update CurrentStock set cFree3='1- 色號(hào)XC1/0.2' Where cWhcode='08' And cInvCode ='705003005' And cFree1 ='合格' And cFree2 ='鐵桶(225kg)' And cFree3=' 1- 色號(hào)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- 色號(hào)XC1/0.2' Where cInvCode ='705003005' And cFree1 ='合格' And cFree2 ='鐵桶(225kg)' And cFree3=' 1- 色號(hào)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' | ||