Report - Accounting Product Discount Summary

Introduction

This article will describe the usage of the Accounting product discount summary report.

Before you start 

To access this report, please add the following employee permissions to the suitable employee roles in PGM -> Clubs -> Employee permissions.

• Reports
  • Custom
    • Accounting Product Discount Summary

Feature description

To access the report, go to PGM -> Reports -> All.

You can use the search filter and find Accounting Product Discount Summary or select Custom tab and find the report.

In the report filters, the below filters are present.

• Clubs - Select which club this report will generate. If left blank this will generate a report asking you to select a club (All clubs not allowed).
• Ledger - Select which ledger the report will filter to. If left blank or more than one ledger is selected, this will generate a report asking you to select a ledger (Multiple ledgers not allowed).
• From / To - Select the date range the report will filter.

Press XLSX to generate the report.

Report Extract

The Accounting Product Discount Summary report will open with multiple tabs, displaying a list of summaries based on different conditions, and a final tab displaying all transactions.

This report will only display products that have been discounted, if you wish to look for all sales, please use the Accounting Transactions report.

In the summary tabs, the three common fields are as follows:

• Quantity - The total quantity of product sold.
• Regular price - The value of the product at the time of sale (including tax).
• AmountGross - The value of the product after discount was applied.
• DiscountAmount - The difference between regular price and AmountGross fields. This is the value of the discount.

SummaryByAccounting

This tab will summarise the totals based on the account number the product is based in.

Quantities will not appear on this summary tab due to the ability to have a product split across multiple accounts.

SummaryByAccountingAndDisc

This tab will summarise the totals based on the product discount, then the account number the product is in.

SummaryByProductCat

This tab will summarise based on the product category the product belongs in. This is found in PGM->Sale->Product Categories.

SummaryByProductDiscount

This tab will summarise based on the product discount used.

SummaryByProduct

This tab will summarise based on the product.

SummaryByProductAndDate

This tab will summarise based on the product and date of purchase.

SummaryByPosStation

This tab will summarise based on which POS terminal the product was sold on.

SummaryByPaymentType

This tab will summarise based on the payment type used.

PosTotal

This tab provides all transactions that were discounted based on the filters used in the report.

Hints

If no club was selected in the filters, the following error message will appear on the report:

All clubs cannot be selected on this report, please select a single club from list

If multiple ledgers were selected in the filters, the following error message will appear on the report:

Multiple ledgers cannot be used on this report, please select a single ledger