General Ledger
The purpose of this model is to simplify the periodic reconciliation of your general ledger control accounts. This model is used to support the analytical process by validating the data extracted from various M3 applications. Through the validation process, you can rely on the information provided by the various M3 Analytical models.
The validation is done by reconciling with the business accounting data stored in the General Ledger. The data stored in this file is used to deliver the Financial Reports of the business and it is also subject to external audit as required by law. For example, periodic sales revenue information provided in the Sales Analysis model should be reconciled with the periodic sales revenue figures accounted for in the General Ledger.
The facts in this model can be analyzed by these dates:
- Accounting Date
- Entry Date
- Transaction Date
- Int Recon Date
Source information
This model is based on the General Ledger Detail file in M3 BE - FGLEDG. The model enables the user to analyze the monetary values by the division currency, transaction currency, and third currency. To avoid summing up values in different currencies, we recommend to use the currency dimension with the transaction currency, the local currency attribute of the division dimension with the division currency, and the third currency dimension with the third currency amounts.