I need a Gridview that will show me all the outstanding receipts in POA. I can produce a report in POA but I want to limit the report to negative receipts only and it doesn't have that option. If I could export the report to excel, I would be able to sort it but it doesn't have that option either. Can anyone steer me to the right Gridview table that will give me the same details as on POA's outstanding receipt report?

Thanks,

Use the Purchase Orders for Adagio 8.1A tables

Depending on the fields you want to include, you want either I/R Header (PI80AHED) or I/R Details Master (1,2) Composite (PI80ACLN).

Steve

The DataDictionaryExporter.exe file located in X:\Softrak\System will build an excel file with all the data tables and fields. You can use this to easily sort through and find exactly what you're after. Combined with the ability to create your own composite tables in GV 9.0C, you can come up with pretty much anything you need.