Measures

Salesperson Commission Earned is the total amount of commission that the salesperson is to receive to date. It is from the Salesperson Commission Earned field of commission due form.

Salesperson Commission Earned = commdue_mst.comm_due (reference where slsman = salesperson)

Salesperson Comission Paid is the total amount of commission already paid to the salesperson by due date. It is from the Salesperson Commission Paid field of commission due form.

Salesperson Commission Paid = commdue_mst.comm_paid (reference where slsman = salesperson)

Unpaid Salesperson Commission is the total amount of commission to be paid to the salesperson by due date. It is calculated from salesperson commission earned minus salesperson commission paid.

Unpaid Salesperson Commission = salesperson commission earned – salesperson commission paid

Manager Commission Earned is the total amount of commission that the sales manager is to receive to date. It is from the Sales Manager Commission Earned field of commission due form.

Manager Commission Earned = commdue_mst.comm_due (reference where mgrcomm2.slsman = commdue.slsmangr

mgrcomm2.seq = commdue.seq AND mgrcomm2.inv_num = commdue.inv_num)

Manager Commission Paid is the total amount of commission already paid to the sales manager by due date. It is from the Sales Manager Commission Paid field of commission due form.

Manager Commission Paid = commdue_mst.comm_paid (reference where mgrcomm2.slsman = commdue.slsmangr

mgrcomm2.seq = commdue.seq AND mgrcomm2.inv_num = commdue.inv_num)

Unpaid Manager Commission is the total amount of commission to be paid to the sales manager by due date. It is calculated from manager commission earned minus manager commission paid.

Unpaid Manager Commission = manager commission earned – manager commission paid

Invoice Total is the total invoice amount, excluding tax, of the invoice from which the salesperson commissions are calculated. It is from the Invoice Commission Base field of commission due form.

Invoice Total = commdue_mst.comm_base (reference where slsman = salesperson)

Salesperson Commission % is the salesperson commission earned accounts for the percentage of total invoice amount. It is a rule measure.

Salesperson Commission % = salesperson commission earned / invoice total *100

Manager Commission % is the sales manager commission earned accounts for the percentage of total invoice amount. It is a rule measure.

Manager Commission % = manager commission earned / invoice total *100