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

Flow field issue

(2) Share

Report

Posted on by BCUSER2024

213

Hello team,

in the below code am trying to get the total of line amount in both cases means GL account no = 1410301 and type = item (if type = item exits)then take the total of both otherwise if item is not present then total of only this gl acocunt.

Only facing issue in this line- "No." = CONST('1410301')| "Type" = CONST(Item)),

if i add one condition its working but i want in if it comes in both condition means if sum if gl code 1410301 and type = items comes

but am getting error. is anything i did wrong .pls suggest

field(60012; "Total Job Project"; decimal)
        {
            FieldClass = FlowField;
            CalcFormula = - Sum("Job Ledger Entry"."Line Amount (LCY)" WHERE("Job No." = FIELD("No."),
                                                                             "Entry Type" = CONST(Sale),
                                                                             ("No." = CONST('1410301')| "Type" = CONST(Item)),
                                                                             "Posting Date" = FIELD("Posting Date Filter"),
                                                                             "Shortcut Dimension 3 Code" = const('PROJECTS')));
        }
 
 
 
 

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Jainam M. Kothari 15,959 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

May the Technical Expert can answer in a better way.

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 22,342 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Which type of error?

Was this reply helpful? Yes No
BCUSER2024 213 on at

Like (0)

Report
Copy link

Link copied!

hi

error also attached

Was this reply helpful? Yes No
BCUSER2024 213 on at

Like (0)

Report
Copy link

Link copied!

pls let me know the way am approaching is right or i missed anything

Was this reply helpful? Yes No
Suggested answer

Ramesh Kumar 7,549 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

logical operator | within the CalcFormula. The syntax you're using in the condition ("No." = CONST('1410301') | "Type" = CONST(Item)) is not valid in AL code for filtering the records based on two conditions combined with an OR operation. The | operator doesn't work directly inside the WHERE clause in this manner.

ou need to specify multiple conditions separately for your Sum expression. Specifically, to sum amounts when either the GL account number ("No." = CONST('1410301')) or the Type ("Type" = CONST(Item)) condition is met, you should rewrite the condition like this:

field(60012; "Total Job Project"; decimal)
{
FieldClass = FlowField;
CalcFormula = -Sum("Job Ledger Entry"."Line Amount (LCY)" WHERE(
"Job No." = FIELD("No."),
"Entry Type" = CONST(Sale),
"Posting Date" = FIELD("Posting Date Filter"),
"Shortcut Dimension 3 Code" = CONST('PROJECTS'),
("No." = CONST('1410301') OR "Type" = CONST(Item))
));
}

If this was helpful, please check the "Does this answer your question?" box and mark it as verified.

Was this reply helpful? Yes No
BCUSER2024 213 on at

Like (0)

Report
Copy link

Link copied!

i tried this also but still not getting the reulst

Was this reply helpful? Yes No