Notifications
Announcements
No record found.
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 muchSandip
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
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
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 467 Super User 2025 Season 2
Martin Dráb 420 Most Valuable Professional
BillurSamdancioglu 241 Most Valuable Professional