web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Flow Field calculation

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

Answered

Flow Field calculation

(0) Share

Report

Report

Posted on by Neil Phelan

161

Hi

I am looking to extend the purchase line with a flow field which will multiply the "qty to invoice" by the "Unit cost".

This is what I have so far.

field(50202; "lAmountToInvoice"; Decimal)

{

FieldClass = FlowField;

CalcFormula = sum("Purchase Line"."Unit Cost (LCY)" where("Document No." = field("Document No."), "Qty. to Invoice" = filter(> 0)));

}

This will just sum the unit cost but I want to multiply it by the qty to invoice.

Am I doing this the correct way is is there a better solution?

Thanks Neil.

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (0)

Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (0)

Report

Do you want to see the information only on line level or only a sum om head level?

Because you are using the Qty. to invoice it will be short lived data. So i am not convinced that a flow field is the best approach.

Maybe a function that calculate this on the fly when requested is better.

Was this reply helpful? Yes No
Neil Phelan 161 on at

Like (0)

Report

Inge

Thanks for your response. The primary reason for this request is that I want to add a running total to the purchase order screen when the qtytoinvoice is ticked.

I have it that it sums the unit cost but I want it to multiple by the qty that I want to invoice. The porpose is for the acocunts team to reconcile the invoice they are posting matches correctly.

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (1)

Report

But that information is already avalible if they click F7 on the purchase order / purchase invoice ?

Was this reply helpful? Yes No
Neil Phelan 161 on at

Like (0)

Report

Thanks Inge, it's pity they hadn't been shown that previosuly and I didn't know it.

Brilliant thanks.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 2,664

#2

YUN ZHU 960 Super User 2025 Season 2

#3

Jainam M. Kothari 773 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans