This report was written to the specifications of one client.
It breaks down the "value" of the booking dispatcher, account rep and commission agent, based on the values entered into the screen against the
profit on the load. The values are calculated for ONE of each type. If
you have more than one commission agent or booking dispatcher, the report
will not work.
The booking dispatcher is found on the booking screen within load create/
edit. The account rep is the field entitled dispatcher on the customer
profile, general info tab.
The commission agent is on the commission tab in customer profile.
Example: I have a load with a $500.00 net profit. I determine that my
booking dispatcher has a value to me of 50% of my profit.
My account rep has a value to me of 25% and my commission agent has a
value to me of 25%.
My report will reflect a value of 250.00 to my booking dispatcher, 125.00
to my account rep and 125.00 to my commission agent. If this were my only
load invoiced today, of my $500.00 profit, by viewing my report, my booking dispatcher earned my company $250.00, my account rep earned my company
$125.00 and my commission agent earned my company $125.00.
This client does not create commission rate records within the load. They
do not utilize additional payables or have more than one of each personnel
per load. If any of the aforementioned rates are in your load, the report may not work to your specifications