web
You’re offline. This is a read only version of the page.
close
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 Error

(1) ShareShare
ReportReport
Posted on by
Hello all, 
 
I hope that this question finds you well.
 
I am trying to create a remittance advice from the payment journal in Business Central UK version (V23)  and I am getting the following message every time I try and send the report to any vendor that we have paid:
 
 
I have set up a default word template using (i assume is the correct xml):
 
 
But I am not sure if this .xml is looking at the right table (81) in order to satisfy the error? I assume that the /DataItem/ is the actual report (word document) that my bespoke remittance is to be based on? I just don't know how I can get the report to pickup/refer/point to the table (Table 81 Gen.Journal Line) that the error is pointing to.
 
I have managed to get the process to work with a bespoke email body and .pdf fine when I try to generate and send a remittance form from the Vendor Ledger entries page, no problem, but when i try and send from the Payment Journal, the above error is all I get. The requirement is to send these remittances in bilk from the payment journal page instead.
 
I am not sure how to resolve this error or where to look, but brief step by step advice on how to resolve the error message above would be greatly appreciated.
 
I hope that someone can advise how to get past this error and help me deliver this.
 
Many thanks in advance
 
 
I have the same question (0)
  • Suggested answer
    YUN ZHU Profile Picture
    95,329 Super User 2025 Season 2 on at
    Hi, the dataitem of "Remittance Advice - Entries" mentioned in the error message is table 25 "Vendor Ledger Entry".
     
    But the Word layout you open below is not "Remittance Advice - Entries", but "Remittance Advice - Journal". The dataitem of this report is table 81 "Gen. Journal Line".
     
    Hope this can give you some hints.
    Thanks.
    ZHU
  • Judy Profile Picture
    Microsoft Employee on at
    Hi,
     
    Can you check your configuration to select report 399 for vendor remittance from journal since this was the correct report.
    Uploaded Image
     
    Best Regards,
    Judy

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,229

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,867 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,153 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans