Setup a commisions payroll

[Guest]

I'm using access 2000.
I have a database that I use to place orders by customers. It has a query
that will show the "sum of total payments"
I want to pay employees a commision based on "sum of total payments" not the
total recieved. I am not sure what tables and forms ect; I need to creat to
get this done. I tried useing a Dlookup for the query "sum of total payments"
in a subform but couldn't get it to work so I'm thinking maybe I need to go
another route. I need to be able to show the current commision owed to
employee based on "
sum of total payment" query when I paid them and how much I paid them and
for what orders I paid them for.
Any suggestions would be greatly appreciated.
Thanks in advance

 

[Guest]

Dear Lisa,

Not clear what you have and what you have to do.
I believe that you need the following tables:
1) tbl_Customers
2) tbl_Employees
3) tbl_Invoices
Perhaps some more:
4) tbl_Products
5) tbl_ProductsInInvoice
In order to have may customers, employees, invoices and an invoice to
contain many products (is that correct)?
Then you can relate all above mentioned tables and have calculate the
commissions for each employee (the one which serve an invoice?)

George


Ο χÏήστης "lisaalvin41" έγγÏαψε:

 

[Guest]

I have all the tables you suggested and all works fine. Now what I need is to
be able to pay my reps their percentage of commision earned. I have a
payments query that shows the total of payments made on orders. I want to be
able to pay reps based on the percentage of payments the customer has made to
their order "Sum Of Payments Query.
I hope this helps.
Thanks for the reply

 

[Guest]

Again, not sure what you need to do.
I think that you can group rps and have also their total of payments. Is
that correct? And then you can use also the percentage to find out their
commission?
Not clear again, sorry

Ο χÏήστης "lisaalvin41" έγγÏαψε:

 

[Guest]

That's ok Thanks for the quick responce.
Here is the scenario,
I go to my customers form. I click on Orders and place an order.
I put in the percentage value for that order that my sales rep will recieve
" His % of commision per order" I finish the order and now in the subform of
my orders by custome subform the order amount Id Payment totals and all that
are located in the subform. In the subform it shows total payments maid to
each order. I need to pay my sales rep based on that "Total Payments"
Lets say A & W wholesale orders $2000.00
And has only paid $100.00, I can't pay the rep per $2000.0 because I have
not recieved payments for that just the $100.00 toward that account.
I hope this helps.

 

[Guest]

Well,
So, you need to group group your customers and your employees (because may a
customer is served by a different employee). Then you have to total the
payments for each customer/employee and find the total payments and total
commissions). Perhaps using some queries.
You can contact me at george_cyprusNoSpamathotmailNoSpam.com (remove all
NoSpam)

Ο χÏήστης "lisaalvin41" έγγÏαψε: