Skip to main content

Notifications

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

Remittance Advice custom report layout - word layout 400

Posted on by 5

HI everyone,

Having a bit of trouble trying to get the total amount paid showing on a remittance advice

W are currently using report layout 400 with the following fields. Apologies if its too blurry

snip.PNG

I am using 'Amount_VendLedgEntry' however the total is not showing, only the amount of one invoice is. 

I am using the 'LAmountWDiscCur' as amount paid per invoice. 

  • Suggested answer
    JAngle Profile Picture
    JAngle 33,159 on at
    RE: Remittance Advice custom report layout - word layout 400

    I would check how the total is shown on the RDLC layout. If it is using the in built Sum() function then you will need a customisation on the report. A draw back of word layouts being you cannot aggregate data in the layout. You would need to create a total and pass it into the report schema for selection

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans