Questions from reviewing the Sales Analysis report:
To review Customer Sales run the Sales Analysis - Date Range report from the Customer / Reports menu.
Why is the line blank?
This will occur if the item was sold and returned within the same date range and the sell and cost prices did not change.
Why is the Percentage negative?
If an item was returned by a Customer or credited then this is correct. Check and make sure the Quantity is a negative value
If the Quantity sold is positive and the percentage shows as a negative then this indicates that the item was sold for a value less than it cost you. Things to check:
- Has the item gone up in price?
- Did someone sell a box or carton code rather than a single unit?
Why is the Margin 100%?
This will generally indicate that there is no Cost price stored against the Item.