Skip to Content
Menu
This question has been flagged

The valuation of the product is done according to the exchange rate of the date that the product enters the stock, regardless of whether the invoice has already been paid or not and the exchange rate value of this.
Is it possible to configure Odoo so that the valuation is according to the invoiced value? (Exchange rate from accountig date)
Thanks

Avatar
Discard
Best Answer

The easiest solution to this:

  • Enter an Accounting Date for the Vendor Bill that matches the Receipt date.

The hardest solution to this:

  • Configure a Price Difference Account for the Product Category.
  • When the Vendor Bill is recorded, the difference due to exchange rates between Receipt date and Bill date is calculated and posted.
  • Record a Landed Cost adjustment equal to the balance posted (every entry shows the PO, the Vendor, the product, the quantity, the price difference in PO currency and the price difference in company currency).
  • The product(s) on the receipt you choose will be re-valued to include the difference.
  • If you sell products in the mean time, we post to cost of goods for products already delivered. 


Avatar
Discard
Author

thanks Ray, I like the first solution, it could be in disagreement with the current delivery delays, but a nice "keep it simple" approach, the second one could also be well seen but harder and limited, since landed costs require automated stock valuation.

If you don't have automated stock valuation do you even have this issue? You can't have a difference between an entry that is not posted and another one that is can you?

Related Posts Replies Views Activity
3
Mar 23
1729
1
Dec 22
5735
1
Nov 24
19201
1
Aug 24
1809
1
Mar 23
988