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

Insert GLEntries when posting sales invoice

(0) Share

Report

Posted on by Oxia

Greetings,

I have added a custom field on Sales Invoice Subform (Alpha) , and a field on Sales & Receivable Setup Page (Beta), I need to use the value of Alpha and post it to Beta which happens to be a GLAccount when a sales invoice is posted.

I need your help to pinpoint the event to subscribe to and how to get "Rec.Entry no" and other auto generated fields when posting the sales invoice from AL , I would truly appreciate your generous help :)

Categories:

Dynamics 365 Business Central

All responses (4)

Answers (0)

Sort by

Suggested answer

IB-29041624-0 1,191 Moderator on at

Like (0)

Report
Copy link

Link copied!

Just so i understand.

You want to post an extra G/L Transaction for every posted salesinvoice line where you have a value in your customized field?

In that case you would need both a g/l account and a balancing g/l account.
Lars Lohndorf-Larsen Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

Codeunit 12 "Gen. Jnl.-Post Line" does most or all of the inserting of G/L entries, so I would look into that codeunit for useful events. For example OnAfterInsertGLEntry, like this:

codeunit 50100 GLEvent

{

trigger OnRun()

begin

end;

[EventSubscriber(ObjectType::Codeunit, Codeunit::"Gen. Jnl.-Post Line", 'OnAfterInsertGLEntry', '', false, false)]

local procedure MyProcedure(GLEntry: Record "G/L Entry")

begin

Message(format(GLEntry."Entry No.") + '\' + GLEntry."G/L Account No.");

end;

}
Suggested answer

Dallefeld 235 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

I suggested discussing with your partner and proceeding with caution.
Suggested answer

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

Like (1)

Report
Copy link

Link copied!

Hi, You can check the standard posting codes in base application to find the available events.

Or, try to use Event Recorder in BC.

Use shortcut key ALT + SHIFT + E to search event in VS Code.

But I still recommend the first method....

Hope this info helps.

Thanks.

ZHU