The Enhanced Sage 300 Report

Hello everyone!

Following our previous post about Statutory Work Days, we have an update that incorporates this new feature in a report. We call it the "Enhanced Sage 300 Report", as it's based on the original Sage 300 Report.

Whenever an employee works on a Statutory Holiday, this report will add an extra line of hours to match the hours set up for each one of the profiles, stated in the PROJECT column.

In the case that there were holidays, the system will add an additional line showing the holiday hours and include "HOL" in the PROJECT column. Note that this is used specifically for the times when there is a statutory holiday that the employee did not work, but still needs to be paid for.

Finally, when there is overtime, the pay rate to will be adjusted to 1 1/2 the pay rate value, to make things easier for the staff in charge of payroll. An additional line will be created to make the overtime easier to visualize along with its new fixed pay rate.

Here is a sample of what the report would look like on a regular week:

Click on image to enlarge

On this example we see that April 11th and 12th have the usual 8 hours with its pay rate of 26.50, but when we come to the 13th and 14th, an additional line has been added to signify the overtime with its updated pay rate of 39.75. Also, we have a paid Holiday on the 15th, which at the same time is a Statutory Holiday that this employee worked on, as noted in the "PROJECT" column by "HOL" and "STAT" respectively.

Additionally, if you have configured Auto Break Deduction, the report will deduct the specified amount of time of the last task on the day. For example, we have user "Bowen Thompson" who needs to have 30 minutes deducted from the total hours. If we first check the Timecard Task Detail Report, we can see that the last task he worked on the 27th there were 2 hours registered. Also, the next day shows a total of 13 hours worked in one individual job:

Click on image to enlarge

If we generate the Enhanced Sage 300 Report, we will see that 30 minutes have been deducted from that last task of the day on both cases, providing the desired timesheet calculation as follows:

Let us know if you have any questions or comments down below, and until next time!

--Econz Team