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 ?
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 ?