Skip to main content

Notifications

Announcements

No record found.

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

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

Posted on by

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)

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,696 Super User 2024 Season 2 on at
    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

  • Tom1780 Profile Picture
    Tom1780 on at
    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.

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,696 Super User 2024 Season 2 on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans