Hi,
I wanted to see if there were separate rules for INSiteStatus vs. INLocationStatus’ QtyAvail fields?
INSiteStatus returns a value for QtyAvail that matches the INventory Allocation summary in that it deducts ON Issue, Allocated and BAckordered - which are defined in our default calculation rules.
For INLocationStatus, it is only deducting the on issue amount but not allocated / backordered.
is this an incorrect behavior that we need to correct or done on purpose?
Thanks
Joseph
Best answer by jinin
Hi
As per my understanding, INLocationStatus includes SO quantity fields primarily for tracking and reporting purposes. Although allocations are managed at the site level, the system still records how those allocations are distributed across locations for visibility. However, QtyAvail at the location level reflects physical availability only, while commitment-based availability is enforced at the site level in Acumatica.
+12Hi
This behavior is intentional. Allocations and backorders are tracked at the site (warehouse) level, not strictly enforced at the individual location level.
A location may physically have available stock even if that quantity is allocated or backordered elsewhere within the same site. Therefore, INLocationStatus.QtyAvail reflects physical availability (deducting only On Issue), while INSiteStatus.QtyAvail reflects commitment-based availability by deducting Allocated and Backordered quantities.
Thanks
Makes a lot of sense. My only question is then why would INLocationStatus show fields for SO quantities if that isn’t taken into account?
+12Hi
As per my understanding, INLocationStatus includes SO quantity fields primarily for tracking and reporting purposes. Although allocations are managed at the site level, the system still records how those allocations are distributed across locations for visibility. However, QtyAvail at the location level reflects physical availability only, while commitment-based availability is enforced at the site level in Acumatica.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
