Module Description

This module allows defining the way of applying bonuses to customers through specific bonus contracts.

Starting from the revenue of a customer or a customer group, it is possible to calculate and settle customer bonuses by generating a purchase invoice or a sales credit memo.

Setup

Setup Origins

The Bonus setup can be found on the “Setup Origins” page.

Under the “Bonus” tab there are the following fields:

• Base incl. Inv. Discount Default: defines the default setting with which the bonus contract lines will be pre-filled
• Base incl. Line discount default: Defines the default setting with which the bonus contract lines will be pre-filled
• Invoice wording 1: first comment line that will be reported in the bonus liquidation document; in the wording you must insert a variable %01 that represents the "Start Date" of the bonus line
• Invoice wording 2: second comment line that will be reported in the bonus liquidation document; two variables must be indicated in the wording:
  • %01: retrieves the value present in the “Bonus Value” field from the Bonus Settlement table
  • %02: retrieves the sum of the Threshold Value present in the Bonus Calculation Base table
• Invoice Wording 3 : third comment line that will be reported in the bonus liquidation document; in the wording it is necessary to insert a variable %01 that represents the "End Date" of the bonus line 
   

Bonus

From the “Bonus” page select the “New” action to create a new Bonus.

Header

On the bonus header the fields must be filled in as follows:

• Bonus Code : Enter the bonus identification code
• Status: can assume the following values:
  • Open is the initial state of the bonus. It allows editing lines, but prevents from calculating and settling bonuses.
  • Released, status that prevents from modifying the card and allows calculating and settling bonuses
  • Closed has been set to the bonuses already paid
• Description : Enter a description of the bonus card
• Contract No .: enter the bonus contract number if present
• Contract Start Date and End Date : Period to consider for the calculation of bonuses. The value will also be reported on the lines, where it can still be modified.

Lines

The following fields are present on the bonus lines:

• Status Bonus Line:a field that cannot be manually edited and can assume the following values:
  • 'empty': row for which the bonus has not yet been calculated or paid
  • Calculated : row on which the bonus calculation has already been launched, but not the liquidation
  • Settled: row on which the bonus has already been calculated and settled
• Description : mandatory field in which to insert a speaking description that identifies the row individually
• Bonus Settlement: calculated field that reports the quantity of documents generated with liquidation for each single row
• Sell-to/Bill-to: option field in which you must indicate whether the system should filter the sales documents based on the sales customer or the billing customer
• Customer No. Filter (Calculation): Fill in with the customer code, if the bonus line should consider the sales documents of a single customer
• Customer Bonus Group Filter (Calculation): indicate the customer bonus group if the bonus row refers to multiple customers
• Item No. Filter (Calculation): indicate the item code to which the bonus line refers (only if there is one)
• Item Bonus Group Filter (Calculation): Fill in the item bonus group the row refers to
  NB: It is possible to define customer bonus groups and item bonus groups, which facilitate the grouping of customer records into a single group. These are defined on the “Bonus Group” page:
  • Code: the value entered will represent the identification code of the group
  • Description: Enter a description of the group
  • Relationship Type: option field to be filled with Customer or Article based on the group type and will allow you to have a filtered view on the two records
    To define which records fall into the group, it is necessary to assign the code on the customer/item card. 

1. Settlement: option field that can assume the following values:
   • Customer: at the settlement the system will create a provisional sales credit note
   • Vendor: at the settlement the system will create a provisional purchase invoice
   • All - Purchase Invoice: in this case, the system will consider the turnover of all companies in the Bonus Group to evaluate which bonus threshold the line falls within, but upon settlement it will create a purchase invoice for each customer, addressed to the related supplier present in the master data. If the Bonus is of the percentage type, the bonus that will be paid to the individual customer will be equal to the percentage for their turnover. If the threshold is of the amount type, each customer (even with a turnover of 0) will be paid the amount foreseen in the threshold.
     This option makes it mandatory to fill in the Customer Bonus Group in the Bonus row and the Related Supplier field in the customer master data.
   • All – Sales Cr. Note: in this case, the system will consider the turnover of all companies in the Bonus Group to evaluate which bonus threshold the line falls within, but upon liquidation it will create a sales credit note for each customer. If the Bonus is of the percentage type, the bonus that will be paid to the individual customer will be equal to the percentage for their turnover. If the bonus is of the amount type, each customer (even with a turnover of 0) will be paid the amount foreseen in the threshold.
2. No. Settlement: indicate the liquidation customer/supplier. Fill in only if “Liquid to” is valued with 'Customer' or 'Supplier'
3. Start Date and End Date: indicates the period of competence of the bonus. In essence, they identify the period in which to consider the sales documents for the calculation basis of the bonus. It will not be possible to liquidate the lines with "End Date" not yet passed
4. Configure limits: calculated field that allows access to the page for entering the different row bonus thresholds (see the bonus thresholds chapter)
5. Base incl. Inv. Discount: to be activated if you want to consider the amounts net of invoice discounts
6. Base incl. Line Discount: activate if you want to consider the amounts net of line discounts
7. Base incl. VAT: activate if you also want to include VAT in the calculation base
8. Customer Field Filter: allows you to insert additional filters relating to the customer profile, in addition to those described above
9. Customer Dimension Set ID Filter: Allows you to insert filters related to the dimensions used on customers, in addition to those described above
10. Item Field Filter: allows you to insert additional filters relating to the item master data, in addition to those described above
11. Item Dimension Set ID Filter: Allows you to insert filters related to the dimensions used on the items, in addition to those described above
12. Settlement Invoice Line Type: option field that allows you to determine the CG account or the item on which to account for the bonus at the time of settlement
13. Settlement Invoice Line Detail: indicates the c/g account or the item on which to post the document.
14. Total Amount (not filtered): calculated field that reports the total amount of the documents included in the calculation base based on the filters set in the row
15. Total Quantity: shows the sum of the quantities of the documents considered based on the filters set
16. Total net weight: shows the sum of the net weight of the documents considered based on the filters set
17. Threshold value: based on the parameter considered in the Thresholds (see the chapter on bonus thresholds), a value is reported in this field between Total Amount (not filtered), Total Quantity and Total Net Weight. It represents the actual basis for calculating the bonus. It is a navigable field that allows access to the list of sales documents that compose it, called “Bonus Calculation Base”.

Bonus Thresholds

The bonus thresholds are defined in the dedicated page accessible from the calculated field “Set Thresholds” present in the bonus rows.

Thresholds allow you to define one or more bonus levels. It makes sense to define multiple levels when the bonus amount or percentage varies with the parameter.

The parameter can be represented by the amount, quantity or net weight of the sales documents.

Field logic:

• Threshold type:field that determines the method and parameter of bonus calculation. It can assume the following values:
  • Standard Cases:
    • Amount (VL) : the parameter and the calculation basis are represented by the total amount of the sales documents
    • Quantity (Base) : the parameter is represented by the total quantity of the sales documents
    • Net Weight : the parameter is represented by the total net weight of the sales documents
• Value increments: the system will compare the reference value with the value of the comparison period to calculate the increment. For this type of calculation, it is also necessary to fill in the “Threshold comparison period” field with a given formula (e.g. -1A). The options that fall into this category are:
  • Amount Increase (VL) : the system will calculate the value of the increase as the difference between the amount of the period and the amount of the comparison period
  • Quantity increment (Base) : the system will calculate the increment value as the difference between the quantity of the period and the quantity of the comparison period
  • Net weight increase : the system will calculate the value of the increase as the difference between the net weight of the period and the net weight of the comparison period
• Percentage Increase: similar to the “Value Increases” category, but in this case the increase is not identified as a value, but as a percentage. Also in this case it is necessary to fill in the “Threshold Comparison Period” field. The options that fall into this category are:
  • Amount (VL) Percentage increase : the system will calculate the percentage of the increase by comparing the amount of the period and the amount of the comparison period
  • Quantity (base) Percentage increase : the system will calculate the percentage of the increase by comparing the quantity of the period and the quantity of the comparison period
  • Percentage increase in net weight : the system will calculate the percentage of the increase by comparing the net weight of the period and the net weight of the comparison period
• Threshold: in this field you must enter the minimum value that the parameter must reach in order to access the bonus threshold. By setting the value to 0 and the “Value Type” to 'Amount (VL)', the system will pay the bonus even in the case of a customer without turnover
• Type Value (% or VL):option field in which to indicate the type of bonus. It can assume two values:
  • Amount (VL): the value entered in the “Bonus Value” field will represent the actual bonus amount
  • Percentage : The value entered in the “Bonus Value” field will represent the percentage to be applied to the parameter to determine the bonus amount (applicable only if “Threshold Type” is set to 'Amount (VL)')
  • Unit amount: the value entered in the “Bonus Value” field is applied to each individual quantity sold
• Bonus Value: to be filled in with the amount or percentage of the bonus, based on the value entered in the previous field

Functionality

Calculate Base

The payment of bonuses starts with the calculation of the basis on which the bonuses will be determined.

In order to calculate the bonus, you must have released the header (by manually changing the Status field to Released).

Finally, launch the “Calculate Base” action.

The action will go to:

• Calculate the parameters of each bonus line, i.e. Total Amount (unfiltered), Total Quantity, Total Net Weight and Threshold Value
• Change the status of rows from '' to 'Calculated' 
  
• Fill in the “Bonus Calculation Base” table (accessible from the “Threshold Value” navigable field in the row) with the sales documents that form the basis for calculating the bonus. The bonus quota for each document is also shown for each row. 
  

Once the base calculation has been launched, in order to modify the rows it will be necessary to reopen the bonus with the “Reopen” action in the header. The modified rows will return to the '' state and the previously calculated parameters will be whited. It will then be necessary to relaunch the Calculate Base.

Bonus Liquidation

Once the base has been calculated, it is possible to proceed with the payment of the bonuses.

From the header menu select the action “Liquid A”.

The liquidation will go to:

• Create one or more settlement documents for each bonus line (purchase invoices/sales credit notes based on the line settings), reporting in the document lines the account/item, indicated in the “Invoice Detail” field, valued with the bonus amount of the threshold in which the line falls. The system will act only on the lines with “End Date” < “Work Date” and with “Last Calculation Date” > “End Date”. (Last Calculation Date is a field editable only by the system that updates every time the “Calculate Bonus” action is launched).
  In case of settlement with sales credit notes, a flag not visible in the page called “NC bonus settlement” will be activated on the document. The flag is intended to exclude the credit note from the calculation of the bonuses that will take place in the following period.
• Change the status of the lines to “Settled”
• Fill in the “Bonus Liquidated” field with the number of documents generated
• Fill in the “Accrued Bonuses” table, which can be analyzed from the Bonus row, with one row for each bonus row paid. The Accrued Bonuses report:
  • Threshold value
  • Bonus value
  • Provisional document reference
  • Registered document reference 
    
    

On the “Maturated Bonuses” page, you can view the documents generated by the liquidation of the single line. With the “Open document” action, the provisional or registered document of the selected line will be opened

Reopening of Bonus line already paid

Once a bonus line has been settled, it can be reopened until the purchase invoice/sales credit note generated by the settlement is recorded.

To reopen the row there is a function in the bonus row menu called “Reset Row”. This function will go to:

• Delete all documents generated from the selected bonus line
• Delete the rows of the Accrued Bonuses relating to the selected row
• Delete the Threshold Value rows of the selected row
• Reset the row state to 'empty'