Skip to Content
This question has been flagged
3 Replies
6945 Views
Avatar
Cai

Hi, experts

I am using Odoo10 and have a question about cost calculation of the price difference between the purchase price and the price of vendor bills. Could I have your help?

0. I am not using  anglo_saxon module

1.Product Category setting

 


1.Purchase order: 1 unit at price 100


2.Incoming shipment: 1 unit

 Journal Entry after validation
 
The cost of productA is 100.

2.Vendor bills. Modify the price to 150


 Journal Entry after validation


The cost of productA is still 100, not 150.

My understanding is that the price difference should be adjusted to product cost automatically and the cost should be 150.
How to do this with Odoo or anything I am missing?

Thanks.

Avatar
Discard
Avatar
Cai
Author Best Answer

Hi, Mohammed and Avinash.

Thanks for quick advice.

I want to have the reuslts like following

1.Update the Product cost from 100¥ to 150¥

    put a function on the Onchange of the Unit price of the Vendor bills to update the price in the product.product model.

2. Instead of using the Journal entry created by Odoo, I need to create my Journal entry to adjust the price difference 50¥ to Asset account for Bill vendor verification with the imaage as below.　

    Is this difficult to do?

Credit:

       111100 Account Payable                                    ASUSTeK  /                                       0.00   ¥        150.00 ¥ 

Debit:
       220001 Goods Received / Invoice Received   ASUSTeK  PO00024: ProductA     100.00 ¥        0.00 ¥  

      101000 Current Assets                                       ASUSTeK  ProductA-RP                   50.00  ¥        0.00 ¥


Avatar
Discard
Avinash Nk

It is very simple.

1)Create a product with income and expense account as "101000 Current Assets". and Price as 50.00

2)Then add that product also with the Purchase order line.(Automatically by customization).

Then you will get the result as you wanted.

This is one of the solutions. There are so many ways to archive this.

Thank you.

Cai
Author

Thank you so much, Avinash

Avatar
Avinash Nk
Best Answer

Hi Cai,
This is odoo basic work flow.  (Mohammed mention that)
If you want that feature necessary, then you can do it with a simple customization. 
Just put a function on the Onchange of the Unit price of the Vendor bills to update the price in the product.product model.


Thank you.

Avatar
Discard
Avatar
Mohammed Amal N
Best Answer

Hello,

If you want to update price of a product you can do it from the product form.

In sale or purchase or invoice lines if you modify price it means the product price for that specific entry is changed not product's price.

I think that is better approach than changing product price every time you change it in invoices (as you might as for different price according to suppliers)

Avatar
Discard