Inventory Aging Report Vantage 8.03.403D

Hi Group,

I have been struggling for a couple of days trying to get an aging
report in Crystal Reports from the PartTran table. What a mess that
table is. Some transactions have a quantity, a unit cost and an
extended amount, others have only an extended amount. We use last cost
and I can't use the PartCost table because we want to be able to back
date the report to the previous month end date.

Would someone please help me figure out how to get the last cost from
this table?

Regards,
Linda Lowney