|
本帖最后由 YonJiao 于 2024-2-3 18:01 编辑
以下系统场景为当前组织分配了可用量计算规则的情况,没有分配可用量计算规则的情况下可用量和现存量是相等的,可用量计算规则分配如图:
一、切换分组条件的不同场景:
1、当分组条件按某维度(比如:明细查询)展示,现存量=可用量+占用量(不展示占用量情况),如下图:
2、当分组条件为“无”时,如果有占用量的情况,则会展示一条可用量为负数的数据,如下图:
注意:可用量为负数的数据实际就是有单据占用库存,比如销售订单(切记订单要选择仓库)。现存量都相加,可用量都相加后即为场景一的结果。
二、接口支持查询的两种场景
首先入参如下:
- {
- "warehouse": "1742914729255370768",
- "product": "1821711814172868615",
- "bStockStatusDocNotNull": false, // 该条件为false或者null时,查询结果会包含占用量的数据,具体形式为一条可用量为负数,现存量为0的数据。
复制代码
1、当"bStockStatusDocNotNull": true时,返回的是没有计算可用量的数据,现存量=可用量。所以如果当前组织设置了可用量计算规则,则不能将bStockStatusDocNotNull传true,否则返回的可用量没有减去占用量数据。
示例如下:
- {
- "code": "200",
- "message": "操作成功",
- "data": [
- {
- "productsku_name": "火腿",
- "statusType": "01",
- "reserveid": 0,
- "tradeorder": 0,
- "warehouse_code": "000001",
- "stockStatusDoc": 1602070655955110065,
- "sensitiveUID": "~",
- "product_unitName": "根",
- "currentqty": 60,
- "product_code": "0002000001",
- "salesorder": 0,
- "outnoticeqty": 0,
- "poin": 0,
- "innoticeqty": 0,
- "manageClass_name": "零食",
- "transferapplyout": 0,
- "returnorder": 0,
- "retailTrade": 0,
- "purchaseorder": 0,
- "manageClass": 1603403066475806723,
- "planavailableqty": 60,
- "materialreq": 0,
- "aimequipcard": 0,
- "morphologyconversionout": 0,
- "transferapplyin": 0,
- "pofreport": 0,
- "posubarrivalorder": 0,
- "delivery": 0,
- "product": 1603412128856801287,
- "arrivalorder": 0,
- "org": "1603399261136879623",
- "posubin": 0,
- "productsku_code": "0002000001",
- "storenotice": 0,
- "warehouse": 1603425546334633984,
- "product_name": "火腿",
- "pickingreq": 0,
- "poout": 0,
- "unit": 1603411742292443142,
- "productsku": 1603412128856801301,
- "warehouse_name": "焦仓",
- "manageClass_code": "000002",
- "availableqty": 60,
- "preretailqty": 0,
- "tradedelivery": 0
- }
- ]
- }
复制代码
2、当"bStockStatusDocNotNull": false或者为空时,返回所有数据,包含可用量为负数的数据。所以对接系统需要按照现存量都相加,可用量都相加的方法进行汇总即可。
- {
- "code": "200",
- "message": "操作成功",
- "data": [
- {
- "productsku_name": "火腿",
- "statusType": "01",
- "reserveid": 0,
- "tradeorder": 0,
- "warehouse_code": "000001",
- "stockStatusDoc": 1602070655955110065,
- "sensitiveUID": "~",
- "product_unitName": "根",
- "currentqty": 60, //现存量
- "product_code": "0002000001",
- "salesorder": 0,
- "outnoticeqty": 0,
- "poin": 0,
- "innoticeqty": 0,
- "manageClass_name": "零食",
- "transferapplyout": 0,
- "returnorder": 0,
- "retailTrade": 0,
- "purchaseorder": 0,
- "manageClass": 1603403066475806723,
- "planavailableqty": 60,
- "materialreq": 0,
- "aimequipcard": 0,
- "morphologyconversionout": 0,
- "transferapplyin": 0,
- "delivery": 0,
- "pofreport": 0,
- "posubarrivalorder": 0,
- "product": 1603412128856801287,
- "arrivalorder": 0,
- "org": "1603399261136879623",
- "posubin": 0,
- "productsku_code": "0002000001",
- "storenotice": 0,
- "warehouse": 1603425546334633984,
- "product_name": "火腿",
- "pickingreq": 0,
- "poout": 0,
- "unit": 1603411742292443142,
- "productsku": 1603412128856801301,
- "warehouse_name": "焦仓",
- "manageClass_code": "000002",
- "availableqty": 60, //可用量
- "preretailqty": 0,
- "tradedelivery": 0
- },
- {
- "productsku_name": "火腿",
- "reserveid": 0,
- "tradeorder": 0,
- "warehouse_code": "000001",
- "stockStatusDoc": 0,
- "sensitiveUID": "~",
- "product_unitName": "根",
- "currentqty": 0, //现存量
- "product_code": "0002000001",
- "salesorder": 50,
- "outnoticeqty": 0,
- "poin": 0,
- "innoticeqty": 0,
- "manageClass_name": "零食",
- "transferapplyout": 0,
- "returnorder": 0,
- "retailTrade": 0,
- "purchaseorder": 0,
- "manageClass": 1603403066475806723,
- "planavailableqty": 0,
- "materialreq": 0,
- "aimequipcard": 0,
- "morphologyconversionout": 0,
- "transferapplyin": 0,
- "delivery": 0,
- "pofreport": 0,
- "posubarrivalorder": 0,
- "product": 1603412128856801287,
- "arrivalorder": 0,
- "org": "1603399261136879623",
- "posubin": 0,
- "productsku_code": "0002000001",
- "storenotice": 0,
- "warehouse": 1603425546334633984,
- "product_name": "火腿",
- "pickingreq": 0,
- "poout": 0,
- "unit": 1603411742292443142,
- "productsku": 1603412128856801301,
- "warehouse_name": "焦仓",
- "manageClass_code": "000002",
- "availableqty": -50, //可用量
- "preretailqty": 0,
- "tradedelivery": 0
- }
- ]
- }
复制代码
三、事件订阅也是同样的道理,如果分配了可用量计算规则,则多返回一条负数的可用量数据,如果没有分配可用量计算规则,则多返回一条可用量为0的数据。
遵顼现存量都相加,可用量都相加的方法进行汇总。
- {
- "data": [
- {
- "productClass_name": "零食",
- "product_cCode": "0002000001",
- "productsku_skuName": "火腿",
- "sensitiveUID": "~",
- "currentqty": 60.0, //现存量
- "salesorder": 0.0,
- "product_cName": "火腿",
- "purchaseorder": 0.0,
- "retailTrade": 0.0,
- "productClass_code": "000002",
- "aimequipcard": 0.0,
- "pofreport": 0.0,
- "acolytesUnit": 0,
- "productClass": 1603403246847131655,
- "unitName": "根",
- "storenotice": 0.0,
- "warehouse": 1603425546334633984,
- "pickingreq": 0.0,
- "poout": 0.0,
- "unit": 1603411742292443142,
- "productsku": 1603412128856801301,
- "warehouse_name": "焦仓",
- "productsku_cCode": "0002000001",
- "org_code": "yongyoujituan",
- "preretailqty": 0.0,
- "inventoryowner": 0,
- "tradedelivery": 0.0,
- "product_modelDescription": null,
- "reserveid": 0,
- "tradeorder": 0.0,
- "warehouse_code": "000001",
- "stockStatusDoc": 1602070655955110065,
- "poin": 0.0,
- "outnoticeqty": 0.0,
- "innoticeqty": 0,
- "transferapplyout": 0.0,
- "returnorder": 0.0,
- "inorderqty": 0,
- "org_name": "用友集团",
- "materialreq": 0.0,
- "morphologyconversionout": 0.0,
- "transferapplyin": 0.0,
- "posubarrivalorder": 0.0,
- "delivery": 0.0,
- "product": 1603412128856801287,
- "arrivalorder": 0.0,
- "org": "1603399261136879623",
- "posubin": 0.0,
- "availableqty": 60.0 //可用量
- },
- {
- "productClass_name": "零食",
- "product_cCode": "0002000001",
- "productsku_skuName": "火腿",
- "sensitiveUID": "~",
- "currentqty": 0.0, //现存量
- "salesorder": 53.0,
- "product_cName": "火腿",
- "purchaseorder": 0.0,
- "retailTrade": 0.0,
- "productClass_code": "000002",
- "aimequipcard": 0.0,
- "pofreport": 0.0,
- "acolytesUnit": 0,
- "productClass": 1603403246847131655,
- "unitName": "根",
- "storenotice": 0.0,
- "warehouse": 1603425546334633984,
- "pickingreq": 0.0,
- "poout": 0.0,
- "unit": 1603411742292443142,
- "productsku": 1603412128856801301,
- "warehouse_name": "焦仓",
- "productsku_cCode": "0002000001",
- "org_code": "yongyoujituan",
- "preretailqty": 53.0,
- "inventoryowner": -1,
- "tradedelivery": 0.0,
- "product_modelDescription": null,
- "reserveid": 0,
- "tradeorder": 0.0,
- "warehouse_code": "000001",
- "stockStatusDoc": 0,
- "poin": 0.0,
- "outnoticeqty": 0.0,
- "innoticeqty": 0,
- "transferapplyout": 0.0,
- "returnorder": 0.0,
- "inorderqty": 0,
- "org_name": "用友集团",
- "materialreq": 0.0,
- "morphologyconversionout": 0.0,
- "transferapplyin": 0.0,
- "posubarrivalorder": 0.0,
- "delivery": 0.0,
- "product": 1603412128856801287,
- "arrivalorder": 0.0,
- "org": "1603399261136879623",
- "posubin": 0.0,
- "availableqty": -53.0 //可用量
- }
- ]
- }
复制代码
|
本帖子中包含更多资源,您需要 登录 才可以下载或查看,没有帐号?立即注册
X
|