I am trying to create a report for our purchasing team and they have requested that it show two fields from the Inventory Summary of the inventory item. These fields are Purchase Order and In Transit columns.
It looks like this may be populated on the fly by the program and not actually stored in the DB, does anyone know if that is correct? Is there a table that does store these numbers?
Best answer by dcomerford
View original
+16
HI
It does not appear to be stored in the DB. When I inspected that, it says nonexistent in the DB.
From the way the help reads on that, it is a total :
| In Transit | The quantity of the inventory item that is included in the two-step transfer documents that have been released, and the inventory receipts for this quantity were not created in the destination warehouse or the inventory receipts have been created but not released. This quantity affects the available quantity only if the Include Qty. In-Transit option is selected for the item class on the Item Classes form. |
| Purchase Orders | The quantity of the inventory item included in open purchase orders. To view the purchase orders, open the Purchase Orders (PO301000) form.
|
+12
The Table INLocationStatus has these fields in it QtyPOOrder and QtyInTransit it also has all the other stats for an Item/Site/Location
If you are using Lot/Serial Items then the INLotSerialStatus has all the Stats by Item/Site/Location/LotSerialNbr
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.