Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Adding Project Name to...
Microsoft Dynamics GP (Archived)

Adding Project Name to Customer Statement

(0) ShareShare
ReportReport
Posted on by Tanner 360

I have a client who uses project accounting and would like the Project Name to be added to their customer statements.  Their customers just want to be able to see their statement with the list of outstanding invoices, and also a project name next to each invoice so they don't have to manually cross-reference on their side.

I've tried to add the field in multiple ways using Report Writer with no success.  Does anyone know how to accomplish this in Report Writer?  If not, I'm open to other suggestions like SSRS, but we did just set up e-mail functionality around the statements in GP, so I'd prefer to find a solution that keeps the e-mail functionality intact.  They are on GP 2013.

Thank you in advance for your help.

Tanner

*This post is locked for comments

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: Adding Project Name to Customer Statement

    Review the link below, it will show you how to use VBA to populate a report with data from a third-party table.

    blogs.msdn.com/.../getting-data-from-isv-tables-onto-reports-without-needing-to-create-alternate-reports.aspx

    Kind regards,

    Leslie

  • Tanner Profile Picture
    Tanner 360 on at
    RE: Adding Project Name to Customer Statement

    Additional question:

    It appears you can't "replace" a default GP report such as the customer statement with an SSRS report.  What I mean is having SSRS integrated fully with GP so when you print the statements from GP, it lets you select the SSRS report and e-mails automatically as it would with the default report.  Victoria's GP Report Viewer may solve the issue, but does anybody know whether this functionality exists in newer versions of GP, such as 2015 or 2016?  I've confirmed it isn't possible out-of-the-box with 2013.

    Thank you.

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans