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

标题: [KB224924950075594功能解说] 导入存货变动时出现报错：“错误的存货交易明细！” [打印本页]

作者: anne.yao 时间: 2024-8-21 17:11 标题: [KB224924950075594功能解说] 导入存货变动时出现报错：“错误的存货交易明细！”

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

导入存货变动时出现报错：“错误的存货交易明细！”

创建日期：2021-07-05
最后修改日期：2021-07-05

原因

使用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/)