Price Difference Account & Its impact on COGS

accounting odoo16features

1 Beantwoorden

5117 Weergaven

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

Bin Masood Consultancy, Gulraiz Raza

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 :)

Bin Masood Consultancy, 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

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!

Maak vandaag nog een account aan om te profiteren van exclusieve functies en deel uit te maken van onze geweldige community!

Aanmelden

Gerelateerde posts	Antwoorden	Weergaven
Accounting Reports amount in currency odoo 16 accounting odoo16features	0 feb. 24	3708
AttributeError: 'dict' object has no attribute 'id' Opgelost accounting odoo16features	1 feb. 24	7071
How can I raise a warning/message via a wizard in create function and continue with the transaction accounting odoo16features	0 feb. 24	4485
maximum recursion depth exceeded while calling a Python object while using action_post from account.move accounting odoo16features	0 jul. 23	4691
How to manage opening balance in odoo ? accounting odoo16features	1 apr. 23	128

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!