MS Hour fills the critical gap in Microsoft Business Central — a fully native, cloud-first attendance & time tracking platform with deep BC integration, Dataverse sync, mobile GPS clock-in, and AI-powered reports.
Business Central Native Integration Dataverse Tables Sync Azure Functions Middleware GPS Clock-In Verification Real-Time Attendance Tracking Project & Task Time Logging Payroll-Ready Timesheets Mobile iOS & Android Power BI Reports Shift Scheduling Overtime Management Leave & Absence Module
Business Central Native Integration Dataverse Tables Sync Azure Functions Middleware GPS Clock-In Verification Real-Time Attendance Tracking Project & Task Time Logging Payroll-Ready Timesheets Mobile iOS & Android Power BI Reports Shift Scheduling Overtime Management Leave & Absence Module
A complete HR & attendance platform purpose-built for Microsoft Dynamics 365 Business Central ecosystems.
Mobile, web, and biometric clock-in with GPS coordinates. Supports QR codes, facial recognition, and NFC badges synced to BC time entries.
Real-time dashboard showing all employees' check-in status, branch filters, admin override, and interactive map view of locations.
Full monthly attendance grids per employee with day-type classification, overtime, and payroll export direct to BC journal lines.
Sync BC Jobs, Project Tasks, and Line Items directly. Log time per task — data flows back to BC as Time Registration Entries automatically.
Build rotating shifts, night shifts, and flexible schedules. Assign to teams or branches. Auto-detect night shift spanning midnight.
Full leave management with approval workflows. Types: Annual, Sick, Emergency, Unpaid. Syncs to BC absence codes with mobile approvals.
Generate payslips from time data. Compute salary components, overtime pay, deductions. Post directly to BC payroll journal. GDPR-compliant.
Power BI embedded dashboards, productivity scores, late arrival trends, department-wise summaries, and custom report builder with export.
Granular RBAC per module. Admin, Manager, HR, Employee roles. Aligns with BC user permission sets and Dataverse security roles.
Click through tabs to explore real data tables and simulate app interactions.
| Employee | Dept | Check In | Check Out | Hours | BC Project | Status | GPS | Actions |
|---|
| Employee | Regular Hrs | OT Hours | Leave Days | Absences | Project Hrs | BC Job | Approval | Action |
|---|---|---|---|---|---|---|---|---|
| Sarah Ahmad | 168.0h | 12.5h | 2 | 0 | 45.0h | J-0021 | ✓ Approved | |
| John Davis | 156.0h | 0.0h | 4 | 1 | 32.5h | J-0018 | Pending | |
| Mohammed K. | 172.5h | 20.0h | 0 | 0 | 88.0h | J-0021 | ✓ Approved | |
| Linda Park | 144.0h | 0.0h | 8 | 0 | 12.0h | J-0019 | Rejected | |
| Carlos M. | 168.0h | 8.0h | 2 | 0 | 56.5h | J-0022 | ✓ Approved | |
| Aisha R. | 160.0h | 4.0h | 3 | 1 | 28.0h | J-0020 | Pending |
| BC Job No. | Project Name | Task | Assigned To | Budget Hrs | Logged Hrs | Remaining | Status | BC Sync |
|---|---|---|---|---|---|---|---|---|
| J-0018 | Azure Migration | Task 1000 — Discovery | John Davis | 120h | 82.5h | 37.5h | In Progress | ✓ Synced |
| J-0019 | BC Implementation | Task 2000 — Setup | Linda Park | 200h | 168.0h | 32.0h | Review | ✓ Synced |
| J-0020 | Payroll Rollout | Task 1000 — Config | Aisha R. | 80h | 28.0h | 52.0h | In Progress | ✓ Synced |
| J-0021 | MS Hour Integration | Task 3000 — API Dev | Sarah Ahmad | 150h | 133.0h | 17.0h | Testing | ✓ Synced |
| J-0022 | CRM Extension | Task 1000 — Analysis | Carlos M. | 100h | 56.5h | 43.5h | In Progress | ✓ Synced |
| J-0023 | D365 FO Upgrade | Task 1000 — Planning | Mohammed K. | 300h | 88.0h | 212.0h | Planning | Pending |
| Employee | Leave Type | From | To | Days | BC Absence Code | Approver | Status | Actions |
|---|---|---|---|---|---|---|---|---|
| Sarah Ahmad | Annual Leave | Jun 10 | Jun 11 | 2 | VACATION | HR Manager | ✓ Approved | |
| John Davis | Sick Leave | Jun 16 | Jun 19 | 4 | SICK | Sarah Ahmad | Pending | |
| Linda Park | Emergency Leave | Jun 5 | Jun 12 | 8 | EMERGENCY | HR Director | Rejected | |
| Carlos M. | Annual Leave | Jun 24 | Jun 25 | 2 | VACATION | Sarah Ahmad | ✓ Approved | |
| Aisha R. | Unpaid Leave | Jun 20 | Jun 20 | 1 | UNPAID | HR Manager | Pending |
Real-time check-in log
Payroll-ready export
OT hours & cost
BC job time analysis
Balance & usage
Location verification
Explore the actual mobile and web screens of MS Hour in action.
| Employee | Check In | Status |
|---|---|---|
| Sarah Ahmad | 08:55 AM | ✓ In |
| Mohammed K. | 08:48 AM | ✓ In |
| John Davis | 09:18 AM | Late |
| Linda Park | — | Leave |
| Employee | ID | Department | Shift | Check In | Check Out | Hours | BC Project | GPS | Status |
|---|---|---|---|---|---|---|---|---|---|
| Sarah Ahmad | EMP-001 | Engineering | 08:00–17:00 | 08:55 AM | — | — | J-0021 | 📍 Verified | Present |
| Mohammed K. | EMP-002 | Engineering | 08:00–17:00 | 08:48 AM | — | — | J-0021 | 📍 Verified | Present |
| John Davis | EMP-003 | Finance | 08:00–17:00 | 09:18 AM | — | — | J-0018 | 📍 Verified | Late |
| Linda Park | EMP-004 | HR | 08:00–17:00 | — | — | — | — | — | On Leave |
| Carlos M. | EMP-005 | Sales | 09:00–18:00 | 08:52 AM | — | — | J-0022 | 📍 Verified | Present |
| Aisha R. | EMP-006 | Operations | 08:00–17:00 | 09:01 AM | — | — | J-0020 | 📍 Verified | Present |
Every MS Hour module maps to a verified BC API v2.0 endpoint, with Dataverse as the unified data layer.
| MS Hour Module | BC API Endpoint (v2.0) | Method | Dataverse Table | Sync Type | Azure Service | Status |
|---|---|---|---|---|---|---|
| 👤 Employee Master | /companies({id})/employees | GET | cdm_worker | Batch Daily | Azure Data Factory | ✓ Live |
| ⏱ Attendance / Time Reg. | /employees({id})/timeRegistrationEntries | POST/GET | ms_attendance | Real-time | Azure Functions | ✓ Live |
| 🏗 BC Projects (Jobs) | /companies({id})/projects | GET | cdm_project | Hourly Sync | Logic Apps | ✓ Live |
| 📋 Project Task Lines | /projects({id})/projectTaskLines | GET | cdm_task | Hourly Sync | Logic Apps | ✓ Live |
| 🏖 Leave / Absence | /employees({id})/employeeAbsences | POST/GET | ms_leave | Event-driven | Service Bus + Fn | ✓ Live |
| 💰 Payroll Journal | /companies({id})/journalLines | POST | ms_payrollentry | On-demand | Azure Functions | Beta |
| 🏢 Companies / Branches | /companies | GET | cdm_company | Batch Daily | API Management | ✓ Live |
| 📊 Dimensions (Cost Centers) | /companies({id})/dimensions | GET | ms_dimension | Batch Daily | Data Factory | Planned |
| 📦 Custom MS Hour API (AL) | /api/mshour/hr/v1.0/.../msAttendance | GET/POST | ms_attendance | Real-time | BC AL Extension | ✓ Live |
Built on Microsoft Azure — fully managed, secure, scalable middleware connecting MS Hour to D365 BC and Dataverse.
All API calls authenticated via Microsoft Entra ID (Azure AD) with OAuth 2.0 Client Credentials flow. JWT validation at APIM gateway.
Azure Functions (.NET 8 Isolated) handle transformation, business rules, BC webhook processing, and async queuing via Service Bus.
Dataverse as unified HR data store with custom ms_attendance, ms_leave, ms_shift, ms_timesheet tables. BC data via Virtual Tables.
Power BI Embedded for real-time dashboards. Application Insights for API telemetry. Azure Monitor for alerts and SLA tracking.
Register app in Microsoft Entra ID. Configure BC API access. Validate OAuth 2.0 token flow.
Create custom Dataverse tables: ms_attendance, ms_shift, ms_leave, ms_timesheet, ms_overtime.
Azure Functions for BC↔Dataverse transformation. Service Bus for async. Durable Functions for approvals.
Configure real-time, batch, and event-driven sync. Full integration testing with BC sandbox.
Deploy to production Azure with App Insights, Power BI dashboards, and 24/7 alert monitoring.
All plans include full BC API integration. No extra BC licensing fees.
"MS Hour solved our biggest BC gap — attendance was completely missing. Now our time entries sync directly to BC jobs and payroll is automated. Game changer for our 200-person team."
"The BC API integration is rock solid. Our project managers love that time logged in MS Hour appears instantly in BC Time Registration Entries. No double entry anymore."
"We evaluated 5 solutions. Only MS Hour had genuine Dataverse integration with Azure Functions middleware. The GPS verification gave our clients full confidence in field time reporting."
Deploy MS Hour in your Business Central environment in under 2 hours. No BC license changes needed.
Have questions about integrating MS Hour with your Dynamics 365 BC environment? We're here to help.
We'll respond within 1 business hour.
Online · Avg reply < 1 min
Get full access to MS Hour with your Business Central environment — no credit card needed.