Skip to main content

JC Commissions Date Entry and Reporting

Written by Denisa Arjoca
Updated over a week ago

A Sales People option is available in Contracts under the Personnel submenu. It allows you to maintain a list of Sales People with a Split % assigned to each person. In addition, Commission Splits Reports on the Reports menu show Contract Sales split by both Contract and Sales Person.


Sales People Workbench

You can use the Sales People Workbench to maintain sales personnel assigned to a contract and to review the totals of assigned and unassigned percentages.

Sales People Option

The Sales People option is available in Contracts under the Personnel submenu, as shown in Sales People Option.

Sales People Option

Browse Screen

When you click the Sales People option, the Sales People browse appears, as shown in Sales People Browse.

Fields on this screen are:

  • Sales Person - The lookup for this field only shows people from the current Company. An error occurs if the field is blank, the person does not exist in the Company, or the person is a duplicate.

  • Split % - The total amount assigned to the Sales Person. An error occurs if 100% is exceeded for the sum of percentages already assigned to other people in the Contract.

  • Total Assigned - The total of assigned commission percentages. This field is found at the bottom of the browse.

  • Unassigned - The remaining percentage (100% - SUM(assigned %)) that has not been assigned. This field is found at the bottom of the browse.

Sales People Browse


Commission Split Reports

A Commission Split Reports submenu is available on the Reports > Operational Reports submenu. It includes the following options, as shown in Commission Split Reports Menu:

  • by Contract

  • by Sales Person

Commission Split Reports Menu

Commission Splits by Contract Report

This report shows Contract sales split by Contract.

Selection Screen

When you select the by Contract report, the Report Selection screen appears, as shown in By Contract Selection Screen. The Main tab1 of this screen contains the following fields:

  • Financial Period - Select a range of financial dates from the drop down list of company GL Periods. The default range comes from the current Financial Period.

  • Include Zero Movement Contracts - If ticked, Contracts with zero movements of Initial and Current Budgets are included in the report.

  • Include Unassigned Contracts - If ticked, Contracts with no Sales People assignments are included in the report.

  • Field Set - The field set you wish to display on the report.

By Contract Selection Screen

Sample Report Layout

A sample layout of the Commission Splits by Contract report is shown in Sample Commission Splits by Contract Report. It includes grand Totals that summarise the values of all selected Contracts.

Sample Commission Splits by Contract Report

Commission Splits by Sales Person Report

This report shows Contract sales split by Sales Person.

Selection Screen

When you select the by Sales Person report, the Report Selection screen appears, as shown in By Sales Person Selection Screen. The Main tab2 of this screen contains the following fields:

  • Financial Period - Select a range of financial dates from the drop down list of company GL Periods. The default range comes from the current Financial Period.

  • Include Zero Movement Contracts - If ticked, Contracts with zero movements of Initial and Current Budgets are included in the report.

  • Field Set - The field set you wish to display on the report.

By Sales Person Selection Screen

Sample Report Layout

A sample layout of the Commission Splits by Sales Person report is shown in Sample Commission Splits by Sales Person Report. It includes grand Totals that summarise the values of all selected Contracts, which are ordered and subtotalled by Person and then Contract Group.

Sample Commission Splits by Sales Person Report

Did this answer your question?