Commission (Window ID-207)
Window: Commission
Description: Maintain Commissions and Royalties
Help: Define how and when you want the commissions to be calculated and to whom to pay it. The Commissions Window allows you define how commissions and royalties will be paid. You can pay multiple commissions for the same order or invoice (e.g. to the person entering the transaction, to the person responsible for sale of the product (category) and or business partner (group).
Tab: Commission
Description: Define Commission Rule
Help: Define when to pay a commission to whom. For each period, you start the calculation of the commission after the transaction for that period are completed or closed.
.png)
| Name | Description | Help | Technical Data |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | C_Commission.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | C_Commission.AD_Org_ID numeric(10) Table Direct |
| Name | Alphanumeric identifier of the entity | The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. | C_Commission.Name character varying(60) String |
| Description | Optional short description of the record | A description is limited to 255 characters. | C_Commission.Description character varying(255) String |
| Active | The record is active in the system | There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
C_Commission.IsActive character(1) Yes-No |
| Business Partner / Sales Rep | Identifies a Business Partner (Sales Rep) receiving the Commission | The Business Partner should be a vendor and may be a Sales Representative | C_Commission.C_BPartner_ID numeric(10) Search |
| Currency | The Currency for this record | Indicates the Currency to be used when processing or reporting on this record | C_Commission.C_Currency_ID numeric(10) Table Direct |
| Charge | Additional document charges | The Charge indicates a type of Charge (Handling, Shipping, Restocking) | C_Commission.C_Charge_ID numeric(10) Table Direct |
| Product | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | C_Commission.M_Product_ID numeric(10) Search |
| Calculation Basis | Basis for the calculation the commission | The Calculation Basis indicates the basis to be used for the commission calculation. | C_Commission.DocBasisType character(1) List |
| Frequency Type | Frequency of event | The frequency type is used for calculating the date of the next event. | C_Commission.FrequencyType character(1) List |
| Copy Lines | Copy Commission Lines from other Commission | C_Commission.CreateFrom character(1) Button | |
| List Details | List document details | The List Details checkbox indicates that the details for each document line will be displayed. | C_Commission.ListDetails character(1) Yes-No |
| Generate Commission | Generate Commission | C_Commission.Processing character(1) Button | |
| Date Last Run | Date the process was last run. | The Date Last Run indicates the last time that a process was run. | C_Commission.DateLastRun timestamp without time zone Date+Time |
Tab: Commission Line
Description: Define your commission calculation rule
Help: Define the selection criteria for paying the commission. If you do not enter restricting parameters (e.g. for specific Business Partner (Groups) or Product (Categories), etc. all transactions for the period will be used to calculate the commission.
After converting from the transaction to the commission currency, the formula for calculating the commission is:
(Converted Amount - Subtract Amount) * Amount Multiplier + (Actual Quantity - Subtract Quantity) * Quantity Multiplier
You can choose, that only positive amounts (Converted Amount - Subtract Amount) and positive quantities (Actual Quantity - Subtract Quantity) are used in the calculation.
.png)
| Name | Description | Help | Technical Data |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | C_CommissionLine.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | C_CommissionLine.AD_Org_ID numeric(10) Table Direct |
| Commission | Commission | The Commission Rules or internal or external company agents, sales reps or vendors. | C_CommissionLine.C_Commission_ID numeric(10) Table Direct |
| Line No | Unique line for this document | Indicates the unique line for a document. It will also control the display order of the lines within a document. | C_CommissionLine.Line numeric(10) Integer |
| Description | Optional short description of the record | A description is limited to 255 characters. | C_CommissionLine.Description character varying(255) String |
| Active | The record is active in the system | There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
C_CommissionLine.IsActive character(1) Yes-No |
| Commission only specified Orders | Commission only Orders or Invoices, where this Sales Rep is entered | Sales Reps are entered in Orders and Invoices. If selected, only Orders and Invoices for this Sales Reps are included in the calculation of the commission. | C_CommissionLine.CommissionOrders character(1) Yes-No |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. | C_CommissionLine.Org_ID numeric(10) Table |
| Business Partner Group | Business Partner Group | The Business Partner Group provides a method of defining defaults to be used for individual Business Partners. | C_CommissionLine.C_BP_Group_ID numeric(10) Table Direct |
| Business Partner | Identifies a Business Partner | A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson | C_CommissionLine.C_BPartner_ID numeric(10) Search |
| Product Category | Category of a Product | Identifies the category which this product belongs to. Product categories are used for pricing and selection. | C_CommissionLine.M_Product_Category_ID numeric(10) Table Direct |
| Product | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | C_CommissionLine.M_Product_ID numeric(10) Search |
| Sales Region | Sales coverage region | The Sales Region indicates a specific area of sales coverage. | C_CommissionLine.C_SalesRegion_ID numeric(10) Table Direct |
| Payment Rule | How you pay the invoice | The Payment Rule indicates the method of invoice payment. | C_CommissionLine.PaymentRule character varying(1) List |
| Subtract Quantity | Quantity to subtract when generating commissions | The Quantity Subtract identifies the quantity to be subtracted before multiplication | C_CommissionLine.QtySubtract numeric Number |
| Multiplier Quantity | Value to multiply quantities by for generating commissions. | The Multiplier Quantity field indicates the amount to multiply the quantities accumulated for this commission run. | C_CommissionLine.QtyMultiplier numeric Number |
| Subtract Amount | Subtract Amount for generating commissions | The Subtract Amount indicates the amount to subtract from the total amount prior to multiplication. | C_CommissionLine.AmtSubtract numeric Amount |
| Multiplier Amount | Multiplier Amount for generating commissions | The Multiplier Amount indicates the amount to multiply the total amount generated by this commission run by. | C_CommissionLine.AmtMultiplier numeric Number |
| Positive only | Do not generate negative commissions | The Positive Only check box indicates that if the result of the subtraction is negative, it is ignored. This would mean that negative commissions would not be generated. | C_CommissionLine.IsPositiveOnly character(1) Yes-No |
