[KB224924950075594功能解说] 导入存货变动时出现报错:“错误的存货交易明细!”
[b]* 本文由赛捷软件(上海)有限公司翻译完成,未经授权不得转载。如需转载,请先联系相应版块的版主取得授权。导入存货变动时出现报错:“错误的存货交易明细!”[/b]
创建日期:2021-07-05
最后修改日期:2021-07-05
[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",1,1,"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",1,1,"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]