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
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.
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
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
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
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
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (