Understanding and Using the Inventory Roll Forward Report

What is an Inventory Roll Forward Report?

An Inventory Roll Forward Report is a detailed tracking tool that shows how your inventory changes over a specific time period. Think of it like a checkbook register for your inventory – it starts with what you had at the beginning and tracks every addition and subtraction until you reach your ending balance.

Why Should You Use This Report?

1. Accuracy Verification: Helps ensure your recorded inventory matches what you actually have
2. Problem Detection: Quickly identifies discrepancies or unusual patterns in inventory movement
3. Audit Support: Provides a clear trail of inventory changes for auditors and management
4. Decision Making: Helps in making informed purchasing and stocking decisions

Definitions:

1. Sellable Start Quantity
   1. Inventory in Available and Allocated status at the start of the period searched.
2. Non Sellable Start Quantity
   1. Inventory in the following statuses at the start of the period. This is inventory that is in a hold status that is not sellable inventory.
      1. Damaged 
      2. QC
      3. Refurbishing
      4. Under Investigation
      5. Version Control
   2. Lost is not included because it is an end-of-life adjustment that would reduce the Sellable or Non-Sellable quantity, depending on the original inventory status before the Lost adjustment. For example, it’s no longer physically in the building at this point and would have been adjusted into Lost (+1 Lost) from another status that’s either in the Sellable Start Quantity (e.g. -1 Allocated) or Non-Sellable Start Quantity (-1 Damaged). 
3. Sellable Adjustment Quantity
   1. Inventory that moves in or out of the Available + Allocated status during the period searched.
4. Shipment Quantity
   1. Inventory that is shipped during the period searched.
5. Receipt Quantity
   1. Inventory that is received on an ASN during the period searched.
6. Return Quantity
   1. Inventory that is received on an RMA during the period searched. 
7. Sellable End
   1. Inventory in Available and Allocated at the end of the period searched.
8. End Quantity Calculation
   1. This should be the same as the Sellable End based on all of the logic that is listed above. 
   2. =([Sellable Start Quantity] + [Sellable Adjustment Quantity] - [Shipment Quantity] + [Receipt Quantity] + [Return Quantity])