New Discount Reports For Amicus POS

Hey all

I’ve added a couple of new reports to the sales reports section within the Amicus Point Of Sale software.

The first report is called the SaleItemPriceVarianceReport and is designed to list sale items with the intention of displaying how much discount they have had applied to them. It also displays what type of discount they are, or whether they have had a price override.
It filters by all the usual product filters, SiteGroup, Site, Customer, and the user can specifically include sale items that have a zero value variance from the RRP to their actual sell price.

The second report is based loosely on the SaleItemPriceVariance report and shows many of the same values, but is designed to group like discounts for a product. I.e. it will (possibly) show the same product many times with an individual record for each occurrence of a unique discount value with summary information for the total number of units sold at the specified discount value over x number of sales. It displays each unique product as a separate sub report, with each record within a sub report representing a differing discount value. Each subreport also provides summary information for the product, and the report as a whole will show summary information for all items displayed.

An example of this report might show a can of softdrink which retails for $1 occupying one subreport, having 4 separate entries. The first entry will be the largest discount (based on percentage) given for the product (i.e. 40%), followed by lesser variances.

Where a price has been specifically overridden (I.e. a specific discount percentage has not been saved against the record), then a calculated value will be used, based on the calculated total RRP as a percentage of the actual sell price. If no variance is present (and the checkbox to include such records has been checked), then a blank space will be placed in the discount percentage box.

These reports will be particularly helpful for our general retail, fuel, hospitality, and supermarket clients who want to track specific products (or groups) to see how many items have been sold at the various discounted rates.

As always, if you have any queries, come and see me.

Dave.