Dynamics GP Vs Dynamics 365 Business Central – Where is the General Ledger Journal Entry Number in Business Central?

Introduction

When you post a transaction in a subsidiary module in Dynamics GP, a journal is created in the General Ledger to record the transaction in the chart of accounts. The journal has its own unique journal number that groups all the distributions related to that transaction together and is stored in the GL table on all the lines.

Being a long time Dynamics GP user, when I started using Business Central, on posting a transaction I looked for the equivalent journal number in the G/L Entries, but couldn’t find it? Yes, there are G/L entries created, but I couldn’t find what I classed as a unique journal number that binds these together just like the Dynamics GP journal number.

In this post I’ll walk through what I regard as the closest equivalent to the Dynamics GP journal number in Business Central.

Dynamics GP – Journal Number

When you post a transaction in a subsidiary module in Dynamics GP, like a Sales Invoice for example, this is recorded in the General Ledger as a Journal Entry.

For example when I post the Sales Invoice below its recorded in the General Ledger using a unique Journal Entry number. The same journal number is stored on all the lines of the journal.

And here’s the Journal Entry recording the transaction in the General Ledger. The journal entry number is stored on all the distribution lines.

Therefore when posting one transaction in Dynamics GP, you get one Journal Entry with a unique number grouping all the distributions relating to that transaction in the General Ledger.

** Please note things like the originating document number and customer number are also transferred and stored in the GL table in Dynamics GP just like Business Central.

Dynamics 365 Business Central – G/L Entries

Going back to the example of a Sales Invoice, when you post a Sales Invoice in Business Central a series of Entries are created including G/L Entries.

Therefore if I were to post the Sales Invoice below

I’d get the following G/L Entries.

As you can see each line has a unique “Entry No.”. There is no obvious unique number from a GL point of view that groups all these lines together. (You can group them together using the “Document Number” but this is the Sales Invoice document number. There is no GL specific unique reference that groups these together in the G/L Entries table.)

Up steps the G/L Register

Although not obvious at first, whenever you post any transaction in Business Central, along with all the various entries that are created, a G/L Register is also created.

The G/L Register has its own unique number and encompasses all the entries that have been created by posting the transaction. It does this by holding the “From Entry No.” and the “To Entry No.”

Below is the G/L Register that was created by posting the Sales Invoice above

As you can see this has a unique GL reference. This is the “No.” column.

Therefore this is what I regard as Business Centrals equivalent to Dynamic GPs journal number.

Conclusion

Once I’d grasped this concept of entries and registers, I felt I had a greater understanding of the posting flow in Business Central.

Thanks for reading!

** Please note there is also a “Transaction No.” field stored on the G/L Entries which appears unique however I’ve found you can post one document number which can generate more than one “Transaction No.”. I blogged about this here

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s