View Single Post
Old 08-11-2006, 12:13 PM   #2 (permalink)
Andy
 
Andy's Avatar
 
Join Date: Jan 25 2000
Location: CT
Posts: 1,760
Rep Power: 9 Andy has a spectacular aura aboutAndy has a spectacular aura about
Re: Helios Commission Report Help

regarding commission from Employee Data ... which I personally NEVER recommend anyone use.

firstly ... only 1 rate will apply to a transaction ... that being the rate applicable to the sale going into the transaction. So at the start of a commission cycle if they sale a $60 item, 5% will apply to that entire sale. Second example, if they have already sold $95. (therefore currently qualify for 10% and now sell a $40 item ... 10% applies to that entire sale because that is the rate that applies going into the sale (being at $95.) not just on the $5 but the whole $40. ... TOTALLY UNWORKABLE ... I am not saying it makes any sense, just telling you the way it is.

secondly ... commission is not calculated retroactively, commission will only be calculated on sales processed AFTER the employee commission was enabled. Commission is not calculated at time of reporting (which would be logical), it is calculated on each sale transaction and stored in the transaction. WHen you run a commission report it calculates nothing, it just reports the commission stored in each transaction.

thirdly ... using Employee Data commission you do not have to re input the % after each payroll ... BUT ... you do have to "INITIALIZE" Employee at the start of each commission cycle. That function is in the Management drop down menu list. They are right the ranges should be set with the applicable % to be paid UP TO the amount entered. So the last range must have a value that no employee would ever reach in a commission cycle so all sales in that cycle are subject to commission.

SO ... what you want to do will never get done properly using Employee Data Commission ...

BUT, much simplier approach to accomplish exactly what you want. Now that I have written a mini novel regarding Employee Data Commission now please ....

FORGET EMPLOYEE DATA ... take the tick off that Commission option in your sales codes ... set on the Sales Code itself a RATE of 5% on all applicable sales code

Then on the desired frequency take off the commission report, it will show Sales Volume and Commission at 5% ... if they have meet the required sales volume for the second level ... double the commission, thus 10% ... if they have meet the required sales volume for the third level ... triple the commission, thus 15%.

Personal obversation ... your level values are too low ... IMHO, employee should have to sell more than $50. to get 10% ... but that is 100% your call ...

Hope this helps ...
__________________
Andy Thompson
andy@tommyk.com
Andy is online now   Reply With Quote