Skip to Content
This question has been flagged
accountingodoo16features
1 Reply
2580 Views
Avatar
shabaan

While attempting the new implementation of the Price Difference Account in V16 , I followed a specific sequence of operations in testing my use case as follows : 

1- I purchased a product for 150 EGP & Received the full quantity 

2- Then i Sold the full quantity at cost equal 150 EGP

3- I created customer invoice for this SO

4- Finally my vendor send me the PO Bill at unit price equal 170 (due to market changes in item price)


What Odoo Did: 

1- it increased the stock valuation account & stock interim by 20 EGP 

2- Stock Valuation Layer increased by 20 EGP 

3- NO Impact Done on COGs Account ( it should be adjusted/increased by 20 as the actual product cost has been increased ) ,, as implemented in Landed Cost model




Avatar
Discard
Avatar
Gulraiz Raza
Best Answer

Dear Shabaan Asalam o Alaikum, though I am new to Odoo, but I think for landing cost function to do its thing the item in question first of all need to be set as a service and not a product ( I might be wrong) and when you create a new service item you will find the landing cost toggle on or off in the purchase tab of the newly created or existing service form - so yeah what I am saying is that from what it seems to me the product price variation shouldn't trigger the landing cost calculation - however other account settings need to be set up  correctly to reflect the jump in the vendor quoted price. I myself am currently trying to set up a database for a local import company and looking into it further. Who knows where I end up and what I find :) 


Avatar
Discard
Gulraiz Raza

I found this from another user on the forum, this will solve your problem, check the answer from Alouna Ahmad (images are missing) see if you can follow the link for this post.

https://www.odoo.com/forum/help-1/difference-price-of-rfq-vs-vendor-bill-222803
-
20 April 2023
Hello,

1. Go to the product category of your purchased product

2. this account may be of type "current assets" Name it "price difference account", Note that this account will automatically be populated when there is a difference between when PO and BILL price

3. the BILL journal items will be like:

4. then go to Inventory App -> operations -> Landed costs -> create

note: make sure to activate the landed cost feature in the Inventory app Settings, The 4th step is essential since we have to adjust the Cost of the received products
choose the transfer add the landed cost

the inventory valuation will be updated for that product like:

ope this will help you

Related Posts Replies Views Activity
Accounting Reports amount in currency odoo 16
accounting odoo16features
Avatar
0
Feb 24
1143
AttributeError: 'dict' object has no attribute 'id' Solved
accounting odoo16features
Avatar
Avatar
1
Feb 24
3325
How can I raise a warning/message via a wizard in create function and continue with the transaction
accounting odoo16features
Avatar
0
Feb 24
1408
maximum recursion depth exceeded while calling a Python object while using action_post from account.move
accounting odoo16features
Avatar
0
Jul 23
1247
How to manage opening balance in odoo ?
accounting odoo16features
Avatar
Avatar
1
Apr 23
128