ES Crystal Report

[brutadams]

I need to create a crystal report for an ES database that compares PO Costs to A/P costs to standard costs in IMINVLOC.
If I wanted to go after PO's for the past year, I'm thinking I want to go after the POORDLIN Table for PO cost data, but what table would the A/P line item costs reside in in Macola ES?
Thanks

 

[NEmacGuy]

I might look at the imrechst_sql. In ES your vouchers post dirrectly to the GL - GBKMUT. Are applying your vouchers to their purchasing orders. If so then check out the IMRECHST_SQL.

 

[tpllc]

In Progression the Polinhst contains the quantity and amount invoiced. You may find also find the standard cost at the time the POp was entered in the same table.

Steve Henley
Trianglepartners.com
Exact Software consulting, sales and implementations.

If the only tool you can use is a hammer then all your problems look like nails.