| 产品版本: | 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' | ||