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
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.
BL at NotYet Studio
- posted 12 years ago