Use Cases / Context

When a purchase order is in a foreign currency, the deposit is usually settled for an exact company currency amount that does not match the exchange rate configured for that day. Odoo books the deposit at the rate, so the deposit account never closes out cleanly against what was paid.

A paid deposit is a non-monetary asset, so the goods are measured at the deposit’s own rate for the prepaid portion and at the current rate for the remainder. The difference is part of the acquisition cost rather than an exchange gain or loss, which is why it is booked into the product lines.

Usage

Register the deposit with the standard Register Deposit wizard, and enter the company currency amount actually paid in the Company Currency Amount column of the deposit bill before posting it. The column is optional, and can be shown from the bill line list.

Create the final bill from the purchase order as usual. The deposit offset line is pinned to the amount entered on the deposit bill, and the exchange rate difference is added to the product lines.

The example below follows a purchase order of USD 100 with a 30% deposit, where the deposit of USD 30 is settled for JPY 3900, the rate on the deposit bill date is USD 1 = JPY 150, and the rate on the final bill date is USD 1 = JPY 160.

Deposit bill. Without the module the deposit is converted at the rate of the day; with it, the balance is forced to the amount that was really paid.

Final bill. The offset line is read back from the posted deposit bill, so the deposit account closes out at what was paid and the difference lands in the goods instead.

Without the module the deposit account is left with JPY 300 that no further document will clear, and the goods are valued at the closing rate alone. With the module the deposit account is back to zero, and the product line carries the 3900 paid for the deposit plus USD 70 at the current rate; the payable is the remaining USD 70 at that rate in both cases.

The column only appears on a deposit bill in a foreign currency, the deposit being the one amount known outside Odoo. In the company currency there is no conversion to override, so the field is refused there.

Everything on the final bill is derived from what was entered: the offset line is read back from the posted deposit bill and the goods lines take the rate difference. Leaving the field empty on the deposit bill opts out of all of it – the deposit, the offset and the goods are then converted at the exchange rate exactly as Odoo does without this module.

The bill that carries the deposit offset has to invoice the order in full. Posting one that leaves part of the order unbilled is refused, because the whole deposit is relieved on that first bill and its difference would be charged to the quantities billed first alone.

Known issues / Roadmap

The deposit is relieved in full on the first bill that follows it, so the difference between the deposit as paid and the exchange rate can only be charged to the goods without distorting them when those goods are the whole order. Billing an order in instalments is therefore not supported: the bill that carries the deposit offset must invoice every line of the order.

Posting a bill that leaves part of the order unbilled is refused with an explanation. Clearing the Company Currency Amount on the deposit bill opts out and restores the standard exchange rate conversion throughout.

Supporting instalments would mean spreading the difference over the whole ordered quantity and carrying the unabsorbed part forward to later bills, which have no deposit offset line left to hold it.

Bug Tracker

Bugs are tracked on GitHub Issues. In case of trouble, please check there if your issue has already been reported. If you spotted it first, help us to smash it by providing a detailed and welcomed feedback.

Do not contact contributors directly about support or help with technical issues.

Credits

Maintainers

This module is maintained by the OCA.

OCA, or the Odoo Community Association, is a nonprofit organization whose mission is to support the collaborative development of Odoo features and promote its widespread use.

Current maintainers:

This module is part of the OCA/purchase-workflow project on GitHub.

You are welcome to contribute. To learn how please visit https://odoo-community.org/page/Contribute.