Inbound Shipment Feature allows you to track shipments when they leave the supplier, to the receiving destination, and then into the buyer’s inventory.
If you would like to expose the Purchase Order quantity associated in the Inbound Shipments and the remaining quantities to be received, you can do so by using Quantity on Shipments field:
- Navigate to Lists > Search > Saved Searches > New
- Select Transaction
- In the Transaction search > Criteria tab, select the following:
**Feel free to add/modify other criteria as needed - In the Results tab,
- Include the Quantity on Shipments field to expose the quantities included in the Inbound Shipment Record.
- For the Quantity Received, select Quantity Fulfilled/Received field
- Enter the following Formula (Numeric): {quantityonshipments} - {quantityshiprecv}
- This would show you the quantities that is not yet received. (This would be accurate if PO quantity = Inbound shipment quantities)
- Creation of formula is needed since the Quantity on Shipments field is not dynamic, meaning this will only show the quantities associated in Inbound Shipments and will not reflect the pending/remaining quantities to be received, which is logged under Enhancement 557317
*** Feel free to modify as needed
If we run this, the following will be shown:
Whereas PO 181 has 10 units associated to an Inbound Shipment, and 4 units received:
Are there other approaches you are implementing in your end to track the pending inbound shipment receipts from Purchase Orders? Let us know in the comments
@Herdi Rana-Oracle