To determine the number of items in transit for a specific inventory item at a particular location, we can utilize the InventoryItemLocations table within SuiteQL. This table contains essential metrics such as quantityAvailable, quantityBackOrdered, quantityCommitted, quantityOnHand, and quantityOnOrder for all inventory locations.
By querying this table, we can effectively calculate the quantity of items in transit by leveraging the relevant fields.
Below is a sample SuiteQL query to achieve this:
SELECT loc.quantityintransit FROM item i JOIN inventoryItemLocations loc ON i.id = loc.item WHERE loc.location = ${location} AND i.id = ${item}