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:
- Type: Invoice
- Main Line: true
- 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.