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

from which event we can insert the vendor ledger entries

(0) Share

Report

Posted on by Sarath9999

Hi All,

I am posting the general journal line with two lines one with account type customer and bankaccount for the customer line i am giving the apply entries and posting it from gen journal line, in the vendor ledger entries there is a custom field of type enum it has to populate in the vendor leger entries, but it is not populating as i think can anyone help me, i am attaching my code for your reference.

Thanks & Regards

Satish

All responses (3)

Answers (0)

Suggested answer

YUN ZHU 75,848 Super User 2024 Season 2 on at

Like (0)

Report

RE: from which event we can insert the vendor ledger entries

Hi, I understand, I think the simpler way is to first add this field in the general journal line, when you set to apply entries, fill in the value, and then use the event I shared to solve the problem. This field may not be displayed on the General Journal.

Hope this can give you some hints.

Thanks.

ZHU
Sarath9999 50 on at

Like (0)

Report

RE: from which event we can insert the vendor ledger entries

Hi Yun ZHU,

Thanks, for telling me that method, but I can't use that event because in the general journal line there is no custom field of that one, in the customer ledger entries and vendor ledger entries only the custom field is there, we are selecting from the customer ledger entries and vendor ledger entries while populating it as if the bal account type is bank account and g/l account then in the customer ledger entries and vendor ledger entries it has to populate, for now if the customer have set to apply entries, then in the customer ledger entries and vendor ledger entries it has to populate the custom field.

Thanks & Regards,

Satish.
Suggested answer

YUN ZHU 75,848 Super User 2024 Season 2 on at

Like (0)

Report
RE: from which event we can insert the vendor ledger entries

Hi, please try to use OnAfterCopyVendLedgerEntryFromGenJnlLine event.

For example,

Test code:

tableextension 50111 MyExtension extends "Gen. Journal Line" { fields { field(50100; ZYTest; Text[50]) { DataClassification = CustomerContent; } } } tableextension 50112 MyExtension2 extends "Vendor Ledger Entry" { fields { field(50100; ZYTest; Text[50]) { DataClassification = CustomerContent; } } } pageextension 50111 MyExtension extends "General Journal" { layout { addafter("Account No.") { field(ZYTest; Rec.ZYTest) { ApplicationArea = All; } } } } pageextension 50112 MyExtension2 extends "Vendor Ledger Entries" { layout { addafter("Vendor Name") { field(ZYTest; Rec.ZYTest) { ApplicationArea = All; } } } } codeunit 50111 MyCodeunit { [EventSubscriber(ObjectType::Table, Database::"Vendor Ledger Entry", OnAfterCopyVendLedgerEntryFromGenJnlLine, '', false, false)] local procedure OnAfterCopyVendLedgerEntryFromGenJnlLine(var VendorLedgerEntry: Record "Vendor Ledger Entry"; GenJournalLine: Record "Gen. Journal Line"); begin VendorLedgerEntry.ZYTest := GenJournalLine.ZYTest; end; }

Hope this helps.

Thanks.

ZHU