CCP Report

The CCP program offers rebates to the retailer on BM products.  Sales transactions must be submitted in the format described on the data field tab
 
TransActPOS is equipped to fulfill the Benjamin Moore computer generated Contractor and Commercial Pricing (CCP) program .
Refer to Location of Benjamin Moore data within TransActPOS regarding the locations and edibility of data.
 
Within the Benjamin Moore Report > CCP Report, select the applicable filter to report the selected items within the Benjamin Moore program.  In this example, the store has designated the applicable product with a Fine value of "CCP".  To assist with the application of specific field values for filtered lists, use the IC > Maintenance > Mass Item Changes utility to streamline this process.
 

Core Filters

CCP Report
1

Typically, these five fields are
used to filter to the applicable
list of Benjamin Moore products

1. Typically, these five fields are used to filter to the applicable list of Benjamin Moore products
The assumption is that the inventory has been assigned to one or more of the available fields to report the Benjamin Moore inventory.  In this example, the assigned manufacturer is "Benjamin Moore - V0850".  Some sites have chosen to assign "CCP" to the Sub-Fine field located within the General tab screen.
 
2

Margin Reporting Restriction Control

 

2. Margin Reporting Restriction Control
This Benjamin Moore option restricts the reporting to only show sales activity with less than the indicated % Margin.
 

Reporting with no margin restriction

Reporting with margin restriction of 49%

CCP Report
 
 

Sales Report indicating the margins with the "Include Cost and Profit" selected.

Accounts Receivable > Reports > Sales Report

CCP Report
 
 
 
 
 

Resulting Report

Selecting Generate and Preview will present the typical report similar if not identical to the Sales Report.
 
CCP Report

Creating the Benjamin Moore system generated spreadsheet

If previewing the report, return to the report screen and select the Data View to create the Benjamin Moore required format of the Excel XLSX file.
 
CCP Report
Upon selecting the Data View, the user will be required to enter the BM Outlet No. as requested to your store.  Enter the information and select OK.
Once entered the BM Outlet No. will be saved for future reports.
CCP Report
 
Next up will be the Data Export Field selection.
Simply select OK. Do not alter the selected fields.  The order and All fields have been selected.
CCP Report
 
Within the Data Viewer screen, select the Export button to generate the required XLSX file for the report.
CCP Report
 
 
Name and place the file to the server folder or your workstation's desktop folder.
Note: Once the spreadsheet has been created, do not edit or re-save the the spreadsheet.  This action will imply that a person manipulated the information within the spreadsheet and void the "Computer Generated" status of the XLSX file.
 
Select Email File within Data View to send the file directly from the TransActPOS system thus avoiding the possibility of an accidental edit.
 

Export File Location

Location of a saved export file is typically found within the workstation's client folder.