In Touch with Dynamics GP

This blog is intended to be a useful resource for Microsoft Dynamics GP users and professionals in the UK and the wider Microsoft Dynamics GP community as a whole.

Wednesday, 12 January 2011

Dynamics GP 2010 word templates (more required fields SOP Blank History Invoice)

Regular readers will now we put up a post in October 2010 detailing which vendorid field was required to allow the word template version of the remittance advice to email correctly.

Well we have found another such required field, this time in the SOP Blank History Invoice.

SOP Blank History Invoice only works if the SOP Number from SOP Transaction Amounts History is the key break field on H1 and F1 in the Dynamics GP report. In other words “SOP Number" needs to come from the SOP HDR History table instead of the SOP LINE History table.

We are generally finding these sort of issues where a report has been modified in a prior version and then upgraded to 2010.

Here are the steps to change this:

1. Open up Report Writer and change Header Dummy 1 to use the Sales Transaction Amounts History table. Make sure the field SOP Number is selected as the break field.

2. Change Footer "Back Order" to use the Sales Transaction Amounts History table. Make sure the field SOP Number is selected as the break field.

3. Save the report.

4. Go back into GP and print the report to Standard > File > XML File. Make sure you select XML file in the file name window as well. Generate the XML File.

5. Reports>Template Maintenance. Pull up their template and click Modify. In Word, go to Field List and choose Remove Source.

6. Then choose Add Source and point it to your XML file from step 4.

7. Save the template.

8. Go back to GP and click the Green plus sign and point it to the newly saved template from step 7. Replace the template.

9. Now go email the report and it should work.


  1. Your nine steps are really awesome, the article which you have shared is really having great information.thank you so much for weighting Invoice Template

  2. i can not find out how to "go to Field List" in word 2007. help please! =)

  3. This is perfect way to describe and you did it well. I was searching similar kind of information and I am glad that I found it. However, I was searching some ready to use templates prepared in MS Word. Please check this resource and guide me.
    Word Templates

  4. I am glad you take pride in what you write. This makes you stand way out from many other writers that push poorly written content.
    Whmcs templates


  5. He said that complaints lodged by parents about the fee increase were addressed regularly. The Punjab Examination Commission has prepared a new policy related to the results of grades five and eight.

    8th class result pec 2018
    5th class result 2018 roll number wise
    8th class results 2018

  6. Andy, these steps were magic. Saved me hours copying SOP Blank Invoice Word template to SOP Blank History Invoice Word template. Your blog is much appreciated!

    Lisa Williams