Viewing Historical Inventory Quantities

GoldFinch provides two reports to determine inventory quantities as of a historical date. Each report is based on a different transaction source and serves a different purpose.

Option 1 – GF1004 Inventory by UOM As Of Date

Use the GF1004 – Inventory by UOM As Of Date report when you need historical inventory quantities by unit of measure.

This report is based on Warehouse Entries, making it the preferred report for reviewing historical inventory quantities.

After setting the desired As of Date, the report displays:

• Quantity on Hand (in the item's transaction Unit of Measure)
• Base Qty. on Hand (in the item's Base Unit of Measure)

Use this report when you need to know how many units were physically on hand at a specific point in time.

Option 2 – GF1003 Inventory to GL Reconciliation As Of Date

The GF1003 – Inventory to GL Reconciliation As Of Date report can also be used to review historical inventory quantities.

This report is based on Cost Entries rather than Warehouse Entries and is primarily intended for inventory valuation and General Ledger reconciliation.

In addition to inventory values, the report includes:

• Base Qty. on Hand

Use this report when you need both the historical inventory quantity and the corresponding inventory valuation as of a specific date.

Which Report Should You Use?

In general, use GF1004 when your primary goal is to determine historical inventory quantities, and use GF1003 when you also need to reconcile inventory values with the General Ledger.