Purchase Order Analysis Report

jonbarr · Jul 21, 2004

Using GP ver 6.0
I'm trying to create a Crystal Report to give me details of the original (ordered) and actual (invoiced) price for Purchased Items. I need data for both Open Orders and those that have been moved to History.
The closest report in GP that I have found is the "Purchase Order Analysis Report" which uses the PO Analysis Temp table. On trying to track down the source of this table's data, I am led to two further tables POP PO ANALYSIS TEMPIdxItem0 and POP PO ANALYSIS TEMPIdxVendor0.
These tables do not appear when I search for Table details.
Can anybody help by telling me which tables provide the information, or better still - how to find out which tables provide this information ?

jazgeek · Jul 22, 2004

v6 goes a way back, but since no real improvements have been made to the purchasing module since then it probably still holds true on the table structure.

I believe you could get this info from:

POP30300 (receipt header), POP30310 (receipt line) linked to a union of: the POP10100/POP10110 (purchase order open) and the POP30100/POP30110 (purchase order closed)

-----------
and they wonder why they call it Great Pains!

jaz

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Purchase Order Analysis Report

jonbarr

MIS

jazgeek

IS-IT--Management

Similar threads

Part and Inventory Search

Sponsor