As of yet, I've not found an accurate cost field. In fact the only cost field that brings back a value that is anywhere related to the unit cost or last unit cost values is the 'laborcost' field from the lineitem.dat file.
Peachtree support says that the unitcost field on the jrnlrow.dat table should contain the exact value for the line item sold. It should also retain the value at the time of sale. So, if the cost changes over time, this field should retain the cost changes for each transaction. Unfortunately, when I put that field on my report, it is returning a price, not a cost.
Any ideas or do you need more information.
Please let me know. Thanks, BL at NotYet Studio