Developing for Dynamics GP

by David Musgrave (Perth, WA, Australia) and the Microsoft Dynamics GP Developer Support Team (Fargo, ND, USA)

Making Word Template Documents Read Only When Sent To Customers

Making Word Template Documents Read Only When Sent To Customers

Rate This
  • Comments 8

Patrick Roth - Click for blog homepageI was recently talking with one of our fine Distribution Support engineers discussing Word Template issues.

One topic that came up was their team has apparently been asked quite a number of times by customers: If we send out our invoices as Word documents, our customers can edit them to be for less money and then not pay us the full amount.

Interesting theory - the part about the customer now owing your company less money anyway.  In Dynamics GP, the invoice will still be entered for $100 and if the customer only sends you a payment for $80- when you run statements they'll still get one for the difference.

However as we discussed it, it seemed to me that Word DOES allow you to password protect files and therefore make them read-only if you desired.

So after discussing why this would work and how to do this, the engineer went out to test the theory.  And it did work just fine.

Below are the steps that will allow documents created with a Word Template to essentially be read only.

You can set the templates to a read only status by using functionality in Microsoft Word to set protection on the Word Template.

In the example below, we just used a default original template as the base but this would apply to any template that is created.

  1. In Template Maintenance select the default Original Template and click New.
     
  2. Create a new Template based off the original and give it a name.
     
  3. Click modify to open the document in Microsoft Word.
     
  4. Click the Review tab.
     
  5. For Office 2007:
         a. Click Protect Document and click Restricted Access.
         b. Mark the checkbox Restrict permissions to this document.
         c. Click the More Options button.
         d. In the Permissions window you can grant users read only permissions and also allow them the ability to print the content.
     
  6. For Office 2010:
         a. Click Restrict Editing.
         b. Mark the checkbox in step 2 ( Allow only this type of editing in the document) and select No Changes (Read only).
         c. In the Exceptions section you can add users to allow them to edit the document.
         d. Click Yes, Start Enforcing Protection.
         e. Enter password information for the document.
     
  7. Exit Word and save the Template.
     
  8. Re-associate the template by clicking the green plus symbol in Template Maintenance.
     
  9. Assign the new template to the Company.

Keep on mind that this is Word functionality and not Dynamics GP functionality.

Thanks to David Bader for proving out my theory.

Best Regards,

Patrick Roth
Microsoft Dynamics GP Developer Support

  • I've heard this complaint a number of times, and I'm surprised.  I don't believe anyone would change their accounting records if presented with a conflicting document by one of their customers.  Besides there are two alternative formats that can be used when e-mailing documents.

    Thank you for supplying a solution for those that are still a little nervous about it.

    Steve Chapman

    www.myGPcloud.com

  • Surely with all the free PDF writers around, this is not still an issue. Hopefully nobody is providing services or goods without a valid PO which holds the value due anyway.

    I suppose it is good to show people though, you can make Office docs read only from a template.

  • How about in Letter Writing Assistant?

    I cant use the Protected Word Document.

  • Hi Jem

    The Letter Writing Assistant does not use the Word Templates and is based on different method of getting data into word.

    David

  • David,

    Is there a way to use the Protected Word Document in Letter Writing Assistant?

    Jem

  • Jem,

    I don't see how you could, no.  After the document is generated, you would have to password protect it yourself at that time.

    patrick

  • Patrick,

    Sorry, I don't get you. What i do is I create a Letter in Letter Writing Assistant with a Protection so they will not be able to move or delete, but when i prepared it an error message is showing "From Microsoft VB - The OpenDataSource method or property is not available because the correct selection is locked for editing. And from MS Dynamics GP "Unhandled object exception. EXCEPTION_CLASS_OBJECT_EXCEPTION.

    Jem

  • Hi Jem

    There is NO WAY to password protect the original "base" document for the Letter Writing Assistant as the method used to populate the document requires write access.

    As Patrick mentions, you could protect the resulting "populated" document, but you cannot achieve what you are describing.

    David

Page 1 of 1 (8 items)
Comments Information

PLEASE READ BEFORE POSTING

Please only post comments relating to the topic of this page.

If you wish to ask a technical question, please use the links in the links section (scroll down, on right hand side) to ask on the Newsgroups or Forums. If you ask on the Newsgroups or Forums, others in the community can respond and the answers are available for everyone in the future.

Leave a Comment
  • Please add 6 and 1 and type the answer here:
  • Post