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.
| Field | Description |
|---|---|
| Item No. | Specifies the item number included in the total available calculation. |
| Description | Specifies the description of the item. |
| Variant Code | Specifies 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 1 | Specifies the first lot attribute value assigned to the lot. |
| Lot Attribute Value 2 | Specifies the second lot attribute value assigned to the lot. |
| Lot Attribute Value 3 | Specifies the third lot attribute value assigned to the lot. |
| Location Code | Specifies the location code for which the total available quantity is calculated. |
| Total Available Weight Qty | Specifies 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). |