Crystal reports sales report

[XavierMac]

Hello,

I saw this message in another thread but didn't view an answer. It pretty much describes what I'm going after.

"How do you get the cost for an item sold in Crystal Reports v9?

I have tried:

if {jrnlrow.rowtype} = 1 then GetPeachRowAmountv2

but it only returns 0.00's for every item sold.

I have a record selection:
{jrnlrow.journal} = 3

3 = the sales journal

columns on my report include:

customer
invoice #
date
item
sales amount
cost of goods sold
gross profit

I am using the following tables:
company
chart
customers
jrnlhdr
jrnlrow
lineitem"

I've already gotten most of the fields, I'm missing two that I just can't seem to retrieve the data from. In peachtree they're the Item ID and the unit cost fields.
I've entered the Item ID field in the design section of
crystal reports but the field just comes out empty along
with all the other data. If I remove Item ID, the rest
of the data shows up as I would like. I'm also looking
for the unit cost field which I can't seem to find. Is
there anyone who could help me? Thanks.

 

[blueboyz]

It might be in the way you are linking the tables and joining the fields.

Describe how your tables are joined.