Hi Everybody,

I'm trying to do a report on some Line Items and their pricing and costing. Unfortunately, the "Unit Cost" field in the OEHistoryDetails table is not actually the Line Item cost but the Item number's Previous Cost! A lot of the items that should have a cost appear to have Zero cost because they haven't been sold before in the system.

Can anybody help me out here?

thanks,
Lucas