Hi guys, this pos is getting better by the day.
My sister's shop is going to start paying the staff with basic pay and commission. As the POS is already showing the employee sale by end of the day, I was hoping to write something to extract the sale of the employee over a month period.
The reason why I need to do that was because some items are not commission base but rather a service by another department.
The question is what is a good way to extract the sale done with each employer and which files would be it!
Thank you
Edmund
Employee Sale Data
Moderators:daleadmin, Dale Harris, Alan, Andrew
- Dale Harris
- Forum Owner
- Posts:1171
- Joined:Sun Dec 28, 2003 10:19 pm
- Location:Chicago
- Contact:
Employee Sale Data
edseah,
I am not sure what you mean by "a service by another department?"
Is all the stuff for each different department entered into the stock table using different categories or vendors for each department? If so you can use the "Reports" feature to print a merchandise report for each employee sorted by either category or vendor. You will then find out how much stuff Amy sold for vendor #1 and how much for vendor#2 and so on. Then print out the report for Doug, then Harold, then Ramone, etc.
At the close of the register it will ask you if you wish to reset the merchandise data. If you only reset the data once a month then just before you reset it, you will be able to print a sales report for that past month. Just make REAL SURE that you have printed out the final report for that month before you reset the merchandise data for the next month.
I am not sure what you mean by "a service by another department?"
Is all the stuff for each different department entered into the stock table using different categories or vendors for each department? If so you can use the "Reports" feature to print a merchandise report for each employee sorted by either category or vendor. You will then find out how much stuff Amy sold for vendor #1 and how much for vendor#2 and so on. Then print out the report for Doug, then Harold, then Ramone, etc.
At the close of the register it will ask you if you wish to reset the merchandise data. If you only reset the data once a month then just before you reset it, you will be able to print a sales report for that past month. Just make REAL SURE that you have printed out the final report for that month before you reset the merchandise data for the next month.
Dale
Who is online
Users browsing this forum: No registered users and 196 guests