Word Template Formatting for Multiple Lines of Businesses
-
Word Template Formatting for Multiple Lines of Businesses
Posted by DSC Communities on August 22, 2019 at 5:23 pm-
John Ellis
MemberAugust 22, 2019 at 5:23 PM
Hello:Is “Blank” the only type of Sales Order Processing invoice that can print to Word template format?Ā I noticed that, if you choose “Other”, GP does not seem to let you print an aesthetically pleasing looking document in either Template or Standard format.
Secondly, with being tied down to that one Blank format, is there any way of modifying the invoice for multiple lines of business?
Let me see if can explain.Ā One set of customers needs to have the sales invoice displaying one way, while the other sets of customers need to have the sales invoice displaying differently.Ā Ā
Thanks!
John
——————————
John Ellis
The Dynamics Bulldog
S2 Technology
—————————— -
Hi John,
Blank is not the only choice, SOP Other…, SOP Short… & SOP Long…Ā are all available.Ā I used to use the other formats to do the kind of stuff you are talking about, but I got tired of it quickly.Ā While some people think GP Report Writer is the best thing in the world (David Musgrave), I personally am not a fan of Report.Ā Ā I was once trying to output a paragraph of text to a report and I was restricted to lines of 80 characters.Ā It drove me nuts!Ā I felt like I should get out my punch cards to make the report š
Because of this, like many others, I transitioned away from Report Writer to a third party report solution (Crystal Reports Viewer by Flexiable Solutions or Forms Printer by Accountable Softer to name two) and my life is SO much easier.Ā I now have almost all of my reports as SSRS reports and things are SO much easier.Ā Plus you can save the RDL files from SSRS report in a source code control system to keep track of changes.
With SSRS or Crystal Reports, you can dynamically change the way the report looks based on the Customer ID quite easily.Ā Plus, your users won’t have to remember to change the Report’s Format EVERY time they print.Ā They won’t have to think…Ā “For this customer, do I want the Blank Paper, Short Form, Long Form, or Other Form ?”Ā The report can auto-magically format itself as needed.Ā Ā I’d drive the report with a SQL Stored Procedure and create a new table that stores the Customer #Ā and a format code.Ā Return the format code to your report and use it to turn on/off fields on your report as needed.Ā You could have multiple format codes for each report format type.Ā Only add the customer’s # along with the format code they need.Ā If the customer isn’t in the table, use the default formatting.
I hope this make sense.Ā Give me a yell if you have any questions!
——————————
John Arnold
Senior Software Engineer
US Digital
Vancouver WA
——————————
——————————————- -
John Ellis
MemberAugust 22, 2019 at 6:06 PM
Hi John:Thank you, for the quick response!Ā
Yes, of course, there are three other formats available in SOP.Ā But, if you look in GP’s Report Template Configuration window, “Blank” appears to be the only format available for Word Templates.Ā That’s not good, for several reasons, not the least of which being that I cannot modify “Blank”.Ā That format is already being used for other lines of business.Ā Not only that, when any of the other three formats are chosen, the printing (in layman’s terms) does not look good.
Sure, there are other products out there.Ā But, they’re not feasible to review for this project at this time.
John
——————————
John Ellis
The Dynamics Bulldog
S2 Technology
——————————
——————————————- -
Hi John,
You can have multiple Word templates for Blank, and assign them by Customer ID. Also the other formats are available to be customized so if you only need 3-4 formats for your lines of business, you can modify the Word templates to accommodate. I can’t argue with John that SSRS and Crystal are more flexible, and would recommend an ISV add-on to make the reports more “integrated” to the GP windows. But I have been able to customize the RW to Word features for a lot of clients. In fact, I have a light manufacturing VAR that has over 30 different Word templates, specific to each customer.
——————————
Mark Wiley
Dynamics Credentialed Professional
Senior Solutions Architect
GraVoc
Ohio Office
——————————
——————————————- -
John Ellis
MemberAugust 23, 2019 at 9:39 AM
Hi Mark:Thank you, Mark!Ā This is exactly what I’m looking for!
Years ago, I worked quite a bit with GP’s Word Templates.Ā But, I never used multiple templates for the one Blank format.Ā Since the Blank format was already modified in Report Writer by the client elsewhere, in what window would I go to to fashion a Word template to work with “another” Blank format?
For that matter, if I want to “tie” Word Templates to any of the other three formats, what window would I use to do so?
Thanks, Mark!
John
——————————
John Ellis
The Dynamics Bulldog
S2 Technology
——————————
——————————————- -
Hi John,
You can copy the Blank Word Template format to the Short, Long or Other format.Ā Then you need to make an xml file for the format you are going to use, like the Short form, for example.Ā Then you have to delete the source that has Blank, and add the source for the Short form.Ā From there you can make changes as needed to the new Word Template.Ā Ā
Keep in mind that the “Email” button at the top of the SOP Entry window is only available on the Blank form (for some stupid reason), but you can click on Print (or go to Sales Batches and print from there) and choose to email from there if you are using one of the other formats.
Be sure to make lots of copies so you can revert to a previous version if you need to!
Val Sikora
——————————
Valerie Sikora
Senior Developer
LBMC Technology Solutions
Brentwood TN
——————————
——————————————- -
John Ellis
MemberAugust 29, 2019 at 5:02 PM
Hi Valerie:I just reviewed the possibility of e-mailing from the batch entry window by clicking the Print button and choosing one of the other formats besides Blank.
Although the “Help” file for this window says that the e-mailing by printing from the Print Sales Documents window for batch entry only works for the Blank format, a colleague of mine did some testing and found that it is not just for the Blank format.Ā So, she confirmed what you stated.Ā
Thank you, so much!!!
John
——————————
John Ellis
The Dynamics Bulldog
S2 Technology
——————————
——————————————- -
Tiffany Ziegler
MemberAugust 23, 2019 at 1:10 PM
I”m not sure if this answers your question but we use a modified sales invoice (through RM not SOP). We have one customer who gets one version and all other customers get another version. Both are modified. We then assign the template that we want to go to each customer. When we print the invoice out of GP, it prints the corresponding invoice (we don’t have to tell it which template to use).Again, I’m a very beginning user of templates, but I do know we use this funcationality.
——————————
Tiffany Ziegler
Vice President & Controller
Velcor Leasing Corporation
Madison WI
——————————
——————————————- -
John Ellis
MemberAugust 23, 2019 at 2:56 PM
Hi Tiffany:When you mention how both are modified, do you mean modified in Report Writer prior to modifying them in Word?
In Report Writer, you can modify only one format.Ā You can’t have two modified reports for the same format.Ā At least, that’s correct if you have one shared reports dictionary.
John
——————————
John Ellis
The Dynamics Bulldog
S2 Technology
——————————
——————————————- -
Tiffany Ziegler
MemberAugust 26, 2019 at 9:36 AM
John – Sorry, two modified templates – as in modified in Word. I believe that our default invoice is a Report Writer modified invoice. We then pull that into the Word Templates configurator to create multiple word versions of this report writer invoice – i.e. different wording on the invoice. One customer has their invoice auto paid via ACH so their invoice has a notation at the bottom not to send a check, etc.Both version appear in the Word Template ?Maintenance window and can be assigned accordingly. See screen shot below…Once you highlight one, you can click the Assign button to assign to certain customer classes, or customers. Hope this helps!
——————————
Tiffany Ziegler
Vice President & Controller
Velcor Leasing Corporation
Madison WI
——————————
——————————————- -
John Ellis
MemberAugust 28, 2019 at 2:38 PM
Thank you, Tiffany!Yes, this sounds like it will work perfectly!
John
——————————
John Ellis
The Dynamics Bulldog
S2 Technology
——————————
——————————————-
DSC Communities replied 6 years ago 1 Member · 0 Replies -
-
0 Replies
Sorry, there were no replies found.
The discussion ‘Word Template Formatting for Multiple Lines of Businesses’ is closed to new replies.