Skip to main content

Notifications

Announcements

No record found.

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

Remittance Advice Missing Data

Posted on by 761

I am having an issue with the remittance advice report 11383 Word format.  This was working and now it is not.  I can export the form and move it to another environment and it works, but it does not work in the customer environment.  What is happening is the report is missing the invoice information.  I have tried to delete the form and use the default Word format and it has the same result.

Any help or ideas are greatly appreciated.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Remittance Advice Missing Data

    Hello,

    Have you started over on a Payment Journal making a Payment with an Applies-to for an Invoice document and trying to print the remittance? I know Josh mentioned on his email so I want to make sure we have a clean slate.

    Thanks,

    Steve

  • tlhgolfer Profile Picture
    tlhgolfer 761 on at
    RE: Remittance Advice Missing Data

    Same result which is what I figured.  If I delete the format and I create a new one it comes up with this and if I choose yes it still is missing the application data.

    The Word layout does not comply with the current report design (for example, fields are missing or the report ID is wrong). The following errors were detected during the layout validation: /NavWordReportXmlPart/Gen_Journal_Line/CopyLoop/PageLoop/REMITTANCE_ADVICECaption has an invalid namespace xmlns:ns0='urn:microsoft-dynamics-nav/reports/ExportElecPayments - Word/11383/'. /NavWordReportXmlPart/Gen_Journal_Line/CopyLoop/PageLoop/CopyTxt has an invalid namespace xmlns:ns0='urn:microsoft-dynamics-nav/reports/ExportElecPayments - Word/11383/'. /NavWordReportXmlPart/Gen_Journal_Line/CopyLoop/PageLoop/PrintCompanyAddress/CompanyPicture has an invalid namespace xmlns:ns0='urn:microsoft-dynamics-nav/reports/ExportElecPayments - Word/11383/'. /NavWordReportXmlPart/Gen_Journal_Line/CopyLoop/PageLoop/PrintCompanyAddress/CompanyAddress_1_ has an invalid namespace xmlns:ns0='urn:microsoft-dynamics-nav/reports/Exp

    Do you want to run an automatic update?

    I did find some information on the forum about this error, but it did not help and I have submitted a support request and I am still waiting 3 days later to get a response.

    Reports are fun!

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Remittance Advice Missing Data

    Default-_2800_4_2900_.docx

    Here is the Word Layout I have.

    Thanks,

    Steve

  • tlhgolfer Profile Picture
    tlhgolfer 761 on at
    RE: Remittance Advice Missing Data

    Thank you for your response and I should have added to the description of the post that these are "Applied" vendor payments.  That was the first thing I checked as well because that seemed logical, but it looks like this for all remittances and it did not used to it just start doing this.

  • Suggested answer
    JAngle Profile Picture
    JAngle 33,159 on at
    RE: Remittance Advice Missing Data

    Please consider that the “Document No.” only appears if the payment journal line is applied to a document. What you are showing in the recent attachment as “not working” is just an unapplied payment amount. Trying applying a document to the payment line in your customers environment and run the remittance advice again.

  • tlhgolfer Profile Picture
    tlhgolfer 761 on at
    RE: Remittance Advice Missing Data

    Thank you for the response.  This format seems to be the RDLC and not word which is what I am using.

    AmCementError.docx

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Remittance Advice Missing Data

    Happy New Year,

    If the Report works in another database and not the one you are working in, maybe a fresh version might help. Other than setups, which it sounds like you are good, it seems like something is corrupted within the report Word Layout. I am attaching a new Customer Report Layout = WORD for Report ID 11383. Try this one.

    1. Report Selection - Purchase /Usage = Vendor Remittance = Report ID 11383 (see below)

    pastedimage1609874146552v1.png

    2. Report Layout Selection set to the Word Layout

    pastedimage1609874230394v2.png

    [View:/cfs-file/__key/communityserver-discussions-components-files/758/Default-_2800_2_2900_.zip]

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans