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

error.jpg

I have the same question (0)

All responses (6)

Answers (0)

Jainam M. Kothari 15,627 Super User 2025 Season 2 on at

Like (1)

Report

May the Technical Expert can answer in a better way.

Was this reply helpful? Yes No
Suggested answer

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

Like (1)

Report

Which type of error?

Was this reply helpful? Yes No
BCUSER2024 213 on at

Like (0)

Report

hi

error also attached

Was this reply helpful? Yes No
BCUSER2024 213 on at

Like (0)

Report

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,527 Super User 2025 Season 2 on at

Like (1)

Report

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

i tried this also but still not getting the reulst

errorrs.jpg

Was this reply helpful? Yes No