Connectors

/

Microsoft Dynamics GP

/

Compare Dynamics GP project hours with TickTick focus time
Report
Cross-Connector

Compare Dynamics GP project hours with TickTick focus time

For project managers who want booked project hours checked against TickTick focus time, just by asking their AI assistant.

Try PopdockAI free
Get a live demo
Compare Dynamics GP project hours with TickTick focus time
Compare booked hours on Dynamics GP project PRJ-2041 with TickTick focus time for the last 30 days.
Booked hours are far larger than tracked focus time on PRJ-2041, which is expected when not all work is timed. - Dynamics GP: 126 hours booked, 9,450 USD cost, 3 employees - TickTick focus: 71 hours across tasks naming PRJ-2041 - Difference: 55 hours - Tasks: 4 open, 11 completed recently Want the per-employee breakdown?
Microsoft Dynamics GP
Sample figures. Your results come from your own account.
microsoft-dynamics-gp-get-pa-project
microsoft-dynamics-gp-get-pa-timesheet-line
ticktick-get-focuses
ticktick-get-tasks
ticktick-get-completed-tasks

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Microsoft Dynamics GP

Microsoft Dynamics GP
Run it on your own Microsoft Dynamics GP data.

Connect Microsoft Dynamics GP, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

Booked hours and real work never line up

Project managers compare timesheet hours booked in Dynamics GP with what the team worked on in TickTick, and the two rarely agree. Pulling numbers from both and matching them to the project takes time and invites guesswork.

Without PopdockAI

  • Sum booked timesheet hours per employee in Dynamics GP
  • Export TickTick focus sessions and filter by project
  • Search tasks that mention the project
  • Guess why the numbers differ

With PopdockAI

  • Booked hours and cost are summed per employee
  • TickTick focus time is totalled for the project number and name
  • Open and completed tasks that mention it are listed
  • Uncertain matches stay separate and nothing is changed

The prompt

Use this prompt

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

Prompt
**Objective:** For GP project `{project-number}`, compare booked timesheet hours and cost in Dynamics GP with the TickTick focus time and tasks that mention the project, looking back `{lookback-days}` days (default 30).

**Step 1: Project and booked time in Dynamics GP**

Call `dynamics-gp-get-pa-project` (Dynamics GP server) with `project-number` = `{project-number}`. If nothing returns, say so and stop. Keep `project-name`, `status`, `actual-total-cost`, `forecast-total-cost`.

Call `dynamics-gp-get-pa-timesheet-line` (Dynamics GP server) with `project-number` = `{project-number}` and `date.from` set `{lookback-days}` days back. Sum `quantity` and `total-cost` per `employee-id`.

**Step 2: Matching TickTick work**

Call `ticktick-get-focuses` (TickTick server) with `task-titles.contains` = `{project-number}`, then again with the `project-name`, and `start-time.from` set `{lookback-days}` days back. Add up `duration-seconds` and convert to hours. Call `ticktick-get-tasks` and `ticktick-get-completed-tasks` (TickTick server) with `title.contains` = `{project-number}` and list open and recently completed tasks.

**Step 3: Report**

Booked GP hours and cost per employee, total TickTick focus hours, the difference, open and completed TickTick tasks, and a one-line read: whether tracked focus time is far below or above booked hours. State that focus time covers only work timed in TickTick, so differences are indicative, not errors.

**Rules & Guidelines:**

* Tools whose names start with dynamics-gp run on the Dynamics GP server; tools whose names start with ticktick run on the TickTick server.
* This prompt is read-only. Do not call any tool that adds, updates, completes, moves, deletes or assigns (for example `ticktick-add-task`, `ticktick-update-task`, `ticktick-complete-task`, `ticktick-delete-task`, `ticktick-batch-tasks`, `ticktick-add-comment`) on the TickTick server, and do not call any Dynamics GP tool that creates or updates records or notes.

**Validation:**

* If TickTick has no matching focus sessions or tasks, report project time from GP and say there is no TickTick activity.
* If the project name matches unrelated tasks, show them as uncertain.

Who it's for

One answer, three teams that use it

Project managers

Sanity check booked hours

See whether time booked to a project matches the focus time the team tracked, before you bill or report on it.

Compare hours booked to Dynamics GP project PRJ-3302 with TickTick focus time this month.

Project accountants

Understand cost against tracked work

Booked cost per employee beside focus time helps explain a project running over budget.

Show booked cost per employee on Dynamics GP project CONTOSO-ERP and the TickTick focus time for the last 60 days.

Team leads

See what the team worked on

Open and recently completed TickTick tasks for the project show what the hours were spent on.

What TickTick tasks mention project PRJ-2041, and how much focus time went on them versus GP hours?

How it works

What PopdockAI does when you ask

You give the project number and a lookback period, and your AI assistant sets Dynamics GP hours beside TickTick focus time. Gaps are shown as indicative, and both systems are only read.

01

Ask

You give a Dynamics GP project number and a lookback period.

Your AI tool

02

Read GP

It reads the project and sums booked hours and cost per employee.

microsoft-dynamics-gp-get-pa-project
microsoft-dynamics-gp-get-pa-timesheet-line

03

Read TickTick

It totals focus time and lists open and completed tasks for the project.

ticktick-get-focuses
ticktick-get-tasks
ticktick-get-completed-tasks

04

Report

You get the difference and a one-line read, with uncertain matches apart.

Your AI tool

What PopdockAI provides

The tools behind the answer

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

get-data

microsoft-dynamics-gp-get-pa-project

Returns project records from Dynamics GP Project Accounting, with the customer, contract, manager, status and forecast and actual cost and billing totals. Filter by status, actual begin date, actual total cost, contract number, project name, project type, project number and project manager ID, and pick the company and the maximum number of records.
get-data

microsoft-dynamics-gp-get-pa-timesheet-line

Returns timesheet line details from Dynamics GP Project Accounting, showing employee time charged to projects and cost categories with quantities, costs and billing. Filter by quantity, employee ID, cost category ID, billing status, date, project number, employee last name and timesheet number, and pick the company and the maximum number of records.
get-data

ticktick-get-focuses

Returns TickTick focus sessions (Pomodoro and stopwatch) with start, end, duration and linked task. Filter by date range.
get-data

ticktick-get-tasks

Returns open TickTick tasks with their project, due date, priority, status, assignee and tags. Filter by project, due date range or status.
get-data

ticktick-get-completed-tasks

Returns completed TickTick tasks with their completion time and project. Filter by project and completion date range.
Read only.Nothing in Microsoft Dynamics GP 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

Booked hours and focus time in one view

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