Skip to Content
Menu
This question has been flagged
1 Reply
1746 Views

When creating Purchase Order, I receive quotes with a different currency, however the final price is given that includes the taxes in my currency.

As the currency is calculated on the day, it might differ slightly on another day - thus I can't use a formula/converter.

To ensure my bill matches PO, I need to be able to set item prices individually (final price) that have taxes already included. 

At the moment I can only guestimate (guess an estimate ) of the individual amount and hope it balances.

Example:
Purchas Order
Product           quantiy  Unit Price     Taxes  excl           Taxes  incl​

Wine               x20                  ????????           22%                      400.00   

If I order wine per crate, as per example I get the total amount for the crate and not the individual price per bottle- so the invoice shows taxes on the crate and not on individual items. And due to working in multiple currencies all of these fluctuations in price causes discrepancies. 

I don't want to receive the item as 1 unit crate, but rather as 20 items for stock purposes.

Any advice would be appreciated

Kind Regards,
Helena

Avatar
Discard
Best Answer

Multi currency is managed quite OK in Odoo.  And i is not necessary that Purchase order and Vendor bill match perfect. 

I assume you use product costing as FIFO or AVCO.  When you do a goods receipt the product cost is coming from the purchase order.  Calculated at latest rate if foreign currency is used,  When you post the vendor bill and the price (in you local currency) is different, the product cost is adjusted.   You can follow the postings in Inventory->Reports->Valuation.  (This was new in V16 EE).

Managing prices with Tax included is not working in Purchasing. (V16 EE). Product cost seems to be calculated without deducting the taxes.  So you will need to manage the net price and the tax separately in the purchase order.   

Crate and Items: If the number of items in a crate is fixed: always the same, you can create a UOM = Crate and define it as 20 items.  Base UOM for the product = Item. Purchase UOM = Crate. 

Avatar
Discard
Related Posts Replies Views Activity
3
Mar 25
4824
1
Mar 24
1428
3
Oct 23
2869
0
Apr 22
1868
1
Mar 15
4748