web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

SSRS-SOP Invoice Report

(0) ShareShare
ReportReport
Posted on by 18,306

Hello Friends,

I need SOP Open and Historical Invoice in SSRS.  If you have developed the report in SSRS will you like to share with me? 

Thanks much
Sandip 

Categories:
I have the same question (0)
  • Suggested answer
    Derek Albaugh Profile Picture
    on at

    By default, we don't have any 'invoice' reports for Sales, in our SSRS.

    Hopefully someone in the Community will have some ideas that they've used.

    Otherwise, you can try putting together a SQL view pulling the SOP open and historical invoice data you need from the GP databases/tables, then use that in a custom SSRS report.

    Thanks

  • Suggested answer
    Joseph Markovich Profile Picture
    3,976 on at

    Here you go!

    I blogged all about this and included all of the SSRS reports used in GP. At the bottom of the post is a link to all of the SSRS reports and views. SOP Invoice is in there.

    These are very heavily customized, but once you make some modifications for your environment, you'll be good.

    josephmarkovich.com/.../

    Hope this helps.

    Joe

  • Lisa at AonC.com Profile Picture
    963 Super User 2025 Season 2 on at

    We have used Accountable's Forms Printer for this.  (It includes sample SSRS and Crystal reports.)

    https://www.accountable.com/Products/FormsPrinter/

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 467 Super User 2025 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 420 Most Valuable Professional

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 241 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans