News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Invoice form showing p...

Microsoft Dynamics GP (Archived)

Invoice form showing past due invoices

(0) Share

Report

Report

Posted on by NHI

1,600

Hi folks,

This customisation is so special so that I urge to ask for your help. My boss wants me to ‘recreate’ our invoice template so that it will show past due invoices. If the aging bucket are not available to the invoice form, we may have to add past due invoices at the bottom of the form where the arrow pointed to i.e

Invoice # Invoice Date Invoice Due Date Invoice Amount

1234 11/01/2013 11/30/2013 $500.00

4567 11/25/2013 12/25/2013 $500.00

He also wants to add next to the total column the current balance and past due balance columns.

Any suggestions?

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (0)

Richard Whaley 25,195 on at

Like (0)

Report

RE: Invoice form showing past due invoices

The problem with doing this is reserving the amount of space for the list. A statement (which is what you want) will print on multiple pages if there are enough open invoices. Now I know you only want past due ones but the spacing could be tricky.

What I would suggest is create SSRS invoice forms and use something like Accountable's Forms Printer to launch them. You could have one document with header information, then a sub report for the invoice data, followed by a second sub report with the past due invoice information. The main report would then close the footer of the form.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2

Martin Dráb 231,317 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans