Use Company Control F/M to setup the proper prioritization of the contract price’s commission % and to set the commission flag for use highest/lowest/priority commission.
As a line is being entered/edited in the Sales Order module, the default commission % values for customer, salesperson, item, and price are saved and used in the commission calculation processing detailed below.
Processing details
Throughout FACTS, commission percentage processing is as follows when the price selected has a commission % assigned:
There are five commission percent sources: customer, salesperson, item, price and current line commission. The system maintains a user override flag and a price type to designate if the user overrode the line’s commission during order entry.
When calculating commissions, the system first checks the value of the Commission Flag. If the Commission Flag is set to H- always choose the Highest commission in the hierarchy, the system returns the highest commission %, excluding the line’s commission %, after replacing the item’s commission with the price’s commission if necessary. If the Commission flag is set to "L- always choose the Lowest commission in the hierarchy", it returns the lowest, non-blank, commission %, excluding the line’s commission %, after replacing the item’s commission with the price’s commission if necessary.
If the value of the Commission Flag is set to X-calculate (always choose the commission that the hierarchy determines), the system checks the Commission Basis for the first priority to determine which commission percentage to use. As the system navigates the priority string, it returns the first entry that has a commission other than "No Priority" (or blank) as the correct commission %.
For example: If the commission hierarchy is set to SCIP the system would calculate the commission using the percentage assigned to the salesman who sold the merchandise. If no priority is assigned to the salesman, the second priority is checked. The system would then calculate the commission using the percentage assigned to the customer the merchandise was sold to. If no priority is assigned to the customer, the third priority is checked. The system would then calculate the commission using the percentage assigned to the item that was sold.
If the price type is not a contract price, the position of the Price’s Commission % in the hierarchy will be ignored, and if a Price Commission is present, it will replace the Item’s Commission % (regardless of whether the Item’s Commission was "No Priority").
If the user override flag is set for the line-item during order entry processing, the system returns the Line’s Commission as the correct commission %.