Total Available

Lot Management  •  Article  •  7/22/2026  • 

The Total Available FastTab displays the aggregated inventory available for the selected items, variants, lots, and locations within the analysis period. The values are calculated by combining the starting inventory balance with all inventory-increasing transactions, including purchase receipts, production outputs, transfer receipts, and positive adjustments. The data is compressed by Item No., Variant Code, Lot No., and Location Code, with one row displayed for each unique combination.

FieldDescription
Item No.Specifies the item number included in the total available calculation.
DescriptionSpecifies the description of the item.
Variant CodeSpecifies the variant code associated with the item. If no variant exists, the field remains blank.
Lot No.Specifies the lot number included in the total available calculation.
Lot Attribute Value 1Specifies the first lot attribute value assigned to the lot.
Lot Attribute Value 2Specifies the second lot attribute value assigned to the lot.
Lot Attribute Value 3Specifies the third lot attribute value assigned to the lot.
Location CodeSpecifies the location code for which the total available quantity is calculated.
Total Available Weight QtySpecifies the total available inventory quantity calculated using the formula: Starting Balance + Purchase Receipts + Production Output + Transfer Receipts + Positive Adjustments. Starting Balance includes inventory posted before the analysis Start Date, while the remaining quantities include transactions posted between the Start Date and End Date (inclusive).