What is the procedure to set up and calculate commission on item sold?
What is the procedure to set up and calculate commission on item sold?
Are you using job costing?
If not, we use it to track commissions to sales reps.
We are not using job costing. The items are subject to commission and we have attached the sales representative on sales invoice. So we want the system to calculate 40% commission on the invoice. Is this possible?
Thank you for your response.
Not directly, but you can create your own Service class Item ID called Commission or something like that. Use .40 for the quantity, Commission for item ID, Total sale subject to commission on unit price and it will apply the commission amount to the invoice. If you use the job ID on the sale, it will track sale and commission paid to that sales rep.
Please I need more clarification on this. I didn't get it. I have created quantity discount and applied it to the item, but I can't see the commission in the report
You said " So we want the system to calculate 40% commission on the invoice."
So you don't want the commission on the physical invoice? You want to calculate commission on the sale on a report.
We want to collect the total invoice amount from the customer and we want the system to calculate 40% of the invoice amount as commission payable to the sales representative.
If you are looking for a report to do all of the work, you will need a business intelligence report. It is NOT built into Sage 50.
If you use job costing on each invoice line subject to commission, you can run a job costing report and calculate the commission yourself.
Each sales rep would have their own job ID. It would simply be placed on each line of the invoice where commission is due.
If you just want a standard 40% calculation across the board for all sales reps we can do this for you with a Sage Intelligence report without doing anything with job costing. As long as you enter the sales rep for each invoice you can run a report by date range that will calculate the sales and sales commission by sales rep for that time period. Feel free to give us a call at 1-800-339-8224 to discuss the details.
Thanks so much
*Community Hub is the new name for Sage City