Small and medium business | Business Central, N...

How to post new added field in Sales Journal to Customer Ledger

(0) Share

Report

Posted on by MG-27040853-0

I have added 2 new fields in Sales Journal. But in Post those are not passing to Customer Ledger. I have created same fields in Customer Ledger too. How can I post the values of 2 new fields?

Categories:

Dynamics 365 Business Central

All responses (3)

Answers (0)

Sort by

Suggested answer

Gerardo Rentería Ga... 27,623 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi

You have to subscribe to this event.

And here pass the values from General Journal Line to Customer Ledger Entry.

Best Regards

Gerardo
Suggested answer

YUN ZHU 103,672 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!
Hi, hope the following helps.

tableextension 50119 MyExtension extends "Gen. Journal Line" { fields { field(50100; ZYTest; Text[100]) { Caption = 'ZY Test'; DataClassification = CustomerContent; } } } pageextension 50121 CustomerLedgerEntriesExt extends "Customer Ledger Entries" { layout { addafter("Document No.") { field(ZYTest; Rec.ZYTest) { ApplicationArea = All; } } } } tableextension 50121 CustLedgerEntryExt extends "Cust. Ledger Entry" { fields { field(50100; ZYTest; Text[100]) { Caption = 'ZY Test'; DataClassification = CustomerContent; } } } codeunit 50116 CcBccHandle { [EventSubscriber(ObjectType::Codeunit, Codeunit::"Gen. Jnl.-Post Line", OnAfterInitCustLedgEntry, '', false, false)] local procedure OnAfterInitCustLedgEntry(var CustLedgerEntry: Record "Cust. Ledger Entry"; GenJournalLine: Record "Gen. Journal Line"; var GLRegister: Record "G/L Register"); begin CustLedgerEntry.ZYTest := GenJournalLine.ZYTest; end; }

Test:

Thanks.

ZHU
Suggested answer

Dustin Wolf 30 on at

Like (0)

Report
Copy link

Link copied!

Hello

I would use the function CopyFromGenJnlLine from the Cust. Ledger Entry Table

Just create a subscriber, hooking on to this function and adding the code to add new fields here.

- Dustin Wolf
Accent Software