Window: Commission Run
[Created: 31/03/2001 - Updated: 02/01/2000 ]
Description: Check and modify Commissions
Help: The Commission Run Window displays the results of processing commissions. When the Generate Commission process is selected from the Commissions Window, the results are displayed here. If the result is satisfactory, generate an AP invoice to pay the commission.
Tab: Commission Run
[Created: 31/03/2001 - Updated: 02/01/2000 ]
Description: Commission run for a period
Help: Commission run for a period defined in the Commission window.
Tab Level: 0
Table 10: Commission Run - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | c_commissionrun.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_commissionrun.AD_Org_ID numeric(10) Table Direct |
| Commission | Commission | The Commission Rules or internal or external company agents, sales reps or vendors. | c_commissionrun.C_Commission_ID numeric(10) Table Direct |
| Document No | Document sequence number of the document | The document number is usually automatically generated by the system and determined by the document type of the document. If the document is not saved, the preliminary number is displayed in "".If the document type of your document has no automatic document sequence defined, the field is empty if you create a new document. This is for documents which usually have an external number (like vendor invoice). If you leave the field empty, the system will generate a document number for you. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_", where TableName is the actual name of the table (e.g. C_Order). | c_commissionrun.DocumentNo character varying(30) String |
| Description | Optional short description of the record | A description is limited to 255 characters. | c_commissionrun.Description character varying(255) String |
| Start Date | First effective day (inclusive) | The Start Date indicates the first or starting date | c_commissionrun.StartDate timestamp without time zone Date |
| Grand Total | Total amount of document | The Grand Total displays the total amount including Tax and Freight in document currency | c_commissionrun.GrandTotal numeric Amount |
| Create Invoice | Create Invoice from Commission Calculation | c_commissionrun.Processing character(1) Button | |
| Invoice | Invoice Identifier | The Invoice Document. | c_commissionrun.C_Invoice_ID numeric(10) Search |
| Processed | The document has been processed | The Processed checkbox indicates that a document has been processed. | c_commissionrun.Processed character(1) Yes-No |
Tab: Commission Amount
[Created: 31/03/2001 - Updated: 02/01/2000 ]
Description: Commission line amounts
Help: For each commission line, a line is generated. You can overwrite the amount and quantity to modify the commission amount, but the suggested way is creating additional Commission Detail lines. Please be aware that manual changes will not reconcile with the Commission Details.
Tab Level: 1
Table 20: Commission Amount - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | c_commissionamt.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_commissionamt.AD_Org_ID numeric(10) Table Direct |
| Commission Run | Commission Run or Process | The Commission Run is a unique system defined identifier of a specific run of commission. When a Commission is processed on the Commission Screen, the Commission Run will display. | c_commissionamt.C_CommissionRun_ID numeric(10) Search |
| Commission Line | Commission Line | The Commission Line is a unique instance of a Commission Run. If the commission run was done in summary mode then there will be a single line representing the selected documents totals. If the commission run was done in detail mode then each document that was included in the run will have its own commission line. | c_commissionamt.C_CommissionLine_ID numeric(10) Table Direct |
| 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_commissionamt.IsActive character(1) Yes-No |
| Converted Amount | Converted Amount | The Converted Amount is the result of multiplying the Source Amount by the Conversion Rate for this target currency. | c_commissionamt.ConvertedAmt numeric Amount |
| Actual Quantity | The actual quantity | The Actual Quantity indicates the quantity as referenced on a document. | c_commissionamt.ActualQty numeric Quantity |
| Commission Amount | Commission Amount | The Commission Amount is the total calculated commission. It is based on the parameters as defined for this Commission Run. | c_commissionamt.CommissionAmt numeric Amount |
Tab: Commission Detail
[Created: 09/04/2001 - Updated: 02/01/2000 ]
Description: Commission Detail Information
Help: You may alter the amount and quantity of the detail records, but the suggested way is to add new correcting lines.The amounts are converted from the transaction currency to the Commission Currency (defined in the Commission window) using the start date and the spot exchange rate.
Tab Level: 2
Table 30: Commission Detail - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | c_commissiondetail.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_commissiondetail.AD_Org_ID numeric(10) Table Direct |
| Commission Amount | Generated Commission Amount | The Commission Amount indicates the resulting amount from a Commission Run. | c_commissiondetail.C_CommissionAmt_ID numeric(10) Search |
| Reference | Reference for this record | The Reference displays the source document number. | c_commissiondetail.Reference character varying(60) String |
| Purchase Order Line | Purchase Order Line | The Purchase Order Line is a unique identifier for a line in an order. | c_commissiondetail.C_OrderLine_ID numeric(10) Search |
| Invoice Line | Invoice Detail Line | The Invoice Line uniquely identifies a single line of an Invoice. | c_commissiondetail.C_InvoiceLine_ID numeric(10) Search |
| 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_commissiondetail.IsActive character(1) Yes-No |
| Info | Information | The Information displays data from the source document line. | c_commissiondetail.Info character varying(60) String |
| Actual Amount | The actual amount | Actual amount indicates the agreed upon amount for a document. | c_commissiondetail.ActualAmt numeric Amount |
| Currency | The Currency for this record | Indicates the Currency to be used when processing or reporting on this record | c_commissiondetail.C_Currency_ID numeric(10) Table Direct |
| Converted Amount | Converted Amount | The Converted Amount is the result of multiplying the Source Amount by the Conversion Rate for this target currency. | c_commissiondetail.ConvertedAmt numeric Amount |
| Actual Quantity | The actual quantity | The Actual Quantity indicates the quantity as referenced on a document. | c_commissiondetail.ActualQty numeric Number |