/
/
Find stale checks and duplicate deposits before they distort cash
For finance teams who want unreconciled Dynamics GP bank items and overdue reconciliations found, by asking their AI assistant.
On this page
Connector
Connect Microsoft Dynamics GP, pick your AI tool and paste the prompt.
The problem
Stale checks and duplicate deposits build up
Unreconciled bank items in Dynamics GP build up quietly: old checks never cashed, deposits entered twice, checkbooks unreconciled for weeks. Finding them means paging through every checkbook and comparing amounts by hand.
Without PopdockAI
- Check each checkbook's last reconciliation date
- Page through unreconciled transactions
- Spot checks older than 90 days
- Compare amounts and payees to find duplicates
With PopdockAI
- Checkbooks not reconciled in 45 days are flagged
- Old unreconciled items are grouped by type
- Checks over 90 days are called out as stale
- Possible duplicates are listed for review, and nothing is voided
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** For checkbook `{checkbook-id}` (default all active checkbooks), list unreconciled bank transactions older than `{older-than-days}` days (default 30), spot likely duplicates, and flag checkbooks that are overdue for reconciliation.
Pass `{company}` as `company` on every call (if it is empty, omit `company` and the default company is used). Pass a generous `max-records` (1000). If a result comes back with exactly that many rows, say the result may be truncated.
**Step 1: Checkbooks**
Call `dynamics-gp-get-gl-checkbook`, filtered by `checkbook-id` when given, keeping those not `inactive`. For each note `current-balance`, `last-reconciled-date`, `last-reconciled-balance`, `currency-id` and `bank-id`. Flag any whose `last-reconciled-date` is more than 45 days ago or empty.
**Step 2: Unreconciled transactions**
For each checkbook, call `dynamics-gp-get-gl-bank-transaction` filtered by `checkbook-id` and `reconciled` set to not reconciled, with `transaction-date.to` set to today minus the threshold. Drop rows where `voided` is set. If the `reconciled` filter is rejected or ignored, read without it and filter the rows yourself.
Group by `cm-transaction-type` (checks, deposits, withdrawals, adjustments). Checks outstanding more than 90 days are stale and may need voiding or escheatment review.
**Step 3: Possible duplicates**
Within each checkbook, flag pairs with the same `checkbook-amount` and the same `paid-to-received-from` dated within 7 days of each other. These are questions, not errors.
**Step 4: Report**
* Per checkbook: id, bank, current balance, last reconciled date and balance, number and total of unreconciled items older than the threshold.
* A table of stale items: transaction number, type, date, age in days, paid to or received from, amount, source document.
* The possible duplicates.
* Checkbooks overdue for reconciliation.
**Rules & Guidelines:**
* Read-only. Do not call `dynamics-gp-gl-bank-transaction-add`, `dynamics-gp-gl-bank-deposit-add`, `dynamics-gp-gl-bank-transaction-note`, `dynamics-gp-gl-bank-deposit-note` or any tool whose name does not contain `get`.
* Do not recommend voiding a specific check; recommend reviewing it.
**Validation:**
* If there are no unreconciled items older than the threshold, say so and give the count of newer unreconciled items.Who it's for
One answer, three teams that use it
Treasury teams
Keep every checkbook reconciled
Checkbooks behind on reconciliation are flagged, so none slip past month end.
Which Dynamics GP checkbooks have not been reconciled in the last 45 days?
Staff accountants
Clear stale checks
Checks over 90 days are listed, so you can follow up with payees or review for escheat.
List uncashed checks older than 90 days in the OPERATING checkbook in Dynamics GP.
Controllers
Catch duplicate deposits
Same amount and payee pairs within seven days are listed, so cash is not overstated.
Are there any possible duplicate deposits in our Dynamics GP checkbooks this quarter?
How it works
What PopdockAI does when you ask
You choose a checkbook or all and an age threshold, and your AI assistant reviews unreconciled Dynamics GP bank items. It recommends review, not voiding, and changes nothing.
01
Ask
You choose a checkbook, or all, and an age threshold.
02
Read
It reads balances and last reconciliation dates, flagging any over 45 days.
03
Check
It groups old unreconciled items and finds possible duplicates.
04
Report
You get stale checks and duplicates to review, with nothing voided.
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-gl-checkbook
microsoft-dynamics-gp-get-gl-bank-transaction
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
Current reconciliations and clean cash
Related use cases
More ways to put this data to work
Record a Dynamics GP bank transaction
Ask your AI to record a Dynamics GP bank transaction and it checks the checkbook, warns about likely duplicates, picks money in or out and records it after you confirm.
Learn More
Add Dynamics GP item buyers to a Constant Contact list
Ask your AI to add an item's buyers to a Constant Contact list and it totals each customer's purchases in Dynamics GP, checks them in Constant Contact and adds the missing ones after you confirm.
Learn More
Add missing Dynamics GP customers to a Constant Contact list
Ask your AI to add missing Dynamics GP customers to a Constant Contact list and it checks every email, then creates only the missing contacts after you confirm.
Learn More
Add missing Dynamics GP customers to a Mailchimp audience
Ask your AI to add missing Dynamics GP customers to a Mailchimp audience and it proposes only people not in the audience at all, adding them as pending after you confirm.
Learn More
Add tracking to a Dynamics GP sales order
Ask your AI to add tracking to a Dynamics GP sales order and it finds the document by your number or the customer's PO, asks if several match, and writes once after you confirm.
Learn More
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.