You’re offline. This is a read only version of the page.
5
Good Morning folks,
I know this is probably a very old question but I have looked around the internet and cannot figure out exactly where the assignment is done. We are attempting to automate our customer statements by e-mail but are having difficulty getting the custom word template to show up. The custom word template has been created under 'RM Statement On Blank Paper' as the Form 'On Blank Paper' is used for e-mailing statements; however, we cannot figure out exactly how we get this format to e-mail out.
Is it something that has to be setup on the Message ID? I've looked at numerous articles online but I can never quite see how we assign our custom form; unless I have modified the wrong form.
Any help would be appreciated!
Cheers,
Steven
Hello Steven,
No, we cannot change this. It is driven by code. You would need to create a customization to accomplish this.
Thank you!
Brandon Jarrett | Microsoft Support Engineer
Thanks Brandon,
That did the trick; turns out in my modifications I accidentally deleted the Header bookmark so we are in business 100%!
This is an aside question but related; you don't by chance know if it is possible to adjust the automated naming of the attachments generated to the emails do you?
By default Statements are rmStmt_CUSTID_00.docx or .pdf;
It would nice to be able to issue something along the lines of:
Company Name_-Statement-CUSTID-YYYYMMDD.docx or .pdf
Cheers,
Steven
Hello Steven,
Glad to hear for the most part the information worked.
With the page numbers, these can be a real pain to correct. When i run into this issue, i usually just start over with the core templates. If you would like to try and fix it, you can review the Blog below.
community.dynamics.com/.../syntax-error-where-page-number-should-be-in-word-templates-1472758070
If that does not work, you would need to look at the Equation and make corrections if this is incorrect. Below is a screenshot of a correct Page Number Equation on a template.
If that does not work, i recommend starting over with the core template.
I hope this helps!
Thank you!
Brandon Jarrett | Microsoft Support Engineer
Thanks Brandon,
You are a gentleman and a scholar. I'm almost there now; the report is loading and printing with a few errors.
90% of my problem was editing the compatability mode and the other 10% was failing to set compatability mode.
On the error side: the three fields that appear in the word header of the Original RM Statement all have issues.
Pages: shows up with !Syntax Error;
Date: shows up with #######;
Account: shows up with ######;
I have reloaded the original and tried copying and pasting these across to no avail. Your previous article describes the xml and creating a custom report in ReportWriter but as I am not adding any fields and I am not removing the account number or date from the header, I don't understand why these would no longer work.
Any ideas?
Cheers,
Steven
Hello Steve,
First, the Modified Template has to have the Modified Reports xml on it. If not, then the Template wont print. Once the xml is added to the Template , you bring this in and assign security to it in the Template Maintenance window.
Administration >> Reports >> Template Maintenance
In the Template Maintenance window, you would select the following:
As long as you have no issues with the layout, the security is set to the modified report and template, it should email with this template.
Below is an article that has great steps to do this. Its not a Microsoft article but the steps are correct.
https://www.erpsoftwareblog.com/2016/02/creating-word-template-microsoft-dynamics-gp/
I hope this helps!
Brandon Jarrett | Microsoft Support Engineer
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...
290,900
Super User 2024 Season 2
#2
Martin Dráb
229,275
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (