MIGRATED TOhttp://wavelet.asia/customer-portal/2011/05/05/stock-sales-report-by-item-code/

Description / Usage / Benefits

Stock Sales by Item Code is quite similar to Stock Sales Report, except that it's less detailed and is grouped by Group 1-5. It shows :

• Balance = Stock quantity left in inventory.
• Quantity sold = Deduction from inventory. (Negative amount) is actually a Sales Return.
• Amount = Quantity sold x Unit price.
• COGS = Cost of the stock sold x Quantity
  
• GP = Amount - COGS

Step By Step Guide

1. Set Date range.
2. Location - All or 1 stock location.
3. Select Item Category Filters and tick the box.
4. Group by - Will appear in Blue and Black fonts (2 Groups).
5. Order by - Item Name (Check box).

To Download the Example, click on the link below:
Stock Sales Report by Item Code