1. On-Hand Quantity After Inventory Adjustment (as of the adjustment date)

How it works:

When you perform an inventory adjustment on 01/01/2025, Odoo updates the stock quant records, making this the new physical quantity from that moment onward. The system does not automatically keep a snapshot unless explicitly customized.

 How to view it:

• Go to Inventory > Reporting > Inventory Valuation.
• Filter by date = 01/01/2025 (top-right date filter).
• You will see the on-hand quantity post-adjustment, because this report calculates values as of that date.

🛠 Notes:

• This only works if the valuation method is FIFO or AVCO, and your warehouse is configured for inventory valuation.
• If you're using real-time valuation, the stock.valuation.layer table gives you insight.

2. On-Hand Quantity per Location for a Specific Date (e.g., Product A in Location B on 01/04/2025)

Odoo's limitation:

Out-of-the-box, Odoo does not store stock levels by date per location unless you:

• Use Inventory Valuation reports (valued products only).
• Use a custom report or custom query.

 Recommended Workarounds

A. Inventory Valuation Report (Enterprise):

• Navigate to Inventory > Reporting > Inventory Valuation.
• Set date to 01/04/2025.
• Use the filters:
  • Product = Product A
  • Location = Location B

 This only works if the product is valued and tracked.

This seems to be an AI / LLM answer that hasn't been checked.