Skip to main content

Business Central: Created By vs Modified By in Ledger Entries

In Business Central, the name on a ledger entry is the person who posted it, not the person who keyed in the document. This surprises many users, especially when they open Page Inspection and see two different names on the same entry.

The same rule applies to general ledger, customer, vendor and other ledger entries. This post explains what the two system fields mean, why they can show different people, and how to find the original creator when you need it.

What the two fields mean

Every table in Business Central has system fields that record who inserted a record and who last changed it. You can see them in Page Inspection (Ctrl+Alt+F1) under Table Fields.

Field What it records Does it change?
SystemCreatedBy The user who inserted the record. For a ledger entry, this is the user who posted. Never
SystemCreatedAt The date and time of posting Never
SystemModifiedBy The last user who updated the record after it was created Every time the entry is updated
SystemModifiedAt The date and time of that last update Every time the entry is updated

The standard User ID column on the ledger entries page also shows the user who posted, so it normally matches SystemCreatedBy.

Right after posting, the created and modified fields show the same person. They only become different when someone touches the entry later.

Scenario: three users, one journal batch

Only the user who posts appears on the ledger entry. Take a common setup with three people:

  1. User A creates the journal batch, enters the lines and sends it for approval.
  2. User B approves the batch.
  3. User C posts the batch.
User What they did Shown on the ledger entry?
User A Entered the journal lines No
User B Approved the batch No
User C Posted the batch Yes: User ID, SystemCreatedBy and SystemModifiedBy

The reason is simple. The ledger entry does not exist until posting, so the system sees User C as the one who created it. The journal lines that User A keyed in are deleted once the batch is posted, and their creator name goes with them.

The same rule applies to G/L entries, customer and vendor ledger entries, their detailed entries and the G/L register. Posted sales and purchase documents work the same way: the posted invoice shows who posted it, not who prepared it.

Why you may see two different names

Two different names mean someone did something to the entry after it was posted. The amounts and posting date cannot be edited, but a ledger entry is still updated in the background by many everyday actions.

Action after posting What gets updated on the entry
Apply or unapply the entry Open, Closed by Entry No., Closed at Date
Select the entry in Apply Entries, a payment journal or a cash receipt journal Applies-to ID and Amount to Apply, even before the payment is posted
Edit a field with Edit List Due Date, Pmt. Discount Date, On Hold
Export a payment file Exported to Payment File
Reverse the transaction Reversed

Whoever performs any of these becomes the new SystemModifiedBy. It does not mean the posting itself was changed. You will see this most often on customer and vendor ledger entries, because they are applied and paid. G/L entries are rarely updated after posting.

For example, a finance manager posts a purchase invoice on 1 October. A few days later, an intern prepares the payment journal and selects that invoice for payment. The invoice entry now shows the manager as SystemCreatedBy and the intern as SystemModifiedBy.

Quick reference: who appears in each scenario

SystemCreatedBy always follows the poster, and SystemModifiedBy follows the last person who touched the entry.

Scenario Entry you are looking at SystemCreatedBy SystemModifiedBy
A enters the journal, B approves, C posts The new entry C C
A posts an invoice, nobody touches it after The invoice A A
A posts an invoice, C later posts a payment applied to it The invoice A C
A posts an invoice, C later posts a payment applied to it The payment C C
A posts an invoice, C selects it in a payment journal but has not posted yet The invoice A C
A posts an invoice, C changes the Due Date with Edit List The invoice A C
A posts an invoice, C reverses it The original invoice A C
A posts an invoice, C applies it, D later unapplies it The invoice A D

The last row shows the limit of these fields. SystemModifiedBy keeps only the most recent user, so User C's earlier action is no longer visible there.

How to find the original creator

Standard Business Central does not keep the creator's name on posted documents or ledger entries. If you need it, there are three options.

Option What it shows Good to know
Posted Approval Entries Sender ID (who sent for approval) and Approver ID Needs an approval workflow. The sender is usually the creator, but someone else could send another person's document.
Change Log Who inserted the document or journal line, and when Turn on Log Insertion for Sales Header (table 36), Purchase Header (table 38) or Gen. Journal Line (table 81). It only records from the day you enable it. Log a few key fields only, to protect performance.
Customisation A Created By field carried from the document to the posted document and ledger entry The only way to see the creator directly on the ledger entries page.

For most audit needs, an approval workflow is enough. Posted Approval Entries give you the preparer and approver, and the ledger entry gives you the poster.

Summary

  • Created By = who posted. Not who keyed in the document, and not who approved it.
  • Modified By = who last touched the entry. Applying, selecting for payment, editing the due date and reversing all count.
  • Two different names are normal. They mean a later action happened, not that the posting was changed.
  • To know the original creator, use approval workflows, the Change Log or a small customisation.

Comments

Popular posts from this blog

How to Reverse Posted Documents in Business Central

  If you need to amend or change a posted documents in Business Central, there are few ways to do it instead of having you to manually create a reversal journal or Credit Memo to rectify a Posted Document. Before you proceed to Correct or Cancel any document that posted in Business Central, you need to identify the origin of the posted document, as the method of cancellation depends on the document type.   There are 2 types of documents that posted in Business Central. i.                      Journals – E.g., General Journals, Purchase Journals, Payment Journals, Sales Journals, Receipt Journals etc. ii.                    Documents – E.g., Purchase Invoice, Purchase Credit Memo, Sales Invoice, Sales Credit Memo etc.   A.       A.     C orrecting ...

Foreign Currency Revaluation in Microsoft Dynamics 365 Business Central

Microsoft Dynamics 365 Business Central (BC) allow users to account for foreign currency transactions. BC also able to translate the registered foreign currency amount into functional currency that setup in the entity using the conversion rates which setup in Exchange Table.   Due to the exchange rates fluctuate constantly, as a dollar worth in foreign currency today might not equivalent to the same foreign currency worth the next day. Hence, users are required to adjust the open documents that transact in foreign currency which include open invoices, credit memos, and advance payments. Once the open documents transacted in foreign currency is revalued, the gain and loss which calculate after comparing the closing rates at the period end will be posted to profit and loss as unrealised gain and loss, ensuring that the subledgers and general ledger can be reconciled.   This process can be done using Adjust Exchange Rate in BC, a batch job to adjust the exchange rates fo...

How to Consolidate Customer and Vendor Balances in Business Central

Understand that some customer of the company might be the vendor of the company too. There is a feature in Business Central that allows users to consolidate both customer and vendor balances without making unnecessary payment or receipts. Prerequisite Setup for Customer and Vendor Consolidation Page: Marketing Setup           1.        Setup a Business Relation Code for each Customers and Vendors.          2 .        Assign a number series under Contact Nos. A number will be pickup from the number series when there is a new Contact code created. To Link the Relation between Customer Card and Vendor Card 1.        Go to Customer Card, look for the customer that you need to link in Customer Contact. 2.        Confirm the Customer Name that you have selected. 3.        Link with the C...