Microsoft Dynamics 365 | Integration, Dataverse...

Calculate Total of Work Order Products having Bonus Applicable equal to True

(0) Share

Report

Posted on by Vedvati

Hi,

I have following requirement from client and I am unable to achieve the same. Please suggest

On Work Order form,

When we add Work Order Products, it shows the Total value in Total Line Item Amount field.

Now I have a requirement where I have to show the Total of Work Order Products where only Bonus Applicable equals to True condition should be satisfied.

Regards,

Vedvati

All responses (3)

Answers (0)

Suggested answer

Leco Lv on at

Like (0)

Report

RE: Calculate Total of Work Order Products having Bonus Applicable equal to True

Hi partner,

Have you hidden the field? After I tried to hide the field, I got the result in the image below in the report.
Vedvati 70 on at

Like (0)

Report

RE: Calculate Total of Work Order Products having Bonus Applicable equal to True

Hello,

I had already used Rollup Field, but the problem I am facing is I have to hide this field on form so I should have something which will calculate this Total OnSave.

And I have to use this field in SSRS Report.
Suggested answer

Bipin D365 28,964 Super User 2024 Season 1 on at

Like (0)

Report

RE: Calculate Total of Work Order Products having Bonus Applicable equal to True

Hi,

You want total to be displayed on work order form , if yes then you can use rollup field

learn.microsoft.com/.../define-rollup-fields