web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Payment advice using E...
Microsoft Dynamics AX (Archived)

Payment advice using Electronic Reporting

(0) ShareShare
ReportReport
Posted on by Lan Ng

Hi everyone

I would like to find out the D365 standard payment (remittance) advice standard template and how to save it as an attachment to the payment file I creating using ER but struggle to find the manual/instruction.

Could you please help advising me where can I get such guidance or how can I do that.

Thank you very much.

Lan

*This post is locked for comments

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

    Hi Lan Ng,

    Do you refer to customer or vendor payments?

    Why do you want to save a payment advice as attachment to the payment file?

    The payment advice is a document that is typcially send to your customer/vendor whereas the payment file is going to your bank.

    Would be great if you could elaborate on that.

    Many thanks,

    Ludwig

  • Lan Ng Profile Picture
    Lan Ng on at

    Hi Ludwig

    My apology - I need vendor payment advice report. It is a business requirement that every payment needs to have payment file, payment control report and payment advice report. It should be generated automatically.

    I am building payment file and payment report using GER. I saw that the BACS UK does have 3 files as I want and I want to use the same format of the reports from BACS UK. The environment I have access to was not configured correctly so I could not see the attachment in the BACS UK for remittance advice.

    In the article below it has the part to import the world document template - however I could not find the standard template for vendor remittance advice.

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

    If you know any other source - could you please let me know.

    Thank you

    Lan

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Lan,

    I have not worked with BACS in D365 but with other comparable payment formats and what D365 does is generateing a zip file that includes the payment file and the payment advices. You should thus be able to save the remittance advices and send them to your vendors. Doesn't this work correctly for you?

    What files are generated when you make the payment via the generate payment button?

    Can you share that?

    Best regards,

    Ludwig

  • Lan Ng Profile Picture
    Lan Ng on at

    Hi Ludwig

    In order to get the payment reports along with the payment file, in D365 we have 2 choices. Using the standard available format like we have been doing in AX 2012. Other option is building the template yourself using GER.

    I am using 2nd option.

    My problem at the moment is due to my environment setup - I could not see the remittance advice from the BACSUK template therefore I could not use BACS UK as the base to modify it.

    Another approach is I am building the template from scratch and currently run into 2 issues:

    1/ I could not have the excel format in option to import external template

    2/ I got an error message when trying to import the Microsoft sample template in from the article I mentioned above "The attached template file is not found in Azure storage"

    That is why I stuck - could not know how to import the template to proceed further with mapping the data.

    I used another approach to create reports but it is not in excel format - it is in txt or csv instead and could not get any data for addresses.

    Regards

    Lan

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Lan,

    There seem to be a couple of issues with the payment advice for BACS. I found a couple of Hotfixes on LCS. Have you already checked them? Please see: fix.lcs.dynamics.com/.../Results;dm=0&v=1_2_8&i=2_1_3_4&ct=1_3_5_4_2_6&ft=1_2_3&cu=&pi=&pm=&pc=&rd=&d=&envId=&permission=&x=0&y=0

    Best regards,

    Ludwig

  • Lan Ng Profile Picture
    Lan Ng on at

    Hi Ludwig

    Thank you for your information. I found out the source of the issue. It is the sequence of creating element of the payment file. Using the import functionality - following this instruction on LSC:  the ER Create a configuration for reports in OPENXML format task guide (part of the 7.5.4.3 Acquire/Develop IT service/solution components (10677) business process).

    My next target is to find out how can I export the XML file I created to use as a template :)

    I don't know if we can do it in D365 GER or not.

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans