top of page
Writer's pictureakash shukla

How you identify the difference between system-created entries and manually-created entries?

Updated: Jun 11, 2023

Do you know that we can identify if the posted general ledger entries are created automatically or manually 🤔💭


Agenda
 

In businesses, when an audit happens, auditor wants to know if the general ledger entries created in the ERP is system created or manual.


Basically if you are using a system all the entries created should be system generated. This is the common conception and auditors wants to know if their is a deviation from this behavior.


How to do this:


Step 1:

Go to the general ledger entries page and add a filter for the System created entry. It's a Boolean field so we have two options – Yes/No



When select No, it means entries filtered by manually created entries.



When select Yes, it means entries are filtered by automatically created entries.



What is the logic behind this?


The logic for automatically created entries:

As you are all aware posting setup is the main key component of the business central.

For those GL account tagged in the posting setups, business central consider those as automatic entry.


Logic for Manual created entries:

GL account in which direct posting Boolean is true, consider those as manual entry.



But there is an exception:


If a GL account is tagged in a posting group and direct posting group Boolean is also true, in this scenario those GL entries consider as automatically created entries.


For better understanding, I posted one cash receipt journal with a bank account and in Bank GL account direct posting is true. In Account receivables (Customer Posting Group) GL account direct posting is true.


Both GL accounts are tagged in the Bank account posting group and customer posting group.




But if we post any expenses with the direct posting GL account then in this Business Central creates both types i.e. automatic and manual entries.


The debit amount line (Rent expense) is posted as a manually created entry and the Credit amount line (Bank Account) is posted as an automatically created entry.

Even the document number is the same for the transaction.


For better understanding, I posted the Rent payment from the bank account. Please see the below entries:






I hope this blog helps you to understand the difference between manual and automatically created entries.


Please test this by yourself and feel free to share your feedback in the comments




Cheers…. 😊





390 views0 comments

Recent Posts

See All

Comments


bottom of page