Sales Report by Item - Showing Revenue and Cost of Sales
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
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
