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

BC Service Quote and Invoice (word reports) not calculating total line amounts.

(0) Share

Report

Posted on by Tom1780

It looks that on service quote and invoice (word report) - BC is not calculating totals.

for example if there are 4 different line items - total amount at the bottom shows only amount from first line.

Word form is prepared properly, works elsewhere but not on service quotes and invoices (word version). On RDLC its fine.

Any experience?

(Report ID: 5911)

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

YUN ZHU 92,429 Super User 2025 Season 2 on at

Like (0)

Report

RE: BC Service Quote and Invoice (word reports) not calculating total line amounts.

Hi, please note that these fields are not directly used in RDLC.
For example,

Because formulas are supported in RDLC layout but not in Word, Microsoft does not guarantee that its standard DataItem can be used in Word unless there is a standard Word layout.

If you insist that this is a Microsoft problem, you can submit a Service Request to Microsoft.

Hopefully other experts can give you better advice.

Thanks

ZHU

Was this reply helpful? Yes No
Tom1780 on at

Like (0)

Report

RE: BC Service Quote and Invoice (word reports) not calculating total line amounts.

Yes standard is RDLC but user can create copy in word format.

Now problem is that in word there are XML fields "TotalAmt" "TotalGrossAMt" which are not diplaying what they should.

they should show totals of all lines but it shows only 1st line. This seems to be issue with Service Quote and Service Invoice - on sales and purchase reports all works fine.

Seems that MS needs to fix default reports? Altenrative is that we create new reports but this is not good long term.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 92,429 Super User 2025 Season 2 on at

Like (0)

Report

RE: BC Service Quote and Invoice (word reports) not calculating total line amounts.

Hi, I checked the 5911 report of the standard environment, it only has the RDLC layout. It seems that this Word layout is customized by you, please contact the developer to check this problem.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No