If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sales Commission
Dear Friends:
I want to update my database and for that I interest to include a sales commission report There are the following criteria: Comm for Comm for Designation Primary Target Target Fulfillment Non-fulfillment Trainee Sales Executive 2000000 375 330 Sales Executive 2500000 390 375 Senior Seals Executive 3500000 450 390 Under the above criteria, if any sales officer achieve his/her target then he avail target fulfillment commission rate per 100000. For example, Mr. X is a Sales Executive and achieves 4,500,000 for the December, 2009, so he avail Tk 390 per 100,000 and commission will be 4,500,000/100,000*390= Tk. 17,550. Pls answer me as soon as possible and it will be better, if you give me a Demo database to solve this problem. My e-mail address: Thanks Nur Muhammad |
#2
|
|||
|
|||
Sales Commission
On Feb 15, 12:17*am, Nur Muhammad
wrote: Dear Friends: I want to update my database and for that I interest to include a sales commission report There are the following criteria: * * * * * * * * * * * * * * * * * * * * * * * * * Comm for * * * Comm for Designation * * * * * * * * * * * *Primary Target * * * Target Fulfillment * * Non-fulfillment Trainee Sales Executive 2000000 * * 375 * * * * 330 Sales Executive * * * * 2500000 * * 390 * * * * * * * * * * * * 375 Senior Seals Executive *3500000 * * 450 * * * * 390 Under the above criteria, if any sales officer achieve his/her target then he avail target fulfillment commission rate per 100000. For example, Mr. X is a Sales Executive and achieves 4,500,000 for the December, 2009, so he avail Tk 390 per 100,000 and commission will be 4,500,000/100,000*390= Tk. 17,550. Pls answer me as soon as possible and it will be better, if you give me a Demo database to solve this problem. My e-mail address: Thanks Nur Muhammad * * * * * * * * * * Oh please. If you want someone to do the work for you PAY FOR IT. What's the matter, not smart enough to figure out a simple IIF statement? |
#3
|
|||
|
|||
Sales Commission
Withought knowing the structure of your data tables, this is extremely
difficult, so why don't you post the names of the tables, the fields you think are appropriate, and what you already have. I would suspect you would have an Employees table, a Sales table, and this SalesCommissions table, as a minimum. I would probably also have an EmployeeHistory table(or something like that), which contains EmpID, their designation (Trainee, Sales Exec, Senior Sales Exec, ...), and the date of that designation. I would probably start out with an query (qryMonthlySales), which would give me the total sales for each employee, by month. This query would include the EmpID, SalesYear, SalesMonth, as TotSales. I would then use that query, along with the EmployeeHistory table and the SalesCommission table to determine the commission for each employee. By including the EmployeeHistory table, you can the Sales query to the History table to determine what their designation was in any given month, and then use the appropriate commission rate from the SalesCommission table. HTH Dale "Nur Muhammad" wrote in message ... Dear Friends: I want to update my database and for that I interest to include a sales commission report There are the following criteria: Comm for Comm for Designation Primary Target Target Fulfillment Non-fulfillment Trainee Sales Executive 2000000 375 330 Sales Executive 2500000 390 375 Senior Seals Executive 3500000 450 390 Under the above criteria, if any sales officer achieve his/her target then he avail target fulfillment commission rate per 100000. For example, Mr. X is a Sales Executive and achieves 4,500,000 for the December, 2009, so he avail Tk 390 per 100,000 and commission will be 4,500,000/100,000*390= Tk. 17,550. Pls answer me as soon as possible and it will be better, if you give me a Demo database to solve this problem. My e-mail address: Thanks Nur Muhammad |
Thread Tools | |
Display Modes | |
|
|