Skip to main content

Notifications

Microsoft Dynamics NAV forum
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,155 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

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,522 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,441 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans