Question: How to investigate items with negative GPMs?
Answer:
- From the C-Store Office home page go to Reports > Store.
- Under Sales click Item Sales by Tags.
- Specify filtering and sorting options. Filter by Item Tags or use subtotals.
Note:
Press CTRL to select several items at a time.
Select the Show Only option to view only the information for the selected items and Show All Except to view the information for all the items except the selected ones.
For more information about working with the Item Sales by Tags report, see this Petrosoft University article. - Use the report's columns and rows to isolate areas of interest.
- If you find a category with a negative GPM value, you can click on it to see a list of items in that category.
- Once you have located an item that with a negative GPM, click on an icon next to the item.
Result: This will take you to the Item Setup view. - Expand the date selection out until you see the Cost/Retail graph change.
- Continue to the bottom of the report and under Purchases click on the dollar amount.
- In the Item Movement report that opens, scroll down to see item purchases.
- Review invoices that contain the item in question to locate the problem.
- Make a note of the invoice date, time, and number.
- With the cause of the problem located, we can use the Invoice Report for this location to view the invoice, move it to Pending status, make corrections, and re-accept it.
A more detailed instruction with examples and screenshots can be found here