Solved

Inventory Summary Fields - Use in reporting

  • 1 November 2023
  • 2 replies
  • 82 views

Userlevel 2

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?

icon

Best answer by dcomerford 2 November 2023, 13:20

View original

2 replies

Userlevel 7
Badge +16

HI @swittrock 

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.
This value affects the available quantity only if the Include Qty. on Purchase Orders option is selected for the item class on the Item Classes form.

 

Userlevel 7
Badge +13

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

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved