Commission

This chapter contains all important information on setting up and processing commissions in TRASER DMS 365. It is divided into the following sections:

Setting up the Commission Functionality

This section describes how to set up the commission functionality. To set up the commission functionality, please proceed as follows:

  • Use the quick search (ALT+Q) to find the Commission Setup page.
  • Make the necessary settings according to the following table:

Important!

When setting up the commission functionality, you must decide whether you want to use collectible commission or business transaction commission in your system. This is determined by the status of the Calculate Commission per Transaction toggle switch. Once commission has been calculated, it cannot be changed retrospectively. Collectible commission is selected by default and means that the commission amount is calculated based on the total revenue posted in a specified period. In the case of business transaction commission, the commission amount is calculated separately for each order before posting.

Note

Default dimensions must be stored for a salesperson to use the commission function. To do so, open the desired salesperson/purchaser card on the Salespeople/Purchasers page and click on Salesperson > Dimensions-Single. Then, fill in the fields according to the specifications in the Setting up Default Dimensions section.

FastTab Option Description
General Active Activate this toggle switch to activate the commission functionality. This toggle switch must be deactivated in order to edit the other fields for setting up the commission function.
Type of Commission This field specifies if Collectible Commission or Business Transaction Commission is used. It is filled automatically by the system according to the status of the Calculate Commission per Transaction toggle switch.
Calculate Commission per Transaction Activate the toggle switch to use business transaction commission in your system. Leave the toggle switch deactivated to use collectible commission in your system. Please note that this setting cannot be changed after the first commission calculation.
Salesperson Dimension Enter the dimension code of the salesperson who should receive the commission, e.g., SALESPERSON.
Salesperson 2 Dimension Enter the dimension code of a second salesperson who should receive the commission, e.g., SALESPERSON2.
Only Add Settled Documents Activate this toggle switch to specify that only settled documents should be used to calculate the commission.
Only Add settled Trade-In/Purchase Activate this toggle switch if documents should only be included in the commission document once the trade-in or purchase has been released for picking.
Selection Period Enter a formula for the commission calculation, e. g., -3M, if the last three months should be taken into account for the commission calculation.
Calculation Period Specify the period for which documents changes should be taken into account for commission calculation, e. g., 1M.
Correction Option Specify how differences should be processed. If you select Differential, differential lines will be created. If you select Cancel & New, the lines will be canceled and new lines will be created.
Run Adjust Cost Before Activate the toggle switch if the adjust cost report should be run before commission documents are created.
Number Series Commission Nos. Enter a number series for the commission documents.
Posted Commission Nos. Enter a number series for posted commission documents.
Options Commission Period Base Enter the period for the commission calculation.
Commission Start Month If the Year option was selected in the Commission Period Base field, enter a starting month for the commission calculation.
Include Documents without Salesperson Activate this toggle switch if invoices and credit memos that cannot be assigned to a salesperson should also be included in the commission documents.
Include Service Documents Activate this toggle switch if service invoices an service credit memos should also be included in the commission documents.
Advanced Commission Active Activate this toggle switch if you would like to use the advanced commission functionality. If you activate this toggle switch, you will be able to set up commission fields and commission summations.
Summation Mandatory Activate this toggle switch if only posted document lines that contain a sum should be added to commission documents.
Bad Debts Active Activate this toggle switch if sales that have been marked with Bad Debt should be excluded from the commission calculation. The Bad Debt checkbox in the General Journal indicates instances of bad debts.
Process Setup Process posted documents by Specify how you would like posted commission documents to be processed.
XML Port Enter the XML port that will be used for the export of posted commission documents.
Multiple Commissions per Document Activate this toggle switch to enable the creation of multiple commissions for one document.

You have successfully completed the basic setup of the commission function. Your changes are saved automatically. The next section describes how to set up commission calculation methods on the commission setup page.

Setting up Commission Calculation Methods

To set up commission calculation methods on the Commission Setup page, please proceed as follows:

  • Click on Home > Calculation Methods in the menu bar.
  • Click on New in the menu bar to create a new calculation method.
  • Fill in the columns according to the following table:
Column Description
Calculation Code Enter a unique description for the calculation method, e. g., MACHINE, if you want to set up a calculation method for the commission of machines.
Description Enter a significant description for the calculation method.
Default Calculation Select the method for determining commission revenue and commission contribution margin from the dropdown menu, e.g., Machine for machine-based commission, Quantity for quantity-based commission, Fixed Amount for a fixed commission revenue, Net Payment for commission based on net revenue, or Standard. If you select the Quantity option, it must also be selected in the Default Commission Type column.
Default Commission Type Select whether the Commission will be awarded by default based on Revenue, Contribution Margin, Single Payment, or Quantity sold. If you select the Quantity option, it must also be selected in the Default Calculation column.
Include Location Margin % Select this checkbox if the location margin % should be taken into account for the commission calculation.
Negative Base Amount Not Allowed Select this checkbox if no negative commission base amount may be used for commission calculation on invoices.

You have successfully set up the commission calculation method. Your changes are saved automatically. You can set up additional commission calculation methods as needed. The calculation methods can now be assigned to different service order types on the Service Order Types page. More information on service order types can be found in the Setting up Service Order Types chapter.

Setting up Commission Fields

Note

You only have to set up commission groups if you activated the toggle switch Advanced Commission Active that was described in Setting up the Commission Functionality.

Commission fields allow you to set up different filters. These filters will then be used by the system to filter for documents that are relevant for a specific commission calculation. To set up commission fields on the Commission Setup page, please proceed as follows:

  • Click Advanced Setup > Field Setup in the menu bar.
  • Fill in the columns according to the following table:
Column Description
Commission Field No. This field will be filled by the system. You can set up as many commission fields as needed.
Source Type Enter the source type the system should filter by, e. g., Dimension if you want the system look for a specific dimension.
Description Enter a significant description, e. g., TRACTOR, if you want to grant a commission on all tractor sales.
Dimension Code If you select the Dimension option in the Source Type field, enter a dimension code, e.g., Category, so that the system will filter for the Category dimension.

You have successfully set up commission fields. Your changes are saved automatically. You can now close the page or set up more commission fields. The next section describes how you can add these commission fields to a commission summation.

Setting up Commission Summations

Note

You only have to set up commission groups if you activated the toggle switch Advanced Commission Active that was described in Setting up the Commission Functionality.

Über die Provisionssummierungseinrichtung können Sie spezifische Provisionsberechnungen anlegen. Um auf der Seite Einrichtung Provision Provisionssummierungen einzurichten, gehen Sie wie folgt vor:

  • Click Advanced Setup > Summation Setup in the menu bar.
  • To create a new commission summation click on New.
  • A new Commission Summation Setup Card is displayed.
  • In the the General tab, fill in all necessary information according to the table below.
Field Description
Start Date Enter a starting date for the summation. The system will use this date to filter for documents that match the specific commission summation.
Summation No. Manually enter a summation number, e.g., MACHINESUMMATION, if you want to set up the commission calculation for specific machines.
Commission Calculation Method Select the calculation method of the summation from the dropdown list.
Description Enter a significant description for the summation.
Commission Type Select if the commission is based on Revenue, Contribution Margin, or a Single Payment.
Calculation Select how the commission should be calculated. The setting selected here overrides the calculation in the Commission Calculation Method field.
End Date Optional Enter an end date for the summation.
Parent Summation No. Optional If applicable, enter the parent summation number.
Include Location Margin % Optional Select this checkbox if the location margin % should be taken into account for the commission calculation.
Negative Base Amount Not Allowed Optional Activate this toggle switch if the commission base amount for commission calculation in invoices should be set to 0. For credit memos, this occurs when the commission base amount is positive.
Active Activate this toggle switch to activate the commission summation. You can only activate the toggle if you have assigned commission fields to the lines.
  • In the Lines FastTab, you can now assign commission fields to the summation. These fields are then used by the system as filters to determine which documents are eligible for the commission summation.
  • After setting up the summation and assigning commission fields to the summation, you can activate the Active toggle switch in the General FastTab.

You have successfully set up the commission summation. Your changes are saved automatically. You can now close the page or set up more commission summations.

Setting up Commission Groups

Note

You only have to set up commission groups if you activated the toggle switch Advanced Commission Active that was described in Setting up the Commission Functionality.

Über Provisionsgruppen können Sie die Staffelung der Provision für bestimmte Provisionssummierungen definieren. Anschließend können Sie Verkäufern eine Provisionsgruppe zuweisen. Um eine Provisionsgruppe einzurichten, gehen Sie wie folgt vor:

  • Use the quick search (ALT+Q) to find the Commission Groups page.
  • To set up a new commission group, click on New in the menu bar.
  • Enter a unique name for the commission group in the Group Code field.
  • Enter a significant description for the commission group in the Description field.
  • To add different commission percentages to the commission group, click on Commission % in the menu bar.
  • Click on New in the menu bar of the following window to define a new percentage.
  • Fill in the columns according to the following table:
Column Description
Start Date Enter a date at which the commission percentage becomes valid.
Summation Name Select a Commission Summation for which the commission percentages should apply.
Quantity Commission Select the checkbox if you have selected a quantity-based commission summation. If the checkbox is selected, a fixed commission amount is calculated in the Commission % / Unit Price field instead of a commission percentage.
Salesperson Type Enter the salesperson for whom the commission percentage in the Commission % / Unit Price column should apply, e.g., Salesperson 1. This is relevant if you want to use different percentages for the same commission summation in the case of multiple salespeople.
Minimum Amount/Quantity Enter the minimum amount/quantity from which the commission percentage rate should apply.
Commission % / Unit Price Enter the commission percentage or amount per sold unit.
End Date Enter the end date for the commission percentage.

You have successfully set up a commission group including the commission percentages. You can set up additional commission groups and commission percentages as needed. You can now assign commission groups to salespeople via the Salespeople/Purchasers page. The next section describes how to create commission documents for service and sales documents.

Creating Commission Documents

Note

To be able to create commission documents for service and sales documents, the following preconditions have to be met:

To create commission documents for service and sales documents, please proceed as follows:

  • Use the quick search (ALT+Q) to find the Commission Document List page.
  • Click Create > Create Documents in the menu bar.
  • Fill in the fields according to the information in the following table:
Field Description
From Date Filter Specify the date from which commission-relevant documents should be filtered.
To Date Filter Specify the date to which commission-relevant documents should be filtered.
Service Order Filter Optional Select a service order type from the dropdown menu, if you want to filter for documents with this service order type.
Responsibility Center Filter Optional Select a responsibility center from the dropdown menu, if you want to filter for documents with this responsibility center.
Document No. Filter Optional Enter a document number, if you want to filter for documents with this document number.
  • Confirm your entries with OK. A new commission document will be created.
  • Open the commission document.
  • Navigate to the Lines FastTab.
  • Check the details based on the information in the following table and make changes as needed. Editable fields are highlighted in bold.

Note

If you have set up commission fields, they are also displayed in the following table.

Column Description
Salesperson Type This column displays the salesperson type for the commission line.
Salesperson Code This column displays the salesperson code for the commission line.
Exclude Select the checkbox if this line should be excluded from the commission calculation. To exclude a salesperson from any commission payments, follow the instructions in the Excluding Salesperson from Commission section.
Line Type This column specifies the type of transaction that was posted on the document line, e.g., Item, Resource, Item Charge, G/L Account, or Fixed Asset.
No. This column specifies the corresponding transaction type number in the Line Type column.
Commission Base Amount/Quantity This column specifies the base amount, or the quantity in the case of quantity-based commission, to be used for calculating the commission amount. The calculation of this amount depends on the status of the Calculate Commission per Transaction toggle switch.
Commission % / Unit Price This column is only displayed if the Calculate Commission per Transaction toggle switch is activated. The fields in this column are automatically filled in with the values stored for the commission group of the salesperson, but can be changed manually in commission documents that have not yet been posted. Manual changes are applied to recalculations or corrections of the commission.
Commission Amount This column is only displayed if the Calculate Commission per Transaction toggle switch is activated. It specifies the commission amount and is automatically calculated by the system based on the values in the Commission Base Amount/Quantity and Commission % / Unit Price columns.
Sell-to Customer No. This column displays the customer number from the related sales document.
Bill-to Customer No. This column displays the customer name from the related sales document.
Bill-to Customer Name This column displays the bill-to-customer name from the related sales document. Click in the field to get more information about this customer.
Posted Doc. No. This column specifies the posted document number for which the commission should be calculated.
Posted Doc. Line No. This column specifies the posted document line number for which the commission has been calculated.
Summation Name This column specifies the name of the commission summation that applies to this line.
Description This column displays the description of the document line.
Correction Line The checkbox in this column indicated if this line is a correction. More information on correcting commission documents can be found in the Correcting Commission Documents section.
Service Item No. This column displays the corresponding service item number.
Serial No. This column displays the corresponding serial number.
Revenue This column specifies the revenue used for commission calculation.
Source Doc. Type This column specifies the source document type, e.g., Sales Order or Sales Credit Memo.
Original Posting Date This field displays the original date when the document was posted.
Summation Starting Date This column displays the starting date for the summation.
Provision Line Status This column displays the payment status of the corresponding document line. Lines with the Unpaid status are highlighted in red and cannot be posted. Lines with the OK status have already been paid and can be posted.

Note

You can manually release unpaid commission lines for posting by opening the corresponding invoice or credit memo and clicking on Invoice or Credit Memo in the menu bar, then clicking on Release for Commission. This sets the Commission Line Status to OK, and you can continue processing the commission document as usual.

  • Click on Status >Release in the menu bar to release the document.
  • Close the document to return to the Commission Document List.
  • Then, click Post > Post in the menu bar to post the commission document.
  • Confirm the following dialog window with OK.
  • Confirm another dialog window with Yes, if you want to open the posted commission document.

You have successfully created a commission document for a service or sales document. With collectible commission, a separate commission line is created for each commission summation; with business transaction commission, a separate commission line is created for each order.

Correcting Commission Documents

You have the option to correct en incorrect commission document. To do so, please proceed as follows:

  • Use the quick search (ALT+Q) to find the Commission Document List page.
  • Select the commission document you want to correct.
  • Click on Create > Create Correction Document in the menu bar.
  • In the Commission Calculation Date field, select the date for recalculating the commission.
  • Complete the information according to the following table:
Column Description
Salesperson Type This column is filled automatically by the system and displays the salesperson type from the commission document.
Salesperson Code Select the salesperson code for the commission correction from the dropdown list.
Single Payment Select this checkbox, if the commission correction is a single payment.
Summation No. Click on the selection field, select the desired summation for the commission calculation, and confirm your selection with OK.
Amount Enter the commission correction amount.
Correction Comment Optional Enter a comment about the commission correction.
Posted Doc. Type This column is filled automatically by the system, but can be edited as needed. It specifies the posted document type, e.g., Sales Order or Sales Credit Memo.
Posted Doc. No. Click on the selection field, select the number of the posted document for which the commission should be calculated, and confirm your selection with OK.
Posted Doc. Line No. Click on the selection field, select the number of the posted document line for which the commission should be calculated, and confirm your selection with OK.
Sell-to Customer No. This column is filled automatically by the system once you selected a Posted Doc. Line No. and specifies the customer number from the corresponding sales document.
Service Item No. This column is filled automatically by the system once you selected a Posted Doc. Line No. and specifies the corresponding service item number.
  • Confirm your entries with OK. The commission correction is processed and you will be redirected to the Commission Document List automatically.

You have successfully corrected a commission document. The correction document can be opened via the Commission Document List page.

Excluding Salesperson from Commission

You can specify on the salesperson card that the salesperson in question is blocked for commissions, i.e., excluded from any commission payments. To do so, please proceed as follows:

  • Use the quick search (ALT+Q) to find the Salespeople/Purchasers page.
  • Open the salesperson you want to exclude from commission payments.
  • Activate the Exclude from Commission toggle switch in the General FastTab.

You have successfully excluded the salesperson from commission payments. The next sections describes how to access the commission overview of a salesperson.

Accessing Commission Overview on the Salesperson Card

To get an overview over all commission sums and commission lines of a salesperson, please proceed as follows:

  • Use the quick search (ALT+Q) to find the Salespeople/Purchasers page.
  • Open a salesperson/purchaser card.
  • Click on Salesperson > Commission Overview in the menu bar.

You have successfully accessed the Commission Overview of a salesperson, where you can view their current commissions, commission amounts paid, and active commission lines. To view archived commission lines for the salesperson, click on View History in the menu bar and navigate to the newly displayed Archived Commission Lines FastTab.