Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

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

Remittance Advice not showing payment date

(0) ShareShare
ReportReport
Posted on by 5

When we produce remittance advice from a payment it creates a PDF that is send in an email. For some reason the payment date is not shown. Is there a way to alter the template used to produce this PDF to include that? 

  • Wildax Profile Picture
    5 on at
    RE: Remittance Advice not showing payment date

    Thanks for the suggestion. i have tried this but now find that the remittance advice will not work at all!!

    I created a word layout for thie report 400 (would not let me for 399) then i uploaded a word file for the email. i now get this error message - 

    The Remittance Advice - Entries report does not have a DataItem that uses the table (Table 81 Gen. Journal Line) specified in the function SetTableView.

  • KasparsSemjonovs Profile Picture
    4,117 Super User 2025 Season 1 on at
    RE: Remittance Advice not showing payment date

    Report 399 or 400 should be the correct ones. currently You are using RDLC layout, and it could be that these don't have a prepared Word layout. 
    To know for sure - try to Change RDLC to Word for one of them and try to Print - You should be quickly able to understand which of those 2 reports is the one You need. 

    Then Press on Custom Layouts, create a New one and insert Word layout. Then Export the Layout - adjust it as You need (for this You might need to google regarding Custom Word Layouts - some initial info is here: Create and Modify Custom Layouts for Reports and Documents | Microsoft Docs - OnlineHelp (to-increase.com) 

  • Suggested answer
    Akash Shukla Profile Picture
    335 on at
    RE: Remittance Advice not showing payment date

    You are viewing the wrong details. When you click on generate vendor remittance at the time you view this table and check the ID which is showing under table option.

    pastedimage1681912710648v1.png

    Alternatively you can check on the vendor card if any remittance advice tagged on that. Please see below images:

    pastedimage1681912974495v2.png

    pastedimage1681912983284v3.png

  • Wildax Profile Picture
    5 on at
    RE: Remittance Advice not showing payment date

    pastedimage1681912431599v1.jpeg

    these are the only 2 reports that have the word remittance in them! 

  • Wildax Profile Picture
    5 on at
    RE: Remittance Advice not showing payment date

    pastedimage1681912332485v1.jpeg

    This is what we see for the detail of this report - not sure i am looking correctly

  • Akash Shukla Profile Picture
    335 on at
    RE: Remittance Advice not showing payment date

    As you mentioned earlier, the report ID is 2487, but we couldn't find this report ID in any of the Business Central Localizations. Could you please double-check the report ID.

  • Suggested answer
    Govinda Kumar Profile Picture
    2,211 Moderator on at
    RE: Remittance Advice not showing payment date

    Hi Wildax,

    To display the payment date in your report you';; need some customization. you need to modify the report layout and data item, as well as the main data set in your report

    checkout this blog it might help you more yzhums.com/.../

  • KasparsSemjonovs Profile Picture
    4,117 Super User 2025 Season 1 on at
    RE: Remittance Advice not showing payment date

    Try searching by name, might be You are mixing the ID with Page ID.

  • Wildax Profile Picture
    5 on at
    RE: Remittance Advice not showing payment date

    thanks for the fast reply. I've looked at this, it shows the report id as 2487, however in the Report Layout Selection this report number does not appear!

  • Suggested answer
    Akash Shukla Profile Picture
    335 on at
    RE: Remittance Advice not showing payment date

    Hi,

    You can export the remittance report from Report Layout Selection and then you can modify the report as per your requirement.

    pastedimage1681910583873v1.png

    I believe there are some additional fields are there in the report which is hide, and you can add them to make visible, or can add new fields by taking the help of Developer.

    I hope this will helpful to you .

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

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

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,238 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,923 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans