赛捷软件论坛 - Powered by Discuz! Board

标题: [KB 75594功能解说] 导入存货变动时报错“存货变动明细错误！” [打印本页]

作者: lynn.yu 时间: 2020-2-3 11:16 标题: [KB 75594功能解说] 导入存货变动时报错“存货变动明细错误！”

* 本文由赛捷软件（上海）有限公司翻译完成，未经授权不得转载。如需转载，请先联系相应版块的版主取得授权。

产品
Sage X3

国家
北美

类别
配置
工作流

描述
在导入存货变动时，你可能会看到一条报错，显示“错误数2”或类似的内容。日志中的错误将显示如下内容：
错误在行：1
不完整的行：
没有录入的存货交易
存货变动明细错误！

X3的老版本(例如V6.4 P19)可能会显示略有不同的报错：
错误在行：1
不完整的行：
没有录入的存货的交易
存货变动明细错误！

这也可能导致存货→内部交易→存货变动（GESSCS）屏幕中的“可用”列在真正应该有非零值时显示为零。例如，如果你有25个可用数量，并且你执行了一项存货变动，将15个数量从这个库位移动到了另一个库位，但由于此问题而造成了失败，那么这个屏幕中的可用数量现在将显示为0。

原因
在使用SCS模板导出时，它将创建一个负数行。在重新导入至Sage X3之前，应该删除这个负数行。导入并不需要它。
"E","","D22",110517,"","",""
"L",1000,"22322","EA",1,"A","RCK","RK0102","","","","","","","D22"
"S","EA",1,1,"RK0102","A"
"S","EA",-1,-1,"RK0205","A"                <--- 负数行

解决方法
通过移除负数行，更正导入文件。请注意，这种精确的格式布局仅适用于非定制的SCS导入模板。定制版本可能有不同的要求。

• 无效的导入文件看起来如下：
"E","","D22",110517,"","",""
"L",1000,"22322","EA",1,"A","RCK","RK0102","","","","","","","D22"
"S","EA",1,1,"RK0205","A"
"S","EA",-1,-1,"RK0102","A"       <-- 负数行
或者
"E","","D22",110517,"","",""
"L",1000,"22322","EA",1,"A","RCK","RK0102","","","","","","","D22"
"S","EA",-1,-1,"RK0102","A"       <-- 负数行
"S","EA",1,1,"RK0205","A"

• 对于未定制/封装的导入模板SCS的有效导入文件看起来如下（删除了负数行）：
"E","","D22",110517,"","",""
"L",1000,"22322","EA",1,"A","RCK","RK0102","","","","","","","D22"
"S","EA",1,1,"RK0205","A"

请注意：在导入尝试失败后，存货变更屏幕中的可用值可能会变得不正确。如果存货变更屏幕中的可用值不正确，请让有SQL经验的人联系Sage支持。

欢迎光临赛捷软件论坛 (http://sagesoft.cn/bbs/)