/
/
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.
On this page
Connector
Connect Microsoft Dynamics GP, pick your AI tool and paste the prompt.
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.
**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.
02
Read GP
It reads the project and sums booked hours and cost per employee.
03
Read TickTick
It totals focus time and lists open and completed tasks for the project.
04
Report
You get the difference and a one-line read, with uncertain matches apart.
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.
microsoft-dynamics-gp-get-pa-project
microsoft-dynamics-gp-get-pa-timesheet-line
ticktick-get-focuses
ticktick-get-tasks
ticktick-get-completed-tasks
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.
The outcome
Booked hours and focus time in one view
Related use cases
More ways to put this data to work
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.

.webp)
