Dynamics GP Vs Dynamics 365 Business Central – Reconciling AP and AR to the General Ledger

Introduction

Its good practice to periodically reconcile the General Ledger control accounts to the sub ledgers. In this post I’ll highlight the reports and enquiries that can be used in Dynamics GP versus the reports and enquiries that can be used in Dynamics 365 Business Central to achieve this task.

Dynamics GP

On the General ledger side you can obtain a balance on a GL code at any given period via the “Enquiry > Financial > Summary” window shown below:

This window provides information on the debits, credits, net change and period balances for an individual account for the year selected.

I love this view as it gives you a lot of information in a handy window that’s also easy to consume. You can drill down by clicking on the blue hyperlink headings to get to the detailed information.

** Incidentally Dynamics GP stores the information displayed in the summary window in a separate table from the detail information. Its not summed data based on detailed transactions. This provides performance efficiencies if there’s lots of data however on rare occasions it might not accurately reflect the period balance. (seasoned GP users will be well aware of this headache).

Unfortunately you can’t get the General Ledger balance at a date that’s in the middle of the period using this window. If you want a General Ledger position at a given date I’d recommend using the “Reports > Financial > Trial Balance > Summary” report.

With the restrictions I’ve added above I can see the General Ledger balance at the 25/04/27. If I wanted a detailed breakdown I’d use the “Reports > Financial > Trial Balance > Detail” using similar restrictions.

Once you have the control account balance you can obtain the AP or AR balance via the relevant Historical Aged Trial Balance report. You can access this via “Reports > Sales (or Purchasing) > Trial Balance > Historical Aged Trial Balance”. The options for the report are shown below:

Key fields on this window are:

Print/Age as of:- Using this report you get a retrospective position on the ledger at any given time. For example if I wanted to reconcile back to January 2020, I’d simply change this date to 31/01/2020 and the report would disregard all activity after this point.

Select Transactions for Report Using:- You can select either Document Date or Posting Date. When reconciling to the General Ledger its recommended to use Posting Date.

Detail:- You can either tick or untick this option if you want a summary per Debtor or Creditor or the detail information.

Using the information from this report you can reconcile back to the GL to ensure the ledgers balance.

Its also worth noting that there is a “Reconcile to GL” feature you can use via “Tools > Routines > Financial > Reconcile to GL”. This tool is very useful as it provides an insight into potential differences between the GL and a given subledger. i.e. it would highlight manual journals that could be causing issues.

Dynamics 365 Business Central

If I want to see a quick balance of a General Ledger code in Dynamics 365 Business Central I’d start by going to the Chart of Accounts page as per below:

In this page I can filter for the General Ledger codes in question and filter the totals using the “Filter totals by:” option.

When I enter a “Filter totals by:” restriction the values shown in the “Balance at Date” and “Net Change” columns change automatically based on the filter (however the “Balance” column always shows the current balance). Therefore in the screen shot above the “Net Change” is showing the change in April and the “Balance at Date” is showing the balance at the end of April.

This is a great feature as I can simply change this filter to any date in the year. I can then drill down on the detail transactions by clicking the amounts.

** Incidentally, the “Balance at Date” and “Net Change” values are dynamic as the data displayed on the page is based on detailed data. (they also don’t exist as fields in a table – they are a special type of field called flow fields). The “Filter list by:” filter is a special filter called a “Flow Filter” that work with those flow fields and performance is maintained by SIFT indexes (SQL Indexed Views).

Its also worth noting I can get a simpler view showing all period amounts for a given General Ledger code by highlighting the General Ledger code and selecting “Navigate > Balance > G/L Account Balance” from the navigation bar.

Again I can drill down on the amounts to see detailed information. This also offers a more familiar way of viewing the balance for a Dynamics GP user.

To obtain a balance on the AP and AR side I’d use the relevant Aged Accounts reports as shown below. (just search for “Aged Accounts” to see these)

The key fields are

Aged as of:- this is similar to the GP option “Age/As of” and will give you the position “as at” a given date enabling you to reconcile to a point in time.

Print Details:- With this option checked the report is printed with transaction detail however left unchecked you are presented with a summary per debtor.

Using the information from this report you can reconcile back to the General Ledger to ensure the ledgers balance

Conclusion

As expected both products offer great and simple options for reconciling your sub ledger back to the General Ledger control accounts.

As I stated above I really like the GP summary enquiry screen however I also love the flexibility that the flow filters provide in Dynamics 365 Business Central. (FYI, this functionality is offered throughout the system).

Also, in Business Central, as the summary values are provided based on detailed data in the ledger entries table, I can guarantee the balances are providing accurate information every time.

Thanks for reading!

Dynamics GP – What are the P/L Source Document entries on the year end journal?

When you run the year end routine on the General Ledger in Dynamics GP the system automatically creates a journal to bring forward the balances for the Balance Sheet codes and it also closes all the profit and loss codes to the retained earnings account.

When you look at the header of the year end journal that’s created it shows a source document of BBF (Balance Brought Forward)

However if you take a closer look at the year end journal in smartlist you can see that some of the lines have a source document of “P/L”.

So why the mixture of BBF and P/L source documents for the year end journal?

The BBF entries are created to bring forward the balances of the “Balance Sheet” accounts and the “P/L” entries are created by closing the profit and loss accounts to the retained earnings account. As my demo data has multi currency postings to various profit and loss codes I get one entry per currency.

To confirm the correct amounts have been posted to the retained earnings account I can run the query below in SQL that sums all the amounts posted to the profit and loss accounts for the year 2024, and this reconciles back to the amounts posted to the retained earnings account on the year end journal:

The BBF entries are quite well known but I couldn’t find much information on the P/L source document which is why I created this post.

Thanks for reading!

Dynamics 365 Business Central – Posting a Payables invoice to multiple GL codes using a Purchase Journal

Introduction

As I learn and familiarise myself with Dynamics 365 Business Central I often post something in Dynamics GP and then wonder how this same task could be achieved in Dynamics 365 Business Central.

Today’s pondering was looking for the equivalent to the “Payables Transaction Entry” window that we have in Dynamics GP.

I know you can post to G/L accounts via the “Purchase Invoice” page in Dynamics 365 Business Central but to me this is primarily a “Purchase Order Processing” type window. I wanted to post a sundry payables invoice, onto a vendor, to multiple GL codes, without the need to touch the “Purchase Invoice” window.

As usual there is more than one way to do this however I focus on the “Purchase Journal” page. I also elude to why I think you can achieve the same using other “journal” pages, although you might not necessarily want to use those anyway 🙂

Dynamics GP – Payables Transaction Entry

In Dynamics GP you can post a sundry payables invoice in a very straight forward and easy to understand window called “Payables Transaction Entry”.

This window has no link to Purchase Order Processing. We tend to advise users to use this window for posting invoices for sundry items and things you wouldn’t necessarily have a Purchase Order for. You can click “Distributions” and record multiple GL codes for this one invoice. Its also handy to import transactions into very quickly and users seem to prefer this window for speed of entry.

Dynamics 365 Business Central – Purchase Journal

There are various “journal” pages in Dynamics 365 Business Central so I turned to the “Purchase Journal” page to achieve my goal.

The first thing I found I had to select was the option “Show more columns” as per below.

Crucially this adds the “Account Type” option which gives the user the ability to add “G/L Account” when keying in the Payables document:

Now I had the “Account Type” field available for entry I found as long as you keep the Document Number, External Document No and Posting Date the same you are able to add a payables document with multiple lines.

First you add the “Account Type” of “Vendor” and key in the first line with the total amount of the document. On the subsequent lines you can choose “G/L Account” as the account type and enter the G/L distribution breakdown. Also, if you wish to analyse tax to any of the distributions you must populate the “Gen. Posting Type” with “Purchases” and then populate the “VAT Prod. Posting Group”.

In the end you should have something like this and the document will post successfully

Other takeaways

As with any investigation you usually find some interesting things along the way.

The major takeaway I found is that you can post the same purchase invoice using the “General Journal” page. After looking more closely it seems this is possible as both pages are based on the “Gen. Journal Line” table. Therefore all the fields (and business logic) you need are available on the “General Journal” page as well.

See below. The “Purchase Journal” and “General Journal” pages are based on the same table:

Purchase Journal
General Journal

However, as a word of caution, if you were to post the same purchase invoice from the “General Journal” page the transaction is given a “Source Document” of “GENJNL” in the “G/L Register” rather than “PURCHJNL”.

See below. The top G/L Register was posted using the “General Journal” page and the other using the “Purchase Journal” page.

Therefore I’d suspect its best to use the specific “Purchase Journal” for these postings.

Thanks for reading!