Skip to Content
This question has been flagged
purchase_orderbillingtaxes
1 Respondre
2773 Vistes
Avatar
Helena Adriana Nel

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
Descartar
Avatar
Lars Aam
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
Descartar
Related Posts Respostes Vistes Activitat
How to Bill a Purchase Order For Services? Solved
purchase purchase_order billing
Avatar
Avatar
Avatar
Avatar
3
de març 25
6778
How to create several templates for bills & invoice on Odoo online?
templates billing taxes
Avatar
Avatar
1
de març 24
2532
Import vendor bill for multiple POs
purchase purchase_order billing
Avatar
Avatar
Avatar
Avatar
3
d’oct. 23
4061
Billing status in Purchase order in V10 CC
purchase_order status billing
Avatar
0
d’abr. 22
2600
How can I correctly configure tax calculation within europe (TIN)?
purchase_order taxes EU
Avatar
Avatar
1
de març 15
5617