web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

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

Remittance Advice custom report layout - word layout 400

(0) ShareShare
ReportReport
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. 

I have the same question (0)
  • Suggested answer
    JAngle Profile Picture
    113 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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2,678 Super User 2025 Season 2

#2
Sumit Singh Profile Picture

Sumit Singh 2,635

#3
Jeffrey Bulanadi Profile Picture

Jeffrey Bulanadi 2,210

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans