Adding allocation to stock items GI

Hello Acumatica

does anyone have an answer to the above question? because I have the same issue. we need to see which stock items are on sales orders and allocated

We setup a new GI to track this using the tables PX.Objects.IN.InventoryItem and PX.Objects.IN.INSiteStatus

Relation

(Parent Table) Inventory Item | Left Join | (Child Table) InSiteStatus

InventoryID equals InventoryID

Starting 23R2, the INSiteStatus DAC was replaced by the INSiteStatusByCostCenter DAC, so if the instance is on 23R2 or higher, this new table may need to be used.

hello ​@MinushaWeerasuriya76 I can only see two allocated fields but neither of these are the straight allocated qty. any further clues?

 

I believe you are looking for the “SO Shipping” value. Ordered quantities increase SO Backordered (or SO Booked depending on order type) until they are allocated, then SO Shipping when allocated, and then SO Shipped once on a confirmed shipment.

There does not appear to be a value to track picked inventory values before this shipment is confirmed. Inventory increases SO Shipping with and without a created shipment.

Very helpful ​@plambert  this explains it very clearly. thank you