Introduction

If you are thinking of moving from Dynamics GP to Business Central, Microsoft provide an absolutely amazing tool that can migrate your Dynamics GP data to Business Central 😊

This tool will not only migrate your master data, but also some opening balances, and crucially your historical data.

In this two part blog series, we’ll take a closer look at what gets migrated and how it appears in Business Central.

In Part 1 (this post) we’ll focus on opening balances, in particular your Customer and Vendor transactions and your General Ledger opening balance.

In Part 2 will take a look at how the historical data is migrated, and what it looks like once it’s in Business Central.

What do my Sales and Purchasing Opening Balances look like in Business Central?

The migration will transfer Customer and Vendor unapplied transactions currently in the OPEN tables in Dynamics GP.

Customer and Vendor opening balances are posted in separate batches during the migration. After the migration has finished, The first place I usually review them is on the G/L Register page, which provides a complete view of all the opening balance G/L Registers.

You can learn more about Registers and how they function in Business Central in my blog post here

From here I can I highlight one of the batches and click the “General Ledger Entries” button which will show me the General Ledger Entries for the highlighted batch.

As you can see the General Ledger Entries post in and out of the Debtors Control account. This is because the balance for the Debtors and Creditors is migrated as part of the General Ledger Opening Balance.

I can follow the same steps to view the General Ledger entries related to the Vendors by simply highlighting the G/L Register from the Vendors

You can then click “Customer Ledger Entries” to view a list of the OPEN unapplied Sales transactions. The sum of this should match your outstanding Sales transactions in Dynamics GP.

If I want to see the “Customer Ledger Entries” on the actual Customer, I can simply go to the Customer List and drill down on the Balance as per below

If I then drill down on the balance for “Adam Park Resort” I can see how the OPEN transactions in Dynamics GP have created Customer Ledger Entries in Business Central

When you go live with Business Central these entries will show on the “Aged Accounts Receivable” report that you should reconcile back to the “Historical Aged Trial Balance” in Dynamics GP.

If can follow the same process to view my migrated purchasing transactions. In this case the General Ledger Entries will have posted in and out of the Creditors control account and I can view and total my Vendor Ledger Entries as well.

Please note you can also migrate paid transactions however this is performed as part of the historical data migration which we’ll cover in Part 2

What do my General Ledger Opening Balances look like in Business Central?

Now we have seen the Customer and Vendor opening balances, let’s have a look at the General Ledger opening balances.

The first thing to note is that you can specify how many years of General Ledger opening balances you wish to migrate via the “GP Company Migration Configuration”. A screen shot of this is below:

Please note that every single year will then be migrated as an Open Year. So you’ll have to run the “Close Income Statement”, which is Business Central General Ledger Year End process, for those years that have been closed. This will close the Income Statement General Ledger balances to the retained earnings account.

Now we know we can migrate multiple years, lets have a look at how this appears in Business Central 😊.

Before we look at the opening balances its important to understand how the Chart of Accounts differ between Dynamics GP and Business Central.

Dynamics GP uses a segmented General Ledger account, whereas Business Central uses a single General Ledger account and Dimensions for extra analysis. Therefore the migration splits the Dynamics GP General Ledger code and uses the “Main Segment” for the General Ledger code and the other segments as dimensions. You can read more about this in my blog post here and here.

Therefore my migrated Fabrikam Chart of Accounts appears as per below in Business Central.

Again, I find the best place to start to look at how the balances have transferred, is the G/L Register page.

Here we can see that we have a register per Year-Period.

If I drill down on the “General Ledger Entries” for GP2025-1, you can see that we get a summarised total for each Dynamics GP General Ledger Code, rather than the individual detailed entries for the period.

Furthermore, we can match this back to Dynamics GP. So taking the highlighted row below for GL Code 5170 and Division Code 200 and Department Code 00, which is 200-5170-00 in Dynamics GP, we can see we have a balance that has migrated of £3,803.77.

If we have a look in Dynamics GP at code 200-5170-00 we can see the same monthly balance for period 1 of 2025

Taking this a step further, if I go straight to the “General Ledger Entries” page to see all migrated entries, and then filter to the GL code 5170, Division of 200 and Department 00, I can match every single period amount to that Dynamics GP summary shown above:

This proves that my migration has worked. All balances have been migrated on a month by month basis.

Whats also great, is now my GL code is seperate from my Division and Department, I can easily get a sum total at GL Code level and dimension level 😊

Conclusion

As we have seen, your opening balances from Dynamics GP migrate cleanly into Business Central, with Customer and Vendor OPEN transactions and summarised General Ledger balances brought across in a clear and reconcilable way.

In Part 2, we’ll take a closer look at historical data and how it appears in Business Central after migration.

Thanks for reading!

Introduction

When posting journals there may be times when it would be helpful to see what affect the journal would have on balances prior to posting the entries.

In this post we’ll walk through how this can be achieved by using the “Reconciliation Account” feature on the GL account page.

Configure the GL Codes

The first thing you need to do is select the option “Reconciliation Account” on the GL code. You can do this by browsing to the “Chart of Accounts” and selecting a GL code and switching the option “Reconciliation Account” on.

In this example I’m switching the option on for 40500 Prepaid Rent and 30100 Rent Expense.

Create the Journal

Now I create a journal which is going to hit these two GL codes however before I jump in and click “Post” I want a sneak peak at what the balances would be if I were to post the journal.

Run the Test Report

In order to see what the balance of the GL codes would be I need to run the “Test Report” using the following selections:

Then, along with any posting errors, there’s an extra section showing the “Balance after Posting” for each GL code as per below:

In the scenario above this feature could have been especially useful, as I may have wanted the balance in my Pre Paid Rent account to be £0.00 after I’d posted this journal. If this was the case, I can now simply close the Test Report, change the amounts to £510.00 and then post. This would have then prevented an extra journal entry or a potential reversal entry.

Conclusion

This is a handy feature that is going to be espeically useful when posting accrual entries or correcting entries at a reporting period end. This is when accountants maybe checking balances and finalising accounts.

Thanks for reading!

Today I ran into an issue when posting a Warehouse Receipt to a new location I just created. I’m using a new location as I’m testing the processes of Warehouse Receipt and Putaways along with Warehouse Shipments and Picks and I’d rather do this on a new location.

I thought it worth documenting this process as when troubleshooting why the Warehouse Receipt wouldn’t post I found a setup option I could change which gave me a better, more comprehensive error, enabling me to get to the root cause of the issue. This was crucial to understanding why the Warehouse Receipt wouldn’t post.

Starting from the beginning, to create the new location I went to the “Location Setup” window and created the location as per below

I then went ahead and created a Purchase Order so I could work through creating a Purchase Order followed by a Warehouse Receipt and Putaway. I did this by creating a Purchase Order and clicking “Create Whse. Receipt”

Success. This created a Warehouse Receipt, and as all the relevant information was populated, I just need to post this to create the Putaway however when trying to post the document I was presented with the message below:

Hmmm. The error isn’t giving anything away, and when I doubled checked everything seems fine so why isn’t it posting?

After much pondering and testing I stumbled across the setting below in the “Warehouse Setup”

At the moment its set to “Posting errors are not processed”. I therefore switched this to “Stop and show the first posting error” in the hope it would give me more information when posting.

I then tried to post the Warehouse Receipt again and now I get a much better error message

The error is suggesting I haven’t setup posting accounts against my new location. Doh!

I therefore went back to “Location Setup” and clicked “Inventory Posting Setup” and populated the Inventory posting group and posting accounts as per below

I then went back to my Warehouse Receipt and now all the posting accounts have been added it posts fine.

I’m guessing it would have taken much longer to get to the root cause of the issue if it wasn’t for that setting in “Warehouse Setup” so I’m sure this will come in handy in the future as well.

Thanks for reading!