Last cost Inventory report - RB

All
I'm trying to write an inventory report that will show me the cost
of a purchased part the last time we purchased it. We are using Standard
costs. When I use the Part.lastmaterialcost field it is all over the
place. It might give me the cost from last months purchase or one six
purchases back. Is there another way to pull the last purchased part
price with different tables ??
Any help would be appreciated or it you have an example RB report
you could send me.

V6.0 529
Cliff Drumeller
IT Manager
Mass Precision, Inc.
408 786 0348
408 314 7420 cell



[Non-text portions of this message have been removed]