Skip to content
Shop Floor Insight app iconShop Floor InsightReporting

Shop Floor Labor Reporting and Analysis for Microsoft Dynamics 365 Business Central

Labor data that sits on paper, or in a separate time system, cannot answer the questions a plant manager asks: where did the hours go, which orders overran, how much was rework. Shop Floor Insight records every activity as a time card line in Business Central, and those lines can be analyzed by order, employee, work center, or activity.

The analysis runs in Business Central's analysis mode, in Excel, or in Power BI.

How Shop floor labor reporting works in Shop Floor Insight

  1. Operators record time, rework, and non-productive activities at the terminals.
  2. Each activity becomes a time card line in Business Central.
  3. Supervisors approve and post the time cards.
  4. Analysts open the time card lines in analysis mode, Excel, or Power BI.
  5. They pivot by order, employee, work center, or activity to answer the question at hand.

Key capabilities

One table to analyze

Almost all Shop Floor Insight data comes from one place, the time card lines, in posted and unposted versions. Any tool that reads Business Central data can use it.

Analysis mode in Business Central

Business Central's analysis mode pivots time card lines by production order, by employee, by work center for equipment use, or by activity code to break rework down by root cause.

Excel and Power BI

The same lines can be analyzed in Excel or Power BI for key performance indicators, productivity, and labor cost.

Ready-made reports

Reports include Daily Time Entries, which lists each employee's activities for a work date, and the Bi-weekly Time Report for a pay period.

Actual against expected

Captured times can be compared with expected times to check performance and costing. Routing Analysis and Production Order Analysis are Insight Works apps that analyze these actual times against routings and costs.

See Shop floor labor reporting on screen

Real screens from Shop Floor Insight, shown with demo data.

Details that matter on the floor

Questions you could not ask before

Because rework and non-productive time are coded at the source, the analysis can show hours by root cause or by non-productive code, not only by order.

No separate reporting database

The data is already in Business Central, so standard analysis tools work without an export step.

Who uses Shop floor labor reporting

Production managers

Review labor by order and work center to find overruns.

Continuous improvement specialists

Break rework and non-productive hours down by cause.

Finance managers

Analyze labor cost and payroll spend.

Questions about Shop floor labor reporting

How can I report on shop floor labor in Business Central?

With Shop Floor Insight, every activity is a time card line in Business Central. Analyze those lines by production order, employee, work center, or activity in Business Central's analysis mode, Excel, or Power BI.

Can we see rework hours by cause?

Yes. Pivot the time card lines by activity and root cause code. See rework time with root cause.

Is there a Power BI report?

Time card lines can be analyzed in Power BI with your own reports.

Which reports are included?

Reports include Daily Time Entries, an attendance report, and the Bi-weekly Time Report.

Shop Floor Insight app icon

Part of Shop Floor Insight

A manufacturing execution system (MES) for barcoded time capture and employee time management.

Have a question about Shop floor labor reporting?

Send us a note and the Shop Floor Insight team will reply by email. Ready to plan a rollout? Contact your Microsoft Partner.

Ask a product question

Product Questions