Multiple ledgers can be merged into a single Account Core Model in Sage X3 ERP. Users have the option of choosing various types of ledgers and assigning different currencies to each one while designing the Account Core Model.
The account core model identifies the ledgers that are used, the currencies in which transactions are posted to the ledger, and how the currency rate is measured when posting in a different currency in Sage X3 ERP.
Each account core model can only have a maximum of 10 ledgers associated with it.
As seen in the screenshot #1 below, ACM (Accont Core Model) has four ledgers: Main Ledger, Analytical Ledger, IAS Ledger and Internal P & L. The last Ledger “Internal P&L” is reported with “CAD” currency. Refer Screenshot#1,and follow these steps to use Multiple Ledger Currency for Transactions in Sage X3V12-
Navigate to All -> Setup -> Organizational structure -> Account core models
Once the Account core model has been defined, the user needs to define the Char of account for it. We have defined 700100 for the BEG ACM, as seen in the screenshot#2 below,
By using the default accounts, we can assign other COA’s against the account; below we have assigned 2 other COA’s apart from the main ledger BEG.
Navigate to All -> Common data -> G/L accounting table -> Accounts
Sage x3v12 user can post a single entry to multiple ledgers. For example, if they have a general ledger and an analytical ledger, they can post to actual accounts in the general ledger and the same values in analytical ledger by following the following path, as shown in the Screenshot #3 below-
Navigate to All -> Financials -> Journals -> Journal Entry
This is how a user can use Multiple Ledger Currency for Transactions in Sage X3V12. Thus, this blog helps us in understanding the methodology for carrying out transactions against the Sage X3 accounts that have multiple ledgers.
GerminIT – Recognised for its X3 implementation and customization the world over, GerminIT is one of the oldest Sage X3 (a Sage Business Cloud Solution) development and implementation enablers and a one-stop solution provider for Sage X3 organizational needs. With a proven track record of X3 development and implementation solutions for clients across the US, UK, Middle East, Australia, Asia, and Africa, we bring complete end-to-end assistance for data migration, system integrations, technical consultations, implementation competence, third-party add-on development, and product customizations.
With GerminIT your business will be supported with the best-in-class Sage X3 customization and development services, integrated applications such as Shipping System | eCommerce | Business Intelligence | POS | WMS | Payment Gateway, and mobile add-ons solutions. GerminIT caters to a wide range of Sage X3 offerings. Currently, we provide end-to-end support with Sage X3 implementation and customization solutions for Sage business partners, Sage PSG, and end-users worldwide.