G/L Resister No.

(4) Share

Report

Posted on by Rajiv Sewsarran

Hi All,

I would like to capture the G/L Register No. from the Posted General Journal, on the General Ledger Entries Page.

I've done a few things so far but nothing seems to work

this is what I've done.

Any assistance would be greatly appreciated.

Tableextension - G/L Entry

 
        field(50117; "G/L Register No."; Integer)
        {
            Caption = 'G/L Register No.';
        }
 
and this codeunit 
codeunit 50101 GLEntryTransferHandler
{
    [EventSubscriber(ObjectType::Table, Database::"G/L Entry", 'OnAfterInsertEvent', '', false, false)]
    local procedure OnAfterInsertGLEntry(var Rec: Record "G/L Entry")
    var
        PostedGenJnlLine: Record "Posted Gen. Journal Line";
    begin
        // Match by Document No.
        PostedGenJnlLine.SetRange("Document No.", Rec."Document No.");
        if PostedGenJnlLine.FindFirst() then begin
            if Rec."G/L Register No." <> PostedGenJnlLine."G/L Register No." then begin
                Rec."G/L Register No." := PostedGenJnlLine."G/L Register No.";
                Rec.Modify();
            end;
        end else begin
        end;
    end;
}

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Mohana Yadav 61,005 Super User 2025 Season 2 on at

Like (3)

Report

Create it as a FlowField like this

field(71102; "G/L Register No."; Integer)

{

Caption = 'G/L Register No.';

FieldClass = FlowField;

Editable = false;

CalcFormula = Lookup("Posted Gen. Journal Line"."G/L Register No." WHERE("Document No." = FIELD("Document No.")));

}

Was this reply helpful? Yes No
Suggested answer

Rajiv Sewsarran 55 on at

Like (2)

Report

Hi Mohana,

This works! thanks!

Was this reply helpful? Yes No
Raj Borad 1,428 on at

Like (1)

Report

Hi @Rajiv Sewsarran,

If it works, Please Mark Mohana's reply as verified answer, so everyone in the community gets updated.

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,838 Super User 2025 Season 2 on at

Like (2)

Report

Adding for more details: https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-flowfields

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-creating-flowfields-and-flowfilters

Was this reply helpful? Yes No