Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

SOP Blank Invoice not putting Totals at the end of the invoice

Posted on by 30

Hi All;

 

I need some help. I have created the SOP Blank Invoice Template for Sales Batch Entry. We want to send the invoices to customers after generating the batch. Now, Word will create the Invoices from the Template and send e-mails to the respective customers.

The problem is we have put the footer on the the Template to print the totals per invoice. The issue is that the Footer only appears on the last invoice and other invoices do not have the footer. We want the Footer to be placed at the end of each invoice in the document.

It very challenging to have code to control the footer to be found on the end of each Invoice in the document. Is there a way of directing the footer to print at the end of every invoice? We are using GP 2010 Service Pack 2 (SP2). When we print one invoice there is no problem because the footer will be found at the end of the document.

Is there a formaula? I used the formula to direct the footer to sit on the last page like {IF{PAGE}={NUMPAGES} "Put my totals Table"}

"Put My Totals Table" - This means I now put my Table for totals as the TRUE evaluation ELSE There is no Footer.

Any help will be appreciated.

 

 

*This post is locked for comments

  • Suggested answer
    Mike Smith Profile Picture
    Mike Smith 6,840 on at
    Re: SOP Blank Invoice not putting Totals at the end of the invoice

    From what I can gather, your goal is to move the totals summary to the footer and not have this "floating" like it does with the standard template.  If this is the case, take a look at this post to see if it helps:

    community.dynamics.com/.../how-to-anchor-subtotals-at-the-bottom-of-the-last-page-of-an-invoice-with-microsoft-dynamics-gp-2010-sp3.aspx

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans