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 :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Electronic Reporting - missing payment advice, control report and attending note elements from payment model format

(0) ShareShare
ReportReport
Posted on by 77

Hi All,

Does anyone know how to add the Excel elements to an ER format that are used to generate payment advice, control report and attending note documents?

Here is the problem: I have a derived version of an existing payment model (ISO20022 credit transfer SE), but the elements used to generate the attached documents (payment advice, control report and attending note) are missing from the format designer and when I try to generate the payment these documents are not created, just the XML file for the credit transfer.

Here is an example of the original format (ISO20022 credit transfer (SE)) that includes the elements CoveringLetter, VendAttendingNote and VendControlReport

pastedimage1585342638332v1.png

And here is a screenshot of the list of all elements available in the drop down "Add":

pastedimage1585343045899v2.png

Unfortunately, my derived format doesn't have such elements:

pastedimage1585343158652v3.png

And the options Excel and PDF aren't available in the drop down "Add":

pastedimage1585343271619v4.png

Is there a way to enable/restore such elements in the format?

I also tried to add the templates/attachments to my format.

pastedimage1585345338808v7.png

And I can upload the files without problems

pastedimage1585345144397v6.png

But as soon as I complete the version change (Change status > Complete) the attachments are removed. In fact, if you switch to the designer before changing the status and then you click save you get warning messages like this one: File ERCoveringLetter.xlsx is linked to no file components and will be removed after changing status of configuration version.

Here are few info regarding my environment:

Application release: Microsoft Dynamics 365 for Finance and Operations (10.0.6)

- Platform release: Update30 (7.0.5407.41390)

Please let me know if you need any additional info.

Thanks in advance.

Michele

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hello Michele,

    Can you test creating another derived configuration from the Swedish ... 'SE' one?

    I tested this in PU33 and everything worked fine.

    That is, the covering letter, attending node and control report are all there.

    As you are on a much older version, you might have faced a bug that seems to be fixed in the latest version.

    Tip: Do you have a demo / test environment where you have 10.0.9 running? If so, can you test whether you can create a derived configuration there?

    Best regards,

    Ludwig

  • Michele Gozzi Profile Picture
    77 on at

    Thank you Ludwig!

    Unfortunately, I don't have an environment running 10.0.9 yet, but I've the update already planned for next week. Maybe I'll wait at this point.  

    Regards,

    Michele

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Great.

    Please test it in 10.0.9 and keep us updated here.

    Many thanks and all the best,

    Ludwig

  • Marianw Profile Picture
    on at

    Hi Michele,

    Thank you for using Dynamics 365 Finance Communities.

    Please let us know how you go with the 10.0.9 testing and if you have other questions or if your query has been answered by marking this thread as answered.

    For more information as well on Electronic Reporting Configurations, please refer to the article links below if you have not seen it yet.

    docs.microsoft.com/.../general-electronic-reporting

    Regards,

    Marian Wrice

    SR Support Engineer

    Dynamics 365 Finance

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hello Michele,

    Today, I just run into a problem with the SEPA payments.

    This must also affect you as the same problem is reported for SE file formats.

    The problem is that even if you see the attending note, control report and covering letter in the electronic report, they ultimately fail to be generated in the payment journal.

    There is a bug reported for his on LCS, which is scheduled for release in 10.0.12

    Issue 428354ER ISO20022 Credit transfer with Print attending note, Print control report and Print covering letter the system displays an error

    At the moment there seems not much what we can do except waiting for this fix being released.

    Best regards,

    Ludwig

  • Michele Gozzi Profile Picture
    77 on at

    Thank you for the tip!

    I finally created a new version of the report and I derived version 39.47.11 of ISO20022 Credit transfer (SE). For the moment I haven't experienced any problems with printing the attachments on our test environment, but it's true I haven't tested it with our production environment yet because we are updating it this weekend.

    Anyway with regards to the Issue 428354 you mentioned, I just need to install the newer versions of the base report and payment model and then rebase my configuration, right?

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi Michele,

    I think the rebase should do the job.

    Yet, test things carefully because - as I said - there might be some 'hidden' issues you run into just as I did over the last couple of days.

    All the best,

    Ludwig

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 > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 551 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 450 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 278 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans