Infor SyteLine3 min readNetray Engineering TeamUpdated March 4, 2025

How to Set Up Multi-Currency in SyteLine

Multi-currency support in SyteLine enables manufacturers to transact with international customers and vendors in their local currencies while maintaining consolidated reporting in your base currency. Configuration involves defining currency codes, exchange rate tables, and revaluation procedures. This guide covers the complete multi-currency setup for purchasing, sales, and financial reporting in CloudSuite Industrial.

Configuring Currency Codes and Exchange Rates

Navigate to Finance > Currency > Currency Codes to define the currencies your organization transacts in. The SL_CurrCode IDO manages records in the curr_code table. Set your base (functional) currency in the GL Parameters form. Then configure exchange rate tables at Finance > Currency > Exchange Rates, entering buy and sell rates for each foreign currency. SyteLine supports daily, monthly, and spot rate tables for different transaction types.

Define all trading currencies on the Currency Codes form with ISO 4217 codes (e.g., USD, EUR, GBP, JPY)
Set the base currency for GL reporting in Finance > General Ledger > GL Parameters
Enter exchange rates on the Exchange Rates form with effective dates for rate history tracking
Configure rate types (daily spot, monthly average, period-end closing) for different transaction and reporting needs

Setting Up Foreign Currency Transactions

Assign currencies to customer and vendor records to enable foreign currency transactions. On the Customers form, set the default currency on the Financial tab. For vendors, configure the currency on the Vendors form. The SL_SOHeader and SL_POHeader IDOs handle currency conversion during order entry, applying the current exchange rate from the rate table. All transaction amounts store both foreign and base currency values for dual reporting.

Assign default transaction currencies to each customer and vendor on their respective master records
Configure currency-specific payment terms if discount calculations vary by currency
Set up foreign currency bank accounts on the Cash Management > Bank Accounts form for payment processing
Enable the currency override option on sales and purchase orders for one-time rate adjustments

Running Currency Revaluation and Reporting

At period end, run currency revaluation to adjust open AR and AP balances to current exchange rates. Navigate to Finance > Currency > Currency Revaluation to execute the revaluation process. The SL_CurrReval IDO calculates unrealized gain or loss amounts based on the difference between the transaction rate and the period-end closing rate. Revaluation entries post to designated gain/loss GL accounts and reverse at the start of the next period.

Run Currency Revaluation monthly using period-end exchange rates for all open foreign currency balances
Configure unrealized gain and loss GL accounts in the Currency Revaluation Parameters form
Generate the Currency Revaluation Report to review adjustments before posting to the general ledger
Use the Multi-Currency Financial Statements feature to produce reports in both base and reporting currencies

Frequently Asked Questions

How many currencies can SyteLine support simultaneously?

SyteLine has no hard limit on the number of currencies. Most global manufacturers operate with 5-15 active currencies. Each currency requires exchange rate maintenance, which can be automated through bank feed integration or the Infor ION integration layer. The system stores transaction amounts in both the transaction currency and base currency, requiring approximately 20-30% additional database storage for multi-currency operations.

How does SyteLine handle exchange rate gains and losses?

SyteLine tracks realized gains and losses at the time of payment or receipt, posting the difference between the invoice rate and payment rate to the configured realized gain/loss account. Unrealized gains and losses are calculated during period-end revaluation for open balances. Typical manufacturers see 1-3% of revenue affected by currency fluctuations. Both realized and unrealized amounts appear on the Currency Gain/Loss Report.

Can exchange rates be automatically updated in SyteLine?

Yes, SyteLine can import exchange rates automatically through the Exchange Rate Import utility or via Infor ION integration with external rate providers. Configure the import source in Finance > Currency > Exchange Rate Import. Most implementations update rates daily using feeds from the European Central Bank or commercial providers. The import process takes under 5 minutes and updates rates for all configured currency pairs simultaneously.

Key Takeaways

1Configuring Currency Codes and Exchange Rates: Navigate to Finance > Currency > Currency Codes to define the currencies your organization transacts in. The SL_CurrCode IDO manages records in the curr_code table.
2Setting Up Foreign Currency Transactions: Assign currencies to customer and vendor records to enable foreign currency transactions. On the Customers form, set the default currency on the Financial tab.
3Running Currency Revaluation and Reporting: At period end, run currency revaluation to adjust open AR and AP balances to current exchange rates. Navigate to Finance > Currency > Currency Revaluation to execute the revaluation process.

Setting up multi-currency operations in SyteLine? Netray's global manufacturing consultants can configure your currency management to handle complex international transactions seamlessly.

Talk to an Expert See a Demo

Related Resources

Infor SyteLine