unitcost issue from jrnlrow.dat

I am a Crystal Reports expert helping a local school. I'm writing several custom reports for them. This school sells Scrip items and needs to have an invoice and other reports that display the unit price
(calculated from PriceLevel1Amount) and also the unit cost. The unit cost has been an issue.
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
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload

BeanSmart.com is a site by and for consumers of financial services and advice. We are not affiliated with any of the banks, financial services or software manufacturers discussed here. All logos and trade names are the property of their respective owners.

Tax and financial advice you come across on this site is freely given by your peers and professionals on their own time and out of the kindness of their hearts. We can guarantee neither accuracy of such advice nor its applicability for your situation. Simply put, you are fully responsible for the results of using information from this site in real life situations.