Multi-Currency setup and payment processing with currency rates in Acumatica

By | November 23, 2022

Acumatica has introduced a feature of multiple base currencies. The feature is available in the financial module where we can automatically compute realized and unrealized currency gains and losses, perform account revaluations and translate complete financial statements

Enable Multi-Currency Accounting Features:

Navigate to System Management > Licensing > Enable/Disable Features.

The initial step would be to enable Multi-Currency Accounting Features where we can activate foreign currencies in the system, which will be used for accounting and reporting purposes. The base currency will be used for reviewing journal transactions made in foreign currencies and for calculating and converting amounts in imported records.

If the Multicurrency Accounting feature is not enabled then only one currency, which is called the base currency, is used for accounting.

Sales Order Side Panel on Sales Order GI

Currency Management Preferences and Currency Rate Types:

For Currency Management Preferences, Navigate to Currency Management > Preferences > Currency Management Preferences.

For Currency Rate Types, Navigate to Currency Management > Preferences > Currency Rate Types.

Setting up the Realized Gain and Loss account and Rate type to be used for each kind of invoice and payment transaction.

02 Currency Management Preferences and Rate Types

SPOT (Floating Exchange Rate) is the current price for changing one currency for another. It is automatically installed by Acumatica and the default rate type is used for all transactions. This setup is done when the multi-currency feature is enabled.

Currency Setup:

Navigate to Currency Management > Profiles> Currencies.

When a company is set up, the base currency will be set automatically. Transactions on Acumatica will convert to the base currency. Transactions can be done using other currencies, but the difference is the conversion rate between the two currencies. Create Currency ID as an internationally accepted currency id to perform automatic processing of currency rates. Provide Description, Symbol, Decimal precision, and check Use for Accounting checkbox for live processing.

03 Currency Setup

Currency Rate Setup

Navigate to Currency Management > Profiles > Currency Rates

04 Currency Rate Setup

Currency Rate History By Date to View Reports

Navigate to Currency Management > Reports > Currency Rate History by Date. Enter From Date To Date and click on the Run Report button to view the historical data of currencies for a selected date range.

05 Currency Rate History

Customer setup for setting Multi-currency and Rates

Navigate to Receivables > Profiles > Customers.
Choose the customer and navigate to the Financial tab and make sure Currency Id, Currency Rate Type is entered and checkboxes are checked for Enable Currency Override and Enable Rate Override.

05 Currency Rate History

Processing Invoice

Navigate to Receivables > Transactions > Invoices and Memos. Create an invoice with the Date (Nov 2021) and choose the customer that is set up for multi-currency and release the invoice. Navigate to Financial Tab and click on Batch Number to view journal transactions with Credit and Debit amounts of EUR currency.

07 Released AR Invoice with Journal Transaction

Processing Payments

Create payment against an invoice with the Date (Nov 2022) and navigate to journal transaction by clicking the batch Number on the Payment screen.
When payment is done with the same currency then there is no Gain or loss. Click on the View Base button on the currency field to check the Gain/loss achieved based on exchange rates.

08 Released Payment with Journal Transactions

This blog helps us in setting up multi-currency and process payments with currency rates in Acumatica.

Greytrix, with its 22+ years of expertise as the Sage Development partner, extends its mastery to bring Acumatica to modern businesses. Greytrix offers complete end-to-end professional services for Acumatica, ranging from development, support, technical assistance, consulting, and system integrations.