Skip to Content
This question has been flagged
accountinginventoryvaluationodoo17CE
2 Replies
293 Views
Avatar
Muhammad Naufal

Hello Odoo Forum,

I am using Odoo 17 Community Edition

In our company, the separation of received inventory value is critical for accurate balance sheet reporting, based on the item's billing status:

  1. Goods Received, Not Billed (Accrue WH): This represents a Current Liability. The goods are physically in our warehouse, but the legal vendor invoice (Bill) has not yet been processed or validated. This account reflects an immediate, unbilled obligation.
  2. Goods Billed/Paid, Not Received (Item in Transit / GIT): This represents a Current Asset. Our company has either legally acknowledged the invoice or paid for the goods, but the physical items are still in transit. This account reflects the value of the asset we legally own but have not yet taken physical possession of.

Conclusion: We cannot use a single, shared Odoo account for both scenarios, as mixing Assets (GIT) and Liabilities (Accrue WH) in one account violates our financial reporting standards and distorts the Balance Sheet.

Current Successfull Configuration : 

  • I have set the Stock Input Account on my Product Category to a liability account called Accrue WH (Current Liability).
  • Result: This successfully handles Scenario 1 (Goods Received Before Bill), where the journal is: DR Stock Valuation / CR Accrue WH. (This works!)

My Challenge (The Need for Item in Transit):

The problem is that Odoo uses this same Stock Input Account (Accrue WH) for ALL automated purchase receipts. I need to implement Scenario 2 where the Vendor Bill is processed first (as Goods In Transit).

  • Goal for Scenario 2: When the Vendor Bill is validated, the value must go to an Asset Account named Item in Transit (Current Asset), instead of relying on the standard Accrue WH setup.
    • Expected Bill Validation Jurnal: DR Item in Transit / CR Accounts Payable
    • Expected Receipt Jurnal: DR Stock Valuation / CR Item in Transit

My Configuration Challenge Summary:

Odoo defaults to the single Stock Input Account on the Product Category, making separation impossible here.

My Questions : 

If this requires using a second Product Category, how should the second Product Category be configured to only interact with the Bill (and not the Receipt) for the Item in Transit journal?

Thank you for your time and expertise!

Avatar
Discard
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Best Answer

Hi,

Odoo 17 Community does not support separating Goods Received Not Billed (GRNI) and Goods in Transit (GIT) using different accounts for the same product, because Odoo only allows one Stock Input Account per product category. This means the system cannot automatically decide whether to post to a liability account (Accrue WH) or an asset account (Item in Transit) based on whether the bill or the receipt comes first. That behavior is only achievable through customization.

To achieve clean accounting separation without custom code, the only practical configuration-based solution is to use two different product categories. One category uses the Accrue WH liability account for the scenario where goods are received before the bill. The other category uses the Item in Transit asset account for the scenario where the bill is validated before the goods are received. This correctly produces liability postings for GRNI and asset postings for GIT.

However, you cannot configure a category to apply only at the bill step or only at the receipt step—the category’s Stock Input Account is used for both the bill and the receipt. If a product must support both workflows, users need to assign the appropriate category based on the purchase process, or a small custom module must be created to switch categories automatically.


Hope it helps

Avatar
Discard
Avatar
Masoud
Best Answer
Odoo doesn’t support separate input accounts per transaction type (bill vs receipt) out of the box and for a single product category. To achieve your GIT vs Accrue WH split, you’ll need either a 1-custom module or a 2-workaround using separate product categories and manual journal adjustments. Odoo uses the Stock Input Account from the product category for all incoming stock valuation entries—regardless of whether the bill or receipt comes first. It doesn’t distinguish between “Goods Received Not Billed” and “Goods Billed Not Received” in its default flow.

Option 1: Use two product categories
Category A (Accrue WH): For standard flow—goods received before bill.
Category B (GIT): For pre-billed items—used only when the vendor bill is validated before receipt.

Option 2: Custom module
Key limitations : Odoo CE doesn’t support landed costs or advanced valuation flows natively and your developer has a lot of work :)
​
Avatar
Discard
Related Posts Replies Views Activity
Valuation of inventory in a multi-branch enviroment
accounting inventory valuation
Avatar
Avatar
1
Oct 24
2788
What are Stock Interim Accounts and how should they be used? Solved
accounting inventory valuation
Avatar
Avatar
Avatar
2
Dec 24
41346
Costing method was not selected but now selected how to process existing transactions?
accounting inventory valuation
Avatar
0
Oct 17
4059
How to Correct Finished Goods Valuation After Raw Material Cost Mistake (FIFO + Automated Valuation) Solved
accounting manufacturing inventory valuation
Avatar
Avatar
Avatar
2
Aug 25
1157
Negative Stock and Valuation Issue Due to Inventory Adjustment in Odoo 17
accounting inventory valuation v17
Avatar
1
Mar 25
3564