ManPageW Commission
Enjoy it, and help to fill it! But please, always respecting copyright.
Please write your contributions under the Contributions Section
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.
Table Name : C_Commission
Fields
| Name | Description | Help | Technical Data |
|---|---|---|---|
| Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
| Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
| 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. | Name
NVARCHAR2(60) String |
| Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(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. |
IsActive
CHAR(1) YesNo |
| 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_BPartner_ID
NUMBER(10) Search |
| Currency | The Currency for this record | Indicates the Currency to be used when processing or reporting on this record | C_Currency_ID
NUMBER(10) TableDir |
| Charge | Additional document charges | The Charge indicates a type of Charge (Handling, Shipping, Restocking) | C_Charge_ID
NUMBER(10) TableDir |
| Calculation Basis | Basis for the calculation the commission | The Calculation Basis indicates the basis to be used for the commission calculation. | DocBasisType
CHAR(1) List |
| Frequency Type | Frequency of event | The frequency type is used for calculating the date of the next event. | FrequencyType
CHAR(1) List |
| Copy Lines | Copy Commission Lines from other Commission | CreateFrom
CHAR(1) Button | |
| List Details | List document details | The List Details checkbox indicates that the details for each document line will be displayed. | ListDetails
CHAR(1) YesNo |
| Generate Commission | Generate Commission | Processing
CHAR(1) Button | |
| Date last run | Date the process was last run. | The Date Last Run indicates the last time that a process was run. | DateLastRun
DATE DateTime |
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.
Table Name : C_CommissionLine
Fields
| Name | Description | Help | Technical Data |
|---|---|---|---|
| Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
| Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
| Commission | Commission | The Commission Rules or internal or external company agents, sales reps or vendors. | C_Commission_ID
NUMBER(10) TableDir |
| 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. | Line
NUMBER(10) Integer |
| Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(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. |
IsActive
CHAR(1) YesNo |
| 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. | CommissionOrders
CHAR(1) YesNo |
| Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. | Org_ID
NUMBER(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_BP_Group_ID
NUMBER(10) TableDir |
| Business Partner | Identifies a Business Partner | A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson | C_BPartner_ID
NUMBER(10) Search |
| Product Category | Category of a Product | Identifies the category which this product belongs to. Product categories are used for pricing and selection. | M_Product_Category_ID
NUMBER(10) TableDir |
| Product | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | M_Product_ID
NUMBER(10) Search |
| Sales Region | Sales coverage region | The Sales Region indicates a specific area of sales coverage. | C_SalesRegion_ID
NUMBER(10) TableDir |
| Subtract Quantity | Quantity to subtract when generating commissions | The Quantity Subtract identifies the quantity to be subtracted before multiplication | QtySubtract
NUMBER 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. | QtyMultiplier
NUMBER Number |
| Subtract Amount | Subtract Amount for generating commissions | The Subtract Amount indicates the amount to subtract from the total amount prior to multiplication. | AmtSubtract
NUMBER 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. | AmtMultiplier
NUMBER 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. | IsPositiveOnly
CHAR(1) YesNo |
