Dynamics 365 general forum

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

Categories:

Customization / Solutions / SDK and API

Work Order

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,962 Moderator 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