电脑桌面
添加蚂蚁七词文库到电脑桌面
安装后可以在桌面快捷访问

webapi 生产领料单 即时库存表唯一索引冲突

来源:金蝶云社区作者:金蝶2024-09-162

webapi 生产领料单 即时库存表唯一索引冲突


场景:生产领料单提交下推WMS,WMS回传信息更新并审核

问题发生的前提条件:物料的主单位和辅单位均已设置,且单位不同


问题:生产领料单提交直接审核,不报错,由WMS使用webapi回传更新后审核报错

感觉是一个比较玄学的问题,webapi让你永远不知道错在哪


分析:可直接提交审核,说明库存本身不存在唯一索引冲突,可定位到本次的WMS回传报文异常,由错误提示可推测出问题大概出在三个方面:

1、某个单位字段未设置值

2、某个单位字段未设置但设置了数量(此时不确定有数量无单位是否有问题),

3、某个单位设置了,却没有设置数量

从以下几个方面,检查回传报文:

  1. 检查单位是否存在和物料不一致的情况 (无)

  2. 检查数量是否存在差异性(无)

  3. 尝试去掉非必填项单位

  4. 尝试去掉某个回传数量,发现问题



尝试多次,去掉fBaseStockActualQty ,api保存更新通过,问题解决。

玄学问题报文(解决后的报文,搜索fBaseStockActualQty,并删除对应行):

{
    "formid": "PRD_PickMtrl",
    "data": {
        "isAutoAdjustField": "true",
        "needUpDateFields": [
            "fEntity",
            "fActualQty",
            "fAppQty",
            "fBaseActualQty",
            "fBaseStockActualQty",
            "fBaseUnitId",
            "fEntity_Link",
            "fEntity_Link_FRuleId",
            "fEntity_Link_FSBillId",
            "fEntity_Link_FSId",
            "fEntity_Link_FSTableName",
            "fEntrySrcEnteryId",
            "fEntrySrcEntrySeq",
            "fEntrySrcInterId",
            "fEntryWorkShopId",
            "fExpiryDate",
            "fGroupRow",
            "fKEEPERID",
            "fKEEPERTYPEID",
            "fLOT",
            "fMaterialID",
            "fMoBillNo",
            "fMoEntryId",
            "fMoEntrySeq",
            "fMoId",
            "fOperId",
            "fOwnerId",
            "fParentMaterialId",
            "fParentOwnerId",
            "fParentOwnerTypeId",
            "fPPBomBillNo",
            "fPPBomEntryId",
            "fProduceDate",
            "fReqBillId",
            "fReqBillNo",
            "fReqEntryId",
            "fReqEntrySeq",
            "fReqSrc",
            "fSrcBillType",
            "fReserveType",
            "fSrcBillNo",
            "fStockActualQty",
            "fStockId",
            "fStockLocId",
            "fStockStatusId",
            "fStockUnitId",
            "fUnitID",
            "f_KING_WMSCJR",
            "f_KING_WMSRHR",
            "fMoId"
        ],
        "model": {
            "fID": "980161",
            "f_KING_AUTO": "0",
            "f_KING_WMSCJR": "kingdee",
            "fEntity": [
                {
                    "fReqSrc": " ",
                    "fParentMaterialId": {
                        "fNumber": "01.04.0004.01432"
                    },
                    "fReqEntrySeq": "0",
                    "fExpiryDate": "2023-07-31 00:00:00",
                    "fReqBillId": "0",
                    "fProduceDate": "2023-02-01 00:00:00",
                    "fKEEPERTYPEID": "BD_KeeperOrg",
                    "fStockActualQty": 194,
                    "fReqEntryId": "0",
                    "fStockId": {
                        "fNumber": "022B006"
                    },
                    "fBaseActualQty": 194,
                    "fBaseStockActualQty": 194,
                    "fParentOwnerTypeId": "BD_OwnerOrg",
                    "fStockUnitId": {
                        "fNumber": "sheet"
                    },
                    "fPPBomEntryId": "4032484",
                    "fPPBomBillNo": "PPBOM02200131731",
                    "fMoBillNo": "MO022027143-001",
                    "fStockLocId": {
                        "FStockLocId__FF100002": {
                            "fNumber": "0220301"
   

webapi 生产领料单 即时库存表唯一索引冲突

场景:生产领料单提交下推WMS,WMS回传信息更新并审核问题发生的前提条件:物料的主单位和辅单位均已设置,且单位不同问题:生产领料单提交...
点击下载文档文档为doc格式

声明:除非特别标注,否则均为本站原创文章,转载时请以链接形式注明文章出处。如若本站内容侵犯了原著者的合法权益,可联系本站删除。

已经是第一篇
确认删除?
回到顶部
客服QQ
  • 客服QQ点击这里给我发消息
QQ群
  • 答案:my7c点击这里加入QQ群
支持邮箱
微信
  • 微信