单据审核失败
- 浏览：2006 - 发布时间：2008-08-26 22:56:07.0
| 问题版本: |
85-U6普及版3.2 |
问题模块: |
18-库存管理 |
| 所属行业: |
0-通用 |
问题状态: |
1-UU通注册用户 |
| 关 键 字: |
单据审核失败 |
适用产品: |
|
| 补 丁 号: |
|
开放状态: |
0-UU通注册用户 |
| 原问题号: |
|
提交时间: |
2008-8-26 22:56:07 |
| 问题名称: |
单据审核失败 |
| 问题现象: |
产成品入库单审核不通过，提示“单据审核失败，修改或稍后再试！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' | |
