/
/
Find expiring Dynamics SL contracts with no renewal task
For sales teams who want expiring service contracts checked against TickTick reminders, just by asking their AI assistant.
On this page
Connector
Connect Microsoft Dynamics SL, pick your AI tool and paste the prompt.
The problem
Service contracts expire with no renewal reminder
Service contracts lapse because renewal reminders are not tracked against the contract list. Someone has to list contracts ending soon and search the task app for a reminder on each.
Without PopdockAI
- List contracts expiring soon in Dynamics SL
- Search TickTick for each contract
- Check whether a renewal task exists
- Contracts lapse when one is missed
With PopdockAI
- Expiring active contracts are listed for your window
- Open TickTick tasks are searched by contract ID and customer
- Contracts with no renewal task are counted
- Read-only, no TickTick task is created
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Find active Dynamics SL service contracts expiring within `{expiring-within-days}` days (default 60) and check TickTick for a renewal task on each. Read-only.
**Step 1: Read contracts in Dynamics SL**
Call `dynamics-sl-get-service-contracts` with contract-expiration-date.from set to today, contract-expiration-date.to set to today plus the window, and status active (company `{company}` if given).
**Step 2: Look for renewal tasks**
For each contract call `ticktick-get-tasks` with title.contains set to the contract-id, then to the customer-name if empty, with status open. A task counts as a renewal task if its title mentions renew or the contract-id.
**Step 3: Report**
Table sorted by expiration date: contract-id, customer-name, total-amount, contract-expiration-date, renewal task title and due-date or None. End with the count of contracts with no renewal task.
**Rules & Guidelines:**
* `dynamics-sl-get-service-contracts` is on the dynamics-sl server. `ticktick-get-tasks` is on the TickTick server.
* Do not call any TickTick write tool.
**Validation:**
* If no contracts expire in the window, say so and stop.
* If the status filter returns nothing, retry without it and report the contract status column.Who it's for
One answer, three teams that use it
Account managers
Never miss a renewal
See which expiring contracts have no renewal task, sorted by expiration date.
Which Dynamics SL service contracts end in the next 30 days without a TickTick renewal task?
Service managers
Check renewal coverage for a customer
Filter by company to see a customer's expiring contracts and their tasks.
Show Contoso's Dynamics SL service contracts expiring this quarter and any TickTick renewal tasks.
Sales operations
Count gaps before they become lost revenue
The count of contracts with no renewal task shows where follow up is missing.
How many service contracts expire in the next 90 days with no renewal task in TickTick?
How it works
What PopdockAI does when you ask
You give a window in days and your AI assistant checks each expiring contract for a TickTick renewal task. It reports only.
01
Ask
You give an expiry window in days and optionally a company.
02
Read
It lists the active Dynamics SL service contracts expiring in that window.
03
Check
It searches open TickTick tasks by contract ID and customer name for a renewal task.
04
Report
You get a table by expiration date and a count of contracts with no renewal task.
What PopdockAI provides
The tools behind the answer
Ready made tools for Microsoft Dynamics SL and one secure connection to your AI tool. No code, no exports.
dynamics-sl-get-service-contracts
ticktick-get-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
See renewal gaps in time to act
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)
