Skip to main content

Notifications

Announcements

No record found.

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

Remittance Advice Error

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
 
 
  • Judy Profile Picture
    Judy Microsoft Employee on at
    Remittance Advice Error
    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
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,647 Super User 2024 Season 2 on at
    Remittance Advice Error
    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

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!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans