Top
Top
LibraryEASYCommerce Reference ManualItem SetupItem Availability
Availability

Availability

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:

SELECT

sum(LIPQOH - LIHCOM - LIPCOM) as DefQty, LIITM as ShortItemNumber

FROM F41021

WHERE

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)”


Powered by EASYProcess (© 2019 K-Rise Systems, Inc).