How to remove supply of a specific item from a ship node?

Answer

Problem:

There are stale entries in the inventory supply table and these needs to be cleared. Though the supply shows a certain item is present in the node, it’s not physically present in the node.

Solution:

You can use the loadInventoryMismatch and syncLoadedInventory APIs for deleting the necessary records from the supply table.

Procedure:

Clear out records from the YFS_INVENTORY_SUPLY_TEMP table for the ship node and try the API calls with the following sample inputs. Do not miss out any attributes.

loadInventoryMismatch:

<Items ApplyDifferences="" CompleteInventoryFlag="" ShipNode="<REQUIRED>" YantraMessageGroupID="<pass an ID>">
<Item InventoryOrganizationCode="<REQUIRED>" ItemID="<REQUIRED>" ProductClass="<if any>" UnitOfMeasure="<if any>">
<Supplies>
<Supply AvailabilityType="TRACK" Quantity="0" SupplyType="<REQUIRED>">
</Supply>
</Supplies>
</Item>
</Items>

syncLoadedInventory:

<Inventory ApplyDifferences="Y" CompleteInventoryFlag="N" ReasonCode="SHIP" ReasonText="" ShipNode="<REQUIRED>" YantraMessageGroupID="<Same as that passed for loadInventoryMismatch>" InsertInventoryItem="N" SynchNonOnHandInventory="<Y if supply type is NOT onhand>"/>

This should address the inventory mismatch mentioned above.