ManPageW CommissionRun

From ADempiere ERP Wiki

Jump to: navigation, search

Return to Index

Enjoy it, and help to fill it! But please, always respecting copyright.

Please write your contributions under the Contributions Section



Contents

Window: Commission Run

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

Description : Commission run for a period

Help : Commission run for a period defined in the Commission window.

Table Name  : C_CommissionRun

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

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_<TableName>", where TableName is the actual name of the table (e.g. C_Order).

DocumentNo

NVARCHAR2(30)

String

Description Optional short description of the record A description is limited to 255 characters. Description

NVARCHAR2(255)

String

Start Date First effective day (inclusive) The Start Date indicates the first or starting date StartDate

DATE

Date

Grand Total Total amount of document The Grand Total displays the total amount including Tax and Freight in document currency GrandTotal

NUMBER

Amount

Create Invoice Create Invoice from Commission Calculation Processing

CHAR(1)

Button


Tab: Commission Amount

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.

Table Name  : C_CommissionAmt

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 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_CommissionRun_ID

NUMBER(10)

TableDir

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_CommissionLine_ID

NUMBER(10)

TableDir

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

Converted Amount Converted Amount The Converted Amount is the result of multiplying the Source Amount by the Conversion Rate for this target currency. ConvertedAmt

NUMBER

Amount

Actual Quantity The actual quantity The Actual Quantity indicates the quantity as referenced on a document. ActualQty

NUMBER

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. CommissionAmt

NUMBER

Amount


Tab: Commission Detail

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.

Table Name  : C_CommissionDetail

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 Amount Generated Commission Amount The Commission Amount indicates the resulting amount from a Commission Run. C_CommissionAmt_ID

NUMBER(10)

TableDir

Reference Reference for this record The Reference displays the source document number. Reference

NVARCHAR2(60)

String

Purchase Order Line Purchase Order Line The Purchase Order Line is a unique identifier for a line in an order. C_OrderLine_ID

NUMBER(10)

Search

Invoice Line Invoice Detail Line The Invoice Line uniquely identifies a single line of an Invoice. C_InvoiceLine_ID

NUMBER(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.

IsActive

CHAR(1)

YesNo

Info Information The Information displays data from the source document line. Info

NVARCHAR2(60)

String

Actual Amount The actual amount Actual amount indicates the agreed upon amount for a document. ActualAmt

NUMBER

Amount

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

Converted Amount Converted Amount The Converted Amount is the result of multiplying the Source Amount by the Conversion Rate for this target currency. ConvertedAmt

NUMBER

Amount

Actual Quantity The actual quantity The Actual Quantity indicates the quantity as referenced on a document. ActualQty

NUMBER

Number

Contributions

Personal tools