Sales Report by Item - Showing Revenue and Cost of Sales

marlonnz

Hi,

I am after Sales Report for products sold for a period showing how much that item was sold and its cost (reconciled with relevant GL codes).  I need to report to easily check on the saleability and profitability of products. Any advise how to generate this report?

 

The report would be similar to this - 

Item No.	Description	Card Name	ID No.	Date	Quantity	Price	Discount	Amount	Job No.	Profit Margin $	Status

 

The Sales [Item Detail] Report has got the item number on the first line, then followed by Card Name.  I need that Item Number in same row as the rest of the record.  I also need the description of the item as written in the transaction.

 

Thanks

Marlon

marlonnz

Hi @Princess_R ,

I thought there's another way, as I have been using two sales reports to export in excel as well export my item data to look up the GL code from the combined two sales reports.

Then, I have the report I need.

 

Regards

Marlon