Availability is displayed in a variety of locations such as the “Check Price and Availability” and the “Item Main Page”.
This availability is calculated with the below query:
sum(LIPQOH - LIHCOM - LIPCOM) as DefQty, LIITM as ShortItemNumber
ltrim(rtrim(LIMCU)) = [Current Branch Plant] AND LIITM = [ShortItemNumber]
GROUP BY LIITM
One of the main components of this query is how it calculates the default quantity. This is determined by a configuration variable (SalesOrder_Default_AvailabilityFormula) which can be changed for the application through the admin panel. If this value is left blank, the default is set to “sum(LIPQOH - LIHCOM - LIPCOM)”