Connectors

/

Microsoft Dynamics 365 Business Central

/

Compare Dynamics 365 Business Central timesheets with Teamwork.com time logs
Report
Cross-Connector

Catch time discrepancies before billing and payroll

For project managers who want Business Central timesheets compared with Teamwork.com time logs day by day, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Compare Dynamics 365 Business Central timesheets with Teamwork.com time logs
Compare Jordan Lee's Business Central timesheet hours with their Teamwork.com time logs for October.
October: 162 hours in Business Central, 155.5 in Teamwork.com. - Differ: 4 days by more than a quarter hour - One side only: October 17, 7.5 hours in Business Central only - Open: 2 timesheet lines still unapproved Want the day by day table?
Microsoft Dynamics 365 Business Central
Sample figures. Your results come from your own account.
teamwork-com-get-people
teamwork-com-get-time

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Microsoft Dynamics 365 Business Central

Microsoft Dynamics 365 Business Central
Run it on your own Microsoft Dynamics 365 Business Central data.

Connect Microsoft Dynamics 365 Business Central, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

Time logged twice rarely adds up the same

People record time on a Business Central timesheet for costing and in Teamwork.com for the project. When the two disagree, billing and payroll are both at risk, and comparing them means matching the person and checking every day by hand.

Without PopdockAI

  • Find the person in both systems
  • Export a timesheet and a time log report
  • Line up the hours day by day in a spreadsheet
  • Find the gap after the invoice or payroll run

With PopdockAI

  • The person is matched to their Business Central resource
  • Hours are compared day by day, not entry by entry
  • Days that differ by more than a quarter hour are flagged
  • Open or unapproved lines are listed, and nothing is edited

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** Compare the hours `{person-name}` recorded on Business Central timesheets with the time they logged in Teamwork, day by day, from `{from-date}` to `{to-date}` (default: today).

**Step 1: Find the person in Teamwork**

Call `teamwork-get-people` (Teamwork server) with `name.contains` set to `{person-name}`. If more than one person matches, list them (name, email, company-name) and ask which one is meant. Keep `person-id`, `name` and `email`.

**Step 2: Find the resource in Business Central**

Call `business-central-get-resource` (Business Central server) with `name.contains` set to `{person-name}`, and choose the resource whose name matches the Teamwork person. If the names differ, call `business-central-get-employee` and match its `email` or `company-email` to the Teamwork email, then use the resource with the same name as that employee. If no resource matches, stop and say the person has no Business Central resource.

**Step 3: Read both sides**

* Call `business-central-get-timesheet` with `resource-number` set to the resource-number, `date.from` set to `{from-date}` and `date.to` set to `{to-date}` (today when blank). Keep `date`, `quantity` (hours), `job-number`, `description`, `status` and `posted`.
* Call `teamwork-get-time` with `user-id` set to the person-id, `time-logged.from` set to `{from-date}` and `time-logged.to` set to `{to-date}`. Keep `time-logged`, `minutes`, `project-name`, `task-name` and `is-billable`.

Use dates in YYYY-MM-DD form.

**Step 4: Report**

A table with one row per day: BC timesheet hours, Teamwork hours (minutes divided by 60), and the difference. Flag days where the difference is more than 0.25 hours, and days that have hours on only one side. Then show totals for the period, plus the BC timesheet lines that are still open or unapproved.

**Rules & Guidelines:**

* `teamwork-get-people` and `teamwork-get-time` are on the Teamwork server. `business-central-get-resource`, `business-central-get-employee` and `business-central-get-timesheet` are on the Business Central server.
* This prompt is read-only. Do NOT call `teamwork-create-time-entry` or `teamwork-update-time-entry`, and do not change any Business Central record.
* Compare hours by date only. Do not try to match individual entries: the two systems split work differently.

**Validation:**

* If both sides are empty for the period, say so and stop.
* If only one side has entries, report the period as recorded only in that system instead of as a day-by-day mismatch.

Who it's for

One answer, three teams that use it

Project managers

Bill clients for the time really worked

Catch days where project time and costed time disagree before the client invoice goes out.

Compare Priya Shah's Business Central timesheet with her Teamwork.com time for last week.

Payroll administrators

Check hours before payroll closes

Days that appear on only one side are flagged, so pay is based on hours that agree.

Check Tom Reyes's Business Central timesheet against Teamwork.com for November and list any mismatched days.

Project accountants

Find unapproved lines holding up costing

Timesheet lines still open or unapproved are listed alongside the daily comparison.

Which of Dana Whitfield's Business Central timesheet lines for October are still unapproved, and do they match Teamwork.com?

How it works

What PopdockAI does when you ask

You name the person and a period and your AI assistant lines up their Business Central timesheets with their Teamwork.com time. It stops if no resource matches, and neither system is edited.

01

Ask

You name the person and a period.

Your AI tool

02

Match

It finds them in Teamwork.com and their Business Central resource.

teamwork-com-get-people

03

Compare

It compares hours day by day and flags gaps over a quarter hour.

No items found.

04

Report

You get a daily table, period totals and open or unapproved lines.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for Microsoft Dynamics 365 Business Central and one secure connection to your AI tool. No code, no exports.

get-data

teamwork-com-get-people

Returns people (users) from Teamwork.com with their company, role, rates and contact details. Filter by email, type, name, company ID, person ID, last name, role name and company name.
get-data

teamwork-com-get-time

Returns time log entries from Teamwork.com with the person, project, task, minutes and billable amounts. Filter by time logged, minutes, project ID, user ID, user name, billable and task ID.
Read only.Nothing in Microsoft Dynamics 365 Business Central Changes

This report is built from Get data tools only. PopdockAI applies the row, field and parameter rules your admin sets, and every query is written to the audit trail.

How Popdock AI secures your data

The outcome

Time discrepancies caught before billing and payroll

Try PopdockAI free
Get a live demo

Related use cases

More ways to put this data to work

All Ramp use cases

One prompt template with infinite possibilities.

‍

Your AI assistant adapts its approach, tone, and capabilities to match each unique context while you maintain a single, manageable workflow.

Join forward-thinking companies that are transforming their operations with intelligent, secure AI automation.

Try PopdockAI Free
See Documentation