unitcost issue from jrnlrow.dat

Posted by NotYet Studio on October 26, 2007, 11:12 am

Please log in for more thread options

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