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 Community member

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

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Gerardo Rentería Ga... 25,213 Most Valuable Professional on at

Like (0)

Report

Hi

You have to subscribe to this event.

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

Best Regards

Gerardo

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,379 Super User 2025 Season 2 on at

Like (0)

Report
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

Was this reply helpful? Yes No
Suggested answer

Dustin Wolf 30 on at

Like (0)

Report

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

Was this reply helpful? Yes No