Summing up a total per GL account

(0) Share

Report

Posted on by Romryan

Hi All,

I need to add a field on Purchase Invoice Line such when I select a GL type option followed by G/L account on the line, the additional field should be populated by the sum / balance of the GL account.

Am using the code below in my new field

FieldClass = FlowField;
AutoFormatType = 1;
CalcFormula = Sum ("G/L Entry".Amount WHERE("G/L Account No." = FIELD("No.")));
// "G/L Account No." = FIELD(FILTER(Totaling)),
//"Business Unit Code" = FIELD("Business Unit Filter"),
//"Global Dimension 1 Code" = FIELD("Global Dimension 1 Filter"),
//"Global Dimension 2 Code" = FIELD("Global Dimension 2 Filter"),
//"Dimension Set ID" = FIELD("Dimension Set ID Filter")));

but am getting errors on the commented lines, is there something wrong or is there a better way to get the balance of the selected GL entry?.

All responses (2)

Answers (0)

Sort by

Romryan on at

Like (0)

Report
Copy link

Link copied!

any suggestions?.
Suggested answer

THE Italian Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

You have not specified

a. Version and build that you are using

b. Localized version (e.g. W1, CH, etc.)

c. If you are developing in AL or C/AL

d. A screenshot of the error(s)

Quite hard to answer this objectively, frankly speaking.

If you could provide all of these, this blog post might be answered by a more broad adience.