Commission calculation based on employee contribution

The user can calculate the commission payable to employees for every invoice based on the contribution percentage of employees.

• Create transactions saved search

Go to Lists > Search > Saved Searches > New

• Select type as Transactions

• Set the title of your saved search (e.g. “Commission Calculation by Employee Contribution“).

• In the Criteria tab, add the following filters:

1. Type: Invoice
2. Main Line: true
3. Status: Paid in Full (or any other status that applies to your use case)

• In the Results tab, add the following columns:

Employee: Name or ID for identifying the employee

Total (Transaction): This will give you the total amount of the invoice.

Commission Calculation: Formula :

(NVL({amount},0)-NVL({quantity}*{custcol_aha_sales_invoice_cost},0)+NVL({quantity}*{custcol_nsts_rm_purchase_rebate},0))*((NVL({amount},0)-NVL({quantity}*{custcol_aha_sales_invoice_cost},0)+NVL({quantity}*{custcol_nsts_rm_purchase_rebate},0))/NULLIF(NVL({amount},0),0)) 

Clicj Save and Run.