Skip to main content

Multi-Currency in the Inventory Module

Purchase products in your supplier's currency, and the system will calculate cost and profit in your company's base currency.

J
Written by Julia

When your supplier works in US dollars and you sell in euros, you used to have to convert purchase prices manually. Cost then depended on whichever rate was used for the conversion, and it was hard to check the calculation later.

Now postings and purchase orders are kept in the supplier's currency. For example, you buy displays from the US at $50 each. In the posting, you enter the price in dollars, and the system records the rate of $1 = €0.90 and saves the purchase cost – €45 per unit. When you sell a display, the system converts the $50 at the rate at the time of sale: if it's already €0.95, the cost for that sale will be €47.50.

Postings and purchase orders in the supplier’s currency

As soon as you select a supplier, the system adds their currency to the document. All prices will be in this currency, and you can't change it manually. If you select a supplier with a different currency in a draft, you'll need to enter the prices again.

The printed purchase order you send to the supplier will also be in their currency. And when the products arrive and you create a posting from the purchase order, the supplier, currency and prices are carried over automatically. The system calculates the purchase cost at the rate from Settings → Finance that applies when the posting is completed.

Paying the supplier for a purchase order in their currency

You can pay a purchase order from a financial account in the supplier's currency. If there's no such account or you don't have access to it, the system won't let you create the payment and will tell you why. And if there aren't enough funds in the account, transfer them from another account with currency exchange.

Cost of each batch and serialized unit

For each posted batch, the system stores the purchase price in its currency, the exchange rate and the cost in the base currency. For products with serial numbers, this is done separately for each unit. You can see this data in the Stock section of the Inventory module and in the product profile.

If one product arrived in batches in different currencies, the currency is shown for each batch rather than for the total stock. The rate and purchase cost of a batch won't change, even if you update the rate in the settings. They stay with the product when you transfer, return or write it off.

Cost in sales and reports

When you sell a product purchased in a foreign currency, the system takes the purchase price of the exact batches or serialized units being sold and converts it at the current rate. This way, profit in reports reflects exchange rate changes, and amounts are still shown in the base currency.

Read more in the guide to selling products.

This is the third stage of multi-currency support: after currency accounts and settlements with contacts, it's the turn of postings and purchase orders. We'll keep developing multi-currency support and would be glad to hear what you're missing.

Have questions or suggestions? We're always available in the support chat.

Did this answer your question?