Sunday, March 3, 2019

Show Commission Rate Used in Commission Calculation on Commission Reports

Currently there is no standard commission rate field to show the rate used in the commission calculation on reports. In commission report the calculated amount is based on the commission % multiplied by the transaction base. To show the commission % used in the report,

1. Go to Reports > CommissionCommission Overview Report > Customize


2. Click on Edit Columns


3. Click Add Formula Field


4. On Formula Column, set the following fields:


Formula Type = Percent Ratio (x/y)*100


x = Calculated Amount


y= Transaction Base Amount


5. Rename and Save and run the report




No comments:

Post a Comment