Feature Explained: Reporting Ledgers

Microsoft Dynamics GPIn Microsoft Dynamics GP 2010, Microsoft introduced the Reporting Ledger functionality which allows journals to be posted to one of three reporting ledgers; base, local, or International Financial Reporting Standards (IFRS).

This functionality is controlled via the General Ledger Setup window (Microsoft Dynamics GP menu » Tools » Setup » Financial » General Ledger);

Reporting Ledgers: Enabling via General Ledger Setup

Before Reporting Ledgers are enabled all transactions will post to the Base ledger; as shown above in the reporting Ledgers frame this ledger is shown even when this functionality is disabled.

Once activated the Local and IFRS reporting ledgers become available;

Reporting Ledgers: Enabled In General Ledger Setup

All three reporting ledgers can have their Descriptions, but not their Names, changed to whatever you prefer (up to 30 characters).

Once reporting ledgers is enabled an extra field becomes available on Transaction Entry Transactions » Financial » General where the user can select the Required Reporting Ledger;

Reporting Ledgers: General Ledger Transaction Entry

Transactions from subsidiary modules, such as Payables Management, will always post to the Base reporting ledger.

The Trial Balance (Reports » Financial » Trial Balance) and Summary Enquiry (Enquiry » Financial » Summary) can be used to report on the reporting ledgers. Here is an enquiry on the Cash – Operating Account in Summary Enquiry;

Reporting Ledgers: Summary Enquiry Base Ledger

And with reporting switched to the Local reporting ledger;

Reporting Ledgers: Summary Enquiry Local Ledger

This needs extending down to the Detailed Enquiry (Enquiry » Financial » Detailed). I drilled down from Period 2 on the Local reporting ledger summary enquiry to the detailed enquiry;

Reporting Ledgers: Detailed Enquiry

As you can see, all reporting ledgers are included within this enquiry which makes the filter on the Summary Enquiry of only limited utility.

One other place that I wish they had added reporting ledgers was to the Account Rollup Enquiry (Enquiry » Financial » Account Rollup) as you’d then have been able to compare reporting ledgers to budgets.

In an upcoming series of posts, I’ll be taking a look at the installation of Management Reporter and some of the pitfalls to watch out for; and I’ll also cover Reporting Ledgers in it.

What should we write about next?

Your Name (required) –
Your Email (required) –

4 thoughts on “Feature Explained: Reporting Ledgers

Leave a Reply

Your email address will not be published. Required fields are marked *