How can I run a report by customer purchase order #?
we have some customers that issue upwards of 20 purchase orders for work each month. I would like to be able to give that customer a report that includes their purchase order # on it.
*This post is locked for comments
Not sure if you're looking to build something in sql but the easiest way is to build a view from the POP10100 table. This should give most of what you're looking for. No fancy joins or anything, at least for a simple breakdown. The following below is only for active PO's.
Here's all you would need to start with:
CREATE VIEW dbo.PONUM_BY_VENDOR AS
SELECT TOP 10000
VENDORID,
VENDNAME,
PONUMBER,
SUBTOTAL,
REMSUBTO
FROM POP10100
WHERE STATGRP = 1
ORDER BY VENDORID
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,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (