Sorry let me explain, I converted the report to a Table as you can see above. I enabled the ShowTotalSummary as you can see. I saved the layout by right click and choosing save. I logged out and logged back in just to be sure it saved… IT did save it. I chose edit report and changed the name of the report from Jesse Detail Wages Report to Melissa Detail Wages Report and all of the View Editor settings disappeared and reset. I had to right click the Cells and enable ShowTotalSummary again and reset all my customizations to the TotalSummary row.
I have a feeling its probably something similar to why I couldn’t Save colors in the Pivot table… but I thought I would ask.
@Jesse What do you mean when you say “production system”?
I’m sorry, my English is very basic.
I feel that it works great,
i whish time clock calculates the number of hours and hourly rate changes accordingly? To calculate overtime
For example: up to 8 hours he get 100% of his pay rate
From 9 to 11 hours he get 125% of his pay rate from 12 and beyond he get 150% of his pay rate
Also need to change pay rate depending on holidays,I guess you could use a trigger to set Dates and times that we define in advance to change pay rate to a holidays rate.
I’m doing what you mention using Custom Reports, SQL and a Stored Program Setting for Holidays. There are a couple examples contained in the Tutorial, but they need updating to more current code. I can spend some time tomorrow updating the code in the Tutorial if you’re interested. EDIT: the code has now been updated in the Tutorial.
My Production System with 4 Employees uses a combination of 9 Reports (4 Hour Reports - one for each Employee, 4 Pay Reports - one for each Employee, 1 Overall Payroll Report - contains Pay Amounts for all 4 Employees) and 11 SQL Scripts (all dynamic, not Employee-based, so no requirement to add more SQL for more or less Employees).
if i buy the database tool module i can import ur setting? does that overwrite my current menu and other setting like the kitchen display etc? ie i need to set everything else again?
@superlik database tools module useful to import / export database configurations and adds some other useful features as featured here How to use Database Tools Module
Some restaurant owners like you shares their configurations to help other users for setting up their systems and they mostly prefer database tools as it allows merging configurations easily. Of course it intended to work without changing your current configuration but nobody can guarantee that will just work without issues as everybody’s setup is different. So create backups in advance and make such imports on training mode to ensure it works fine with your configuration.
Alternatively you can follow tutorials to learn how it works and implement your own solution perfectly customized for your needs. This is always the best choice.
i tried to follow step to step guide, but my basic not strong and really need a step to step guide to set it up. I will buy the database tool and give it a go.
thanks for this brilliant community, great to see that sambapos getting better every single day
That means you’ll create a separate Employee entity for each user you have. Entity names should match to user names. You should also set pin numbers for entities.
I did not include sample Entities I included sample reports for you to edit to your liking. You need to create the entities as they would be unique to your business. Edit the names in the sample reports to match the entities as I described in the tutorial.
