[KB 75594功能解说] 导入存货变动时报错“存货变动明细错误!”
[b]* 本文由赛捷软件(上海)有限公司翻译完成,未经授权不得转载。如需转载,请先联系相应版块的版主取得授权。[/b][b]产品[/b]
Sage X3
[b]国家[/b]
北美
[b]类别[/b]
配置
工作流
[b]描述[/b]
在导入存货变动时,你可能会看到一条报错,显示“错误数2”或类似的内容。日志中的错误将显示如下内容:
[b] 错误在行:1
不完整的行:
没有录入的存货交易
存货变动明细错误![/b]
X3的老版本(例如V6.4 P19)可能会显示略有不同的报错:
[b] 错误在行:1
不完整的行:
没有录入的存货的交易
存货变动明细错误![/b]
这也可能导致存货→内部交易→存货变动(GESSCS)屏幕中的“可用”列在真正应该有非零值时显示为零。例如,如果你有25个可用数量,并且你执行了一项存货变动,将15个数量从这个库位移动到了另一个库位,但由于此问题而造成了失败,那么这个屏幕中的可用数量现在将显示为0。
[b]原因[/b]
在使用SCS模板导出时,它将创建一个负数行。在重新导入至Sage X3之前,应该删除这个负数行。导入并不需要它。
"E","","D22",110517,"","",""
"L",1000,"22322","EA",1,"A","RCK","RK0102","","","","","","","D22"
"S","EA",1,1,"RK0102","A"
[b] "S","EA",-[color=Red]1,-1[/color],"RK0205","A" <--- 负数行[/b]
[b]解决方法[/b]
通过移除负数行,更正导入文件。请注意,这种精确的格式布局仅适用于非定制的SCS导入模板。定制版本可能有不同的要求。
• [b]无效的导入[/b]文件看起来如下:
"E","","D22",110517,"","",""
"L",1000,"22322","EA",1,"A","RCK","RK0102","","","","","","","D22"
"S","EA",[b]1,1[/b],"RK0205","A"
[b]"S","EA",[color=Red]-1,-1[/color],"RK0102","A" <-- 负数行[/b]
或者
"E","","D22",110517,"","",""
"L",1000,"22322","EA",1,"A","RCK","RK0102","","","","","","","D22"
[b]"S","EA",[color=Red]-1,-1[/color],"RK0102","A" <-- 负数行[/b]
"S","EA",[b]1,1[/b],"RK0205","A"
• 对于未定制/封装的导入模板[b]SCS[/b]的[b]有效导入[/b]文件看起来如下(删除了负数行):
"E","","D22",110517,"","",""
"L",1000,"22322","EA",1,"A","RCK","RK0102","","","","","","","D22"
"S","EA",1,1,"RK0205","A"
[b]请注意:[/b]在导入尝试失败后,存货变更屏幕中的[b]可用[/b]值可能会变得不正确。如果存货变更屏幕中的[b]可用[/b]值不正确,请让有SQL经验的人联系Sage支持。
页:
[1]