Share
Reportwhat is the query to show closed PO, receipt number,Invoice and vendor name for prior last few days in sql
*This post is locked for comments
You’re offline. This is a read only version of the page.
what is the query to show closed PO, receipt number,Invoice and vendor name for prior last few days in sql
*This post is locked for comments
Hi Subhash,
I second the vote to visit Victoria Yudin's site, she's exceptional. As you develop your report, keep in mind that each PO can have multiple receipts and each receipt can have multiple invoices. There's only one vendor, but the other items are not one-to-one. How did you want this report organized?
Leslie
The first place to go for pre-written sql queries is Victoria Yudin's site. She has tons of scripts that you can start with, and modify to your specifics.
[View:https://victoriayudin.com/:750:50]
On the home page, click on GP Reports
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (