After digging through tables I find that
POP30300 does not list the PO number only the POP Receit #, but the associated line item table (POP30310) lists both. I can't imagine why this is and I am looking for another table that would list both. I can't use the second b/c I am looking for a table that would have a single record. If I use the line table then I get duplicates (more than one item on po) with my 3rd party reporting software.
*This post is locked for comments
Mark is correct, because you can have one receipt associated with multiple POs and/or one PO with multiple receipts and possibly multiple receipt lines, you need to do a join on POP30300 and POP30310 to get all the data you'll need for your report. Properly constructed, your query will eliminate duplicates.
Thanks Mark, I do suppose that makes sense. Mostly used to doing reporting on the sales side of things.
As for the other responses, I was looking for a header table, and I'm using Crystal Reports for a report to be hosted on an internal CR Server. Just gonna have to get creative in CR to remove duplicates.
Hi Brad,
The only other table i can think of that list PO and Receipt number, is the POP10500, however this list multiple lines per PO.
Just thinking about it, this would be as expected. The header cannot contain a value for the originating PO, as there could be multiple POs associated to this receipt. You will have to use one of the tables containing the PO number, and do a select grouping by Receipt Number and PO.
Mark
hi,
are you looking for a header or a detail info? obviously there is a primary field that connects the header to the detail.
What kind of report are you trying to create? What reporting tool are you using?
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,321
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
