Skip to Content
Menu
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
To pytanie dostało ostrzeżenie
1 Odpowiedz
243 Widoki

Hello,

I need to import opening inventory for products that were actually purchased earlier on different dates. My company is using the FIFO (First In – First Out) valuation method.

The challenge is that I want to upload the opening stock with its original purchase dates so that when I later sell these products, Odoo will correctly pick the oldest layers based on their real historical dates (not just today’s date).

Is there a recommended way to:

  1. Import these quantities into the warehouse with their historical purchase dates?
  2. Ensure that when I sell them, Odoo applies FIFO based on those original dates, not the import date?

I’ve tried basic inventory adjustments, but they always use the adjustment date as the layer date.

What is the best practice for this scenario? Should I create backdated purchase receipts, or is there a built-in method to load opening stock with historical layers?

Thanks in advance!

Awatar
Odrzuć
Najlepsza odpowiedź

Hi,

The best practice for importing opening inventory in Odoo when using FIFO is to create backdated purchase receipts for each historical purchase. This involves creating purchase orders for the actual historical purchases and receiving the products with the receipt date set to the original purchase date. This ensures that Odoo generates stock moves and valuation layers with the correct historical dates, so FIFO will consume the oldest layers first when selling products. Using standard inventory adjustments is not suitable because they always create valuation layers with the adjustment date, which breaks historical FIFO. While direct manipulation of stock valuation layers is technically possible, it is risky and should only be done in pre-live setups by experienced users. For large volumes of historical stock, writing a migration script to automate backdated purchase receipts can save time and maintain accurate stock valuation and accounting integrity.


Hope it helps.



Awatar
Odrzuć
Powiązane posty Odpowiedzi Widoki Czynność
1
mar 25
1911
0
lut 25
1502
2
paź 23
4289
3
sie 22
2270
1
lip 25
834