CStoreOffice® Support & Learning

BuyDowns Report

This section describes the specifics of accessing and interpreting the BuyDowns report.

Opening the Report

You can find the report at Reports > Store > Sales > BuyDowns.

The BuyDowns report can be opened at all levels:

  • Account
  • Company
  • Division
  • Location (Station)

For more information, see Viewing Reports.

Viewing the Report

The Buydowns report provides the transaction logs from the cash register. Based on the report data you can keep track of rebates from cigarette manufacturers so that you can compare it to the checks you are receiving from them.

For more information on buydowns, see Buydowns.

The report is based on the manufacturer of the products, not from where they are delivered and should be set up as such in the promotions area of CStoreOffice®. The report can be filtered in many different ways, for example, by manufacturer, so you can see exactly how much is owed by each.

The report contains the following information:

  • Location
  • Category number
  • Date
  • Vendor Name
  • Buydown Name
  • UPC
  • PLU
  • Item Name
  • Quantity
  • Retail
  • Amount
  • MA Transfer

Filtering and Sorting the Report Data

To get the exact information you need, you can apply filters to the report. To set up a filter, select one or more filtering options. Once the filter is set up, at the bottom of the filter section, click the Refresh button to display the report data by the filter criteria.

The report provides the following filtering and sorting options:

  • Date: Specify the period you are interested in manually using the calendar or use one of the available filtering options, and then click Refresh There are the following filtering periods available:
  • Yesterday
  • Current Month
  • Current Quarter
  • Current Year
  • Last Month
  • Last Quarter
  • Last Year
  • Last 12 months
  • advanced: Click the advanced button, select one several filtering options you want, and then click Refresh. There are the following advanced filtering options available:
  • Subtotal By: Select one or several filtering options to break down the report results by the specified criteria.
  • Station Included: Select the stations you want to view the report for.
  • Filter by Location Tags: Use this option to filter the report data by tags assigned to stations. The generated report will contain data only for those stations to which the selected tags are assigned.
    To select tags by which the report data must be filtered, expand the tags tree and select the check boxes next to the necessary tags. You can filter the report data by root tags and tags of the lower level in the tags hierarchy. You can also create a combined filter by selecting different root and child tags.
  • Filter by Item Tags: Use this option to filter the report data by tags assigned to items. The generated report will contain data only for those items to which the selected tags are assigned.
    To select tags by which the report data must be filtered, expand the tags tree and select the check boxes next to the necessary tags. You can filter the report data by root tags and tags of the lower level in the tags hierarchy. You can also create a combined filter by selecting different root and child tags.
  • Filter by Items: Select this option and use the search tool to find the particular items you want to filter by.
  • Filter by Vendors: Select this option to filter the report results by specific vendor.
  • Filter by Method of Accounting: Select this option to filter the report results by the method of accounting.
  • Shift: Select the shifts you are interested in from the 'From' and 'To' fields.
  • Sort by: Select the order of the report columns you want. Select the Ascending or Descending option for the corresponding type of filtering.
  • 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.

  • Show: Select By Sales, By Purchases, or All to view the buydowns by sales, buydowns by purchases, or both.

Additional Actions

  • To view the detailed information for each category item, in the report results, click the corresponding category.
  • To expand all rows in the report, click Expand All.
  • To collapse all rows in the report, click Collapse All.

For more information on additional report features, see Reports.