Things you need to know about Multi-Currency in Sage X3

By | November 30, 2017

How will multi-currency support benefit organizations?

Today, businesses are not bound by borders. With globalization and the growing transparency in business operations, organizations are exploring opportunities in foreign markets. To function exceptionally in the global marketplace, businesses need multi-currency support to carry out seamless transactions. Given the complexity in managing multi-currency for different scenarios, Sage X3 is a holistic enterprise management solution that offers multicurrency functionality enabling businesses to handle different currencies within your accounting system. Sage X3 Multi-Currency support calculates exchange rates using the Vendor / Customer’s currency or your native currency and provides the costs you gain or lose due to the currency fluctuations to General Ledger. Sage X3 ERP application completely supports transactions across multiple currencies and includes the following capabilities:

  • Transactions of different currencies from your accounting currency
  • Exchange differences are managed automatically by the reconciliation system
  • Maintain bank accounts with the multiple currencies

Check now: Sage X3 – An unparalleled business management solution

multi currency in sage enterprise management

What are the important concepts of multi-currency?

The multi-currency feature in Sage X3 comprises of two main concepts –

Conversion: Conversion refers to a foreign currency transaction that is immediately converted in the functional currency (i.e. the ledger currency).

Translation: Translation refers to the restatement of an entire ledger or balances for a company from functional currency to foreign currency.

How to configure Sage X3 Multi-Currency in your organization?

In order to configure Sage X3 Multi-Currency in your organization, please follow the step by step procedure as stated below:

  1. Customer Master Setup

  1. Accountings Tagging in Customer Master

  1. Accounts Master setup

Below is the Accounting Effect for the multi-currencies for Export.

Invoice in Foreign Currency (), Payment in Local Currency () Profit.

Invoice Customer/Account Receivable A/c Debit  
To Sales A/c   Credit
COGS A/c Debit  
To Goods Sold Not Invoiced A/c   Credit
Payment Bank / Cash A/c Debit  
To Suspense Account for Currency A/c   Credit
Suspense Account for Currency A/c Debit  
Customer/Account Receivable A/c   Credit
Unrealised Income Customer/Account Receivable A/c Debit  
To Unrlsd Forex Gain/Losses AR/AP A/c   Credit

Invoice in Foreign Currency (), Payment in Local Currency () Loss.

Invoice Customer/Account Receivable A/c Debit  
To Sales A/c   Credit
COGS A/c Debit  
To Goods Sold Not Invoiced A/c   Credit
Payment Bank / Cash A/c Debit  
To Suspense Account for Currency A/c   Credit
Suspense Account for Currency A/c Debit  
Customer/Account Receivable A/c   Credit
Unrealised Income To Unrlsd Forex Gain/Losses AR/AP A/c Debit  
To Customer/Account Receivable A/c   Credit

Invoice in Foreign Currency (), Payment in Foreign Currency () Profit.

Invoice Customer/Account Receivable A/c Debit  
To Sales A/c   Credit
COGS A/c Debit  
To Goods Sold Not Invoiced A/c   Credit
Payment Bank / Cash A/c Debit  
To Customer/Account Receivable A/c   Credit
Unrealised Income Customer/Account Receivable A/c Debit  
To Unrlsd Forex Gain/Losses AR/AP A/c   Credit

Scenario IV Invoice in Foreign Currency (), Payment in Foreign Currency () Loss.

Invoice Customer/Account Receivable A/c Debit  
To Sales A/c   Credit
COGS A/c Debit  
To Goods Sold Not Invoiced A/c   Credit
Payment Bank / Cash A/c Debit  
To Customer/Account Receivable A/c   Credit
Matching To Unrlsd Forex Gain/LossesAR/AP A/c Debit  
To Customer/Account Receivable A/c   Credit

Invoice in Foreign Currency (), Payment in Local Currency () Loss.

Invoice Customer/Account Receivable A/c Debit  
To Sales A/c   Credit
COGS A/c Debit  
To Goods Sold Not Invoiced A/c   Credit
Payment Bank / Cash A/c Debit  
To Suspense Account for Currency A/c   Credit
Suspense Account for Currency A/c Debit  
Customer/Account Receivable A/c   Credit
Unrealised Income To Unrlsd Forex Gain/Losses AR/AP A/c Debit  
To Customer/Account Receivable A/c   Credit

Invoice in Foreign Currency (), Payment in Foreign Currency () Profit.

Invoice Customer/Account Receivable A/c Debit  
To Sales A/c   Credit
COGS A/c Debit  
To Goods Sold Not Invoiced A/c   Credit
Payment Bank / Cash A/c Debit  
To Customer/Account Receivable A/c   Credit
Unrealised Income Customer/Account Receivable A/c Debit  
To Unrlsd Forex Gain/Losses AR/AP A/c   Credit

Scenario IV Invoice in Foreign Currency (), Payment in Foreign Currency () Loss.

Invoice Customer/Account Receivable A/c Debit  
To Sales A/c   Credit
COGS A/c Debit  
To Goods Sold Not Invoiced A/c   Credit
Payment Bank / Cash A/c Debit  
To Customer/Account Receivable A/c   Credit
Matching To Unrlsd Forex Gain/LossesAR/AP A/c Debit  
To Customer/Account Receivable A/c   Credit

About Us

Greytrix Africa is a leading Implementation, Reselling and Consulting partner for Sage X3 (Sage Enterprise Management), Sage 300, Sage Enterprise Management HR (Sage X3 People) & Sage CRM based out of Nairobi, Kenya in East Africa region catering to Tanzania, Ethopia, Middle East, Australia and Asia businesses.

Greytrix Africa offers professional services such as Implementation & configuration, Business Process Analysis, Project Management, Customization, Integrations & Migrations, Technical support and Onsite resource augmentation along with enhancements within Sage X3 (Sage Enterprise Management), Sage Enterprise Management HR (Sage X3 People), Sage CRM and Sage 300 (Accpac) across various industry verticals like Process Manufacturing (Food & Beverages, Chemical), Discrete manufacturing (Automotive, Textile & Apparel), Non Profit, Health-care Industry and Services Industry (Financial , Software & Engineering).

For more information on Sage X3 Consulting Services, please contact us at sales@greytrix.com.We will be glad to assist you.