How to View Inventory as of a Past Date in Odoo 20

Checking your current stock levels is straightforward in Odoo. But what if your finance team needs to know how much inventory was available at the end of last month? Or an auditor asks for the stock position on a particular date?

Looking at today's inventory figures will not answer those questions. Stock movements, receipts, deliveries, and internal transfers continuously change the quantities recorded in your system.

Odoo 20 introduces an improved way to review historical inventory directly from the Stock report. With its new date selection, you can view inventory as of a previous date while retaining your existing filters and seeing a precise timestamp for the selected period.

This makes it easier for finance, warehouse, and inventory teams to review previous stock positions without relying on separate exports or manually reconstructing inventory information.

In this guide, we'll explain how the feature works, walk through the steps to view historical inventory, and demonstrate how it can be used for a month-end stock review.

Why Historical Inventory Reporting Matters

Inventory information changes whenever products are received, delivered, transferred, or adjusted. As a result, the stock available today may be very different from what your warehouse held a week or a month ago.

For businesses that regularly review inventory performance, having access to historical stock information is particularly useful.

Here are some situations where viewing inventory as of a past date can help.

1. Month-End and Year-End Closing

Finance teams need inventory information corresponding to a specific accounting period. For example, when preparing September's financial reports, they may need to review the stock position as of September 30 rather than the quantities available today.

A historical inventory view helps teams retrieve the relevant stock information for the selected date.

2. Inventory Audits

During an audit, businesses may be asked to provide inventory information for a particular reporting date.

Being able to select that date directly in the Stock report makes it easier to review the relevant information and prepare supporting records.

3. Investigating Stock Discrepancies

Suppose a physical stock count does not match the quantity recorded in Odoo.

Reviewing inventory information from earlier dates can help narrow down when the difference may have appeared. Teams can then investigate the corresponding stock movements and adjustments.

4. Inventory and Accounting Reviews

Inventory and Accounting teams may need to examine stock information for the same reporting date when investigating differences between operational and financial records.

Using a consistent reporting date makes these comparisons more meaningful. However, the stock report should not automatically be treated as a substitute for a complete accounting reconciliation.

5. Reviewing Inventory Trends

Comparing inventory positions across different dates can help businesses understand how stock levels have changed over time.

For example, warehouse managers can review historical quantities to identify changes in product availability and support inventory planning discussions.

What's New in Odoo 20 Inventory Reporting?

Odoo 20 introduces a date picker in the Stock report that allows users to review inventory as of a past date.

According to the official Odoo 20 release notes, this improvement includes three important capabilities:

1. Select a Specific Date

Previously, reviewing historical stock information often involved additional work, such as exporting information, reconstructing quantities from stock movements, or relying on separate tools.

With the new date selection, users can choose the date they want to examine directly from the Stock report.

2. Existing Filters Are Preserved

The report retains the filters and groupings applied when the selected date changes.

For example, if you have filtered inventory by a product category or warehouse, you can change the reporting date without having to configure the same filters again.

This is particularly useful when comparing inventory positions across multiple reporting periods.

3. View a Precise Timestamp

The report provides a timestamp indicating the inventory position being displayed.

This helps users distinguish between current inventory information and historical information, reducing the risk of referencing figures from the wrong reporting period.

For financial reviews and audits, checking the displayed timestamp is an important part of validating the information before sharing it.

How to View Inventory as of a Past Date in Odoo 20

You can access historical inventory information through the Stock report in the Odoo Inventory application.

Follow these steps to review stock information for a specific date.

Step 1: Open the Stock Report

Log in to your Odoo database and open the Inventory application.

Navigate to:

Inventory → Reporting → Stock

The Stock report provides an overview of inventory information for products, including relevant stock quantities and other report values.

The exact information displayed may depend on your database configuration and product setup.

Step 2: Apply Your Inventory Filters

Before selecting a historical date, configure the report according to the information you want to review.

For example, you can narrow down the report using the relevant product category or warehouse-related criteria. You can also group the information by product where appropriate.

Setting up the required filters first makes it easier to compare different reporting dates because Odoo 20 preserves the existing filters when you change the date.

Step 3: Select the Past Date

Locate the Inventory at Date section in the Stock report.

Use the date selection available in this section to choose the historical date you want to review.

For example, you might select:

- September 30 for a month-end stock review.

- A specific date requested during an audit.

- The date before a suspected inventory discrepancy.

After selecting the date, review the report to ensure that it reflects the intended historical inventory position.

Step 4: Verify the Report Timestamp

Before using the displayed figures, check the timestamp associated with the selected inventory date.

This step is particularly important when preparing month-end or year-end reports.

For example, if you need inventory information for September 30, make sure the displayed timestamp corresponds to the intended reporting cutoff.

Do not assume that selecting a calendar date automatically means the report represents the exact accounting cutoff required by your business. Confirm the date and time displayed in your Odoo database.

Step 5: Review, Compare, and Export the Information

Once you have confirmed the reporting date, review the inventory information displayed in the report.

You can examine the quantities for individual products and compare the results using the filters or groupings you previously applied.

If you want to compare historical inventory with the current stock position:

1. Review the report for the selected historical date.

2. Note the relevant product quantities.

3. Switch back to the current inventory view.

4. Compare the figures using the same filters and groupings.

If you need to share the information with your finance or audit team, use the report's available export functionality and clearly identify the reporting date in the exported file or accompanying documentation.

This helps recipients understand which inventory period the figures represent.

Example: Reviewing Month-End Inventory in Odoo 20

Consider a business that manages multiple product categories across its warehouse.

At the beginning of October, the finance team requested the inventory position of finished goods as of September 30.

Instead of relying on today's stock figures, the warehouse manager can use Odoo 20's historical date selection to review the relevant information.

The process would look like this:

1. Open the Inventory application and navigate to Inventory → Reporting → Stock.

2. Apply the required finished goods category and warehouse filters.

3. Select September 30 in the Inventory at Date section.

4. Verify the displayed timestamp against the required reporting cutoff.

5. Review the inventory quantities and export the information if required.

6. Return to the current inventory view and compare the figures using the same filters.

This provides a consistent way to review the historical stock position and compare it with the current inventory.

It is important to remember that the resulting stock information and any financial valuation used for closing should be checked against the business's accounting requirements.

Frequently Asked Questions

1. Can you view inventory as of a previous date in Odoo 20?

Yes. Odoo 20 introduces a date picker in the Stock report that allows users to view inventory information for a selected past date.

2. How do you check historical stock in Odoo 20?

Open the Inventory application and navigate to Inventory → Reporting → Stock. Apply the required filters, select a date using the Inventory at Date section, and review the resulting inventory information.

3. Does Odoo 20 retain filters when changing the inventory date?

Yes. According to the official Odoo 20 release notes, the improved historical inventory view preserves existing filters when the reporting date changes.

4. Can you review inventory for a specific warehouse?

You can configure the relevant warehouse or location filters available in your Stock report before selecting the historical date. The report retains its existing filters when the date changes.

The exact filtering options should be checked against your database configuration.

5. Why is the timestamp important in historical inventory reporting?

The timestamp identifies the moment represented by the report. Checking it helps ensure that the information corresponds to the intended reporting period, particularly when preparing month-end reports or responding to audit requests.

6. Can you export historical inventory information from Odoo 20?

The original workflow describes exporting the report after selecting a historical date. The available export options and the exact exported information should be verified in your Odoo database.

7. Is historical stock quantity the same as historical inventory valuation?

No. Stock quantity and inventory valuation are different measures. Quantity represents how many units are available, while valuation represents their monetary value.

Although Odoo's Stock report includes inventory value information for supported tracked products, financial reporting should be checked against the applicable valuation method and accounting records.

Conclusion

Knowing how much inventory you have today is useful, but businesses also need to understand what their stock position looked like on previous dates.

Odoo 20 makes this easier with its improved historical inventory reporting. The new date selection allows users to review inventory as of a past date, retain existing filters, and identify the timestamp associated with the report.

For finance teams preparing period-end reports, warehouse managers investigating discrepancies, and businesses responding to audit requests, this provides a more direct way to access historical stock information.

Rather than relying entirely on manually reconstructed reports, teams can use the Stock report to review the inventory position they need and compare it with current information.