Available Inventory Quantities in Sage 500 ERP

1 minute read time.

Sage 500 ERP product has summarized quantities in various screens to assist the user in making business decisions relating to inventory availability.  You probably noticed that often in various Sage 500 forms/windows (usually accessed thru one of IM context menus) quantity on hand and quantity available are different. Quantity on hand is a quantity of a finished good or raw material item that is physically present in the warehouse. However in order to understand these available quantities, it helps to be familiar with the Miscellaneous page in Set Up IM Options:

Include in Quantity Available: All of the quantities mentioned in this section of the page will be included in a Qty Available amount if the corresponding check box is checked.

Exclude from Quantity Available: All of the quantities mentioned in this section of the page will be excluded in a Qty Available amount if the corresponding check box is checked.

Note that the code that calculates Quantity Available also adds timInventory.QtyOnWOAvail (quantity on work orders scheduled for assemblies but not yet received into inventory) if timOptions.InclQtyOnWOAvail is “1” (checked).  The code also subtracts timInventory.QtyReqForWO (quantity on work orders scheduled for assemblies but not yet taken out of inventory) if timOptions.InclQtyReqWOAvail is “1” (checked).  However, those two check boxes in Inventory Management Options cannot be checked because those two controls are invisible.  Allowing the user to control the inclusion or exclusion of the work order quantities thru the front end will be implemented in a future release.

In addition to IM Options a check box in the Sage 500 ERP Set Up Bins application also affects how quantity available is calculated:

Note the field "Exclude From Available.”  If this check box is checked, then the quantity available calculated for an item in a particular warehouse will NOT include the quantity on hand in this bin.  If this check box is not checked, then the summarized quantity available figure will include the quantity on hand in this bin. 

Another factor in determining available inventory quantities for LOT tracked items is lot expiration date. Any lot quantities that have an expiration date prior to current business date will be excluded from the available quantities. If needed a lot expiration date can be adjusted using Lot/Serial Adjustment task available under IM/Activities/Utilities menu.