Time Clock: Linked to SambaPOS Users with Custom Reports

[QMcKay]

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).

@QMcKay

CUSTOM REPORTS using SQL for Hours and Wages

@QMcKay

Wages:
The big caveat with this is How do you calculate Pay?

From:

Time Clock - Basic - Employee Entities (not users)

Basic TimeClock implementation using Employee Entities (not Users) and 2 Entity States called PunchIn and PunchOut. REQUIRED: SambaPOS v4.1.65 + REQUIRED: Custom Report Module from SambaMarket.com Database Tools Import Files: Automation (Automation Commands, Actions, Rules): TimeClock_Automation.zip (2.1 KB) Entity Type, Entity Screen, States TimeClock_EntityType_EntityScreen_States.zip (1.5 KB) FLOW: Button to show TimeClock screen: [image] TimeClock screen with 4 Employee Entities: …