G/L Resister No.

(3) 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;
}

All responses (4)

Answers (1)

Suggested answer

Khushbu Rajvi. 16,784 Super User 2025 Season 1 on at

Like (1)

Report

G/L Resister No.

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
Raj Borad 1,140 on at

Like (0)

Report

G/L Resister No.

Hi @Rajiv Sewsarran,

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

Rajiv Sewsarran 51 on at

Like (1)

Report

G/L Resister No.

Hi Mohana,

This works! thanks!
Verified answer

Mohana Yadav 60,232 Super User 2025 Season 1 on at

Like (2)

Report

G/L Resister No.

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.")));

}