From the Inventory Allocation Details (IN402000 screen) page, I’m interested in these fields:
I used to get these values from the database using this SQL query:
select [QtySOBackOrdered],[QtySOShipping],[QtySOBooked],[QtySOPrepared]
FROM [dbo].[INSiteStatus] (NOLOCK) ss
where InventoryID=19560 and CompanyID=2
Unfortunately, these values aren’t changing in the database on a daily basis even though they are changing on the Inventory Allocation Details (IN402000 screen) page. In fact, they haven’t changed at all since the upgrade from 22R2 to 24R1. It looks like the InventoryQtyByPlanType code is used to populate this grid in 24R1 but, looking at the refactored code, I’m not seeing how these fields are calculated or which database tables they are derived from.
Does anyone know where these values are stored in the Acumatica SQL database?
