Printing Subtotals in the Footer of the last page using Microsoft Dynamics GP Word Templates

Dynamics GP Support...

Like ( 0 )

Report

With the introduction of Word Templates we have found it difficult to format Word documents, so they are always printing the subtotal at the very bottom of the last page. We in support have successfully created Word functions to accomplish this with the help of Nathan Adams on the Word Team. Below are the steps to successfully place the Subtotal section of the Reports at the very bottom of the page.

Note: This Customization will only work if you are printing a single document. If you are printing this by batch you will run into issues with the Subtotal only printing on the last page. This is fixed in GP 2010 SP3 Only. We have a new post updated here on how to get the Customization to work correctly with Batches and Terms and Condition pages.

https://community.dynamics.com/product/gp/gptechnical/b/dynamicsgp/archive/2012/08/21/how-to-anchor-subtotals-at-the-bottom-of-the-last-page-of-an-invoice-with-microsoft-dynamics-gp-2010-sp3.aspx

1. Open the Template you would like to modify the subtotal on. In this example I am going to use the Original SOP Blank Invoice.
(Reports | Template Maintenance | select Report Name: SOP Blank Invoice Form (Original) | Click Modify)

2. The current location of the Subtotal section is right underneath the lines. We will need to create Word Field Codes and add the Subtotal table into the Footer section.

3. To create the Field Codes you will need to add the following to the Footer of the Report.
a. While in the Footer you can Toggle field codes by clicking Alt + F9. (Make sure your Keyboard has the F Lock turned on).
Note: To insert brackets for the field codes you need use Crtl + F9. They will look like this { }
b. Type the following:
{ If { page } = {numpages} “paste your table here"}
c. you will now Cut and Paste the Subtotal table after the first quote. It should look like this now:

4. Make sure to un-toggle your Field codes by clicking ALT + F9.

5. Save the document and re-import the Template using Template Maintenance.

6. Now when you print the SOP Blank Invoice the Subtotal section will always be at the bottom or the last page. Here is an example of a 2 page document: (I outlined the subtotal in Red.