Reconciliation

The Reconciliation FastTab provides the final inventory reconciliation results by comparing the Calculated End Balance against the System End Balance and displaying a Green/Red status based on the configured tolerance. On the Reconciliation FastTab, you can view the inventory reconciliation results for each item, variant, lot, and location combination, including the calculated end balance, system end balance, variance values, and reconciliation status in the following fields.

Field	Description
Item No.	Specifies the item number included in the Mass Balance Analysis.
Description	Specifies the description of the item.
Variant Code	Specifies the variant code associated with the item.
Location Code	Specifies the location code for which the reconciliation is performed.
Lot No.	Specifies the lot number included in the analysis.
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.
Total Available Weight	Specifies the total available weight from the Total Available subpage. For more information, see Total Available.
Remaining Consumption Allocated Weight	Specifies the sum of Remaining Consumption from the Item Tracing subpage for the selected item and lot. For more information, see Item Tracing.
Sales Allocated Weight	Specifies the sum of Sales Allocation from the Item Tracing subpage for the selected item and lot. For more information, see Item Tracing.
Transfer Shipment Allocation Weight	Specifies the total raw material weight tied to Transfer Shipments of output items, accumulated from item tracing Transfer Allocation rows.For more information, see Item Tracing.
Transfer Receipt Allocation Weight	Specifies the total raw material weight tied to Transfer Receipts of output items, accumulated from item tracing Transfer Allocation rows.For more information, see Item Tracing.
Remaining Transfer Receipt Weight	Specifies the total transfer receipt allocation weight still tied to remaining inventory of the output item at the receiving location, accumulated from item tracing Transfer Allocation rows. For more information, see Item Tracing.
Sales Return Allocation Weight	Specifies the total raw material weight tied to sales return receipts of output items, accumulated from item tracing Sales Allocation rows. rows.For more information, see Item Tracing.
Remaining Sales Return Allocation Weight	Specifies the total raw material weight tied to sales return receipts of output items, accumulated from item tracing Sales Allocation rows. rows.For more information, see Item Tracing.
Transfer Shipped Weight	Specifies the Transfer Shipment weight. For transaction details, see Transfer Shipment.
Neg. Adjusted Weight	Specifies the quantity reduced through negative inventory adjustment transactions. For more information, see Negative Adjustment.
Sales Weight	Specifies the direct raw material sales net weight quantity. For more information, see Sales Shipment.
Adjusted Allocation Weight	Specifies the total raw material weight tied to negative adjustments of output items (SFG/FG), accumulated from Adjustment Allocation entries in the Item Tracing subpage. For more information, see Item Tracing.
Calculated End Balance	Specifies the calculated end balance using the formula: Total Available Weight - Remaining Consumption Allocated Weight - Sales Allocated Weight - Adjusted Allocation Weight - Transfer Shipped Weight - Transfer Shipment Allocation Weight + Transfer Receipt Allocation Weight - Remaining Transfer Receipt Weight - Neg. Adjusted Weight - Sales Weight.
Calculated & Allocated End Balance	Specifies the calculated end balance plus all remaining allocated weights: Calculated End Balance + Remaining Consumption Allocated Weight + Remaining Transfer Receipt Weight + Remaining Sales Return Weight.
System End Balance Weight	Specifies the system end balance from the Ending Balance subpage. For more information, see Ending Balance.
Variance Calculated vs System End Balance	Specifies the difference between the Calculated End Balance and the System End Balance Weight.
Variance % Calculated vs System End Balance	Specifies the percentage variance between the Calculated End Balance and the System End Balance Weight.
Status	Specifies whether the line is within the accepted tolerance (Green) or outside the accepted tolerance (Red).