Connectors

/

Microsoft Dynamics SL

/

Check Dynamics SL contract renewals in TickTick
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Check Dynamics SL contract renewals in TickTick
Which active Dynamics SL service contracts expire in the next 60 days, and which of them have no renewal task in TickTick?
5 contracts expire in the next 60 days and 2 have no renewal task. - SC-2041, Contoso, 12,000.00, expires 14 Nov, Renew Contoso support, due 1 Nov - SC-2057, Fabrikam, 8,400.00, expires 30 Nov, None - SC-2063, Northwind Traders, 21,500.00, expires 9 Dec, None Want the other two contracts too?
Microsoft Dynamics SL
Sample figures. Your results come from your own account.
dynamics-sl-get-service-contracts
ticktick-get-tasks

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Microsoft Dynamics SL

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

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

Try PopdockAI free

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.

Prompt
**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.

Your AI tool

02

Read

It lists the active Dynamics SL service contracts expiring in that window.

dynamics-sl-get-service-contracts

03

Check

It searches open TickTick tasks by contract ID and customer name for a renewal task.

ticktick-get-tasks

04

Report

You get a table by expiration date and a count of contracts with no renewal task.

Your AI tool

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.

get-data

dynamics-sl-get-service-contracts

Returns Dynamics SL service contracts with customer, contract type, amounts billed, billing frequency and start and expiration dates. Filter by customer, contract, type, status, total amount or expiration date.
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.
Read only.Nothing in Microsoft Dynamics SL 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

See renewal gaps in time to act

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