Connectors

/

Microsoft Dynamics GP

/

Check Dynamics GP month-end close readiness
Report

See everything blocking the month-end close in one checklist

For controllers who want unposted batches, documents and unreconciled bank accounts in Dynamics GP checked before close, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Check Dynamics GP month-end close readiness
Is Dynamics GP ready to close September? Period end is 30 September.
September is not ready yet: 3 of 6 areas need attention. - Batches: 4 unposted, 2 waiting on approval, oldest from 12 September - Sales: 7 unposted documents totalling 23,800 - Bank: the operating checkbook is not reconciled to 30 September - Ready: purchase receipts, timesheets and expenses Accruals are not checked. Want the oldest items in each area?
Microsoft Dynamics GP
Sample figures. Your results come from your own account.
microsoft-dynamics-gp-get-cmp-batch
microsoft-dynamics-gp-get-rm-sales-trx
microsoft-dynamics-gp-get-pm-receivings-trx
microsoft-dynamics-gp-get-pa-timesheet
microsoft-dynamics-gp-get-pa-employee-expense
microsoft-dynamics-gp-get-gl-checkbook

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

One forgotten batch means reopening the month

Before closing a month in Dynamics GP a controller checks unposted batches, sales, receipts, timesheets, expenses and bank reconciliations, each in a different window. Miss one and the period has to be reopened later.

Without PopdockAI

  • Open each batch window and filter for unposted items
  • Check sales, receipts, timesheets and expenses separately
  • Look up the last reconciliation date for every checkbook
  • Reopen the period when something was missed

With PopdockAI

  • Unposted batches are split into awaiting approval and not posted
  • Sales, receipts, timesheets and expenses are checked together
  • Checkbooks not reconciled to period end are listed
  • A ready or attention checklist, with nothing 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:** Tell the controller what still stands between them and closing the period ending `{period-end-date}` (default the last day of the previous month).

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: Batches**

Call `dynamics-gp-get-cmp-batch` with `batch-date.to` set to the period end. Keep batches that are not posted (by `status`), and group them by `series` with `number-of-transactions`, `total` and `workflow-approval-status`. Batches waiting on approval are a separate item from batches nobody has posted.

**Step 2: Unposted documents by module**

* Sales: `dynamics-gp-get-rm-sales-trx` with `document-date.to` at the period end; keep those whose `posting-status` is unposted, by `sop-type`.
* Purchasing: `dynamics-gp-get-pm-receivings-trx` with `receipt-date.to` at the period end; keep unposted `posting-status`.
* Project time: `dynamics-gp-get-pa-timesheet` with `document-date.to` at the period end; keep those whose `status` is not posted.
* Project expenses: `dynamics-gp-get-pa-employee-expense` with `document-date.to` at the period end; keep those whose `status` is not posted.

**Step 3: Bank**

Call `dynamics-gp-get-gl-checkbook` for checkbooks that are not `inactive`. Any whose `last-reconciled-date` is before the period end has not been reconciled for the period.

**Step 4: Report**

A checklist with one line per area (batches, sales, purchasing, project time, project expenses, bank): a ready or attention marker, the count and total outstanding. Under each attention line, list the items (batch number, document number, date, amount, who or what it belongs to), oldest first, at most 10 per area with a count of the rest.

**Rules & Guidelines:**

* This prompt is read-only. Do not call any tool whose name does not contain `get` (no add, update, note or email tools).
* Report status values exactly as returned; do not reinterpret a status you do not recognise as posted.

**Validation:**

* If every area is clear, say the period looks ready to close, and list what these tools cannot check (subledger to GL reconciliation, accruals, fixed asset depreciation runs).

Who it's for

One answer, three teams that use it

Controllers

See every close blocker in one list

A ready or attention marker per area tells you where to send people before you lock the period.

Is Dynamics GP ready to close October? Period end is 31 October.

Staff accountants

Find the oldest unposted items first

Counts, totals and the oldest items in each area show which batches and documents to post or chase today.

Which unposted batches and sales documents in Dynamics GP are holding up the June close?

Treasury teams

Confirm the bank is reconciled

Active checkbooks not reconciled to period end are listed, so bank reconciliations are done before the close.

Which Dynamics GP checkbooks are not reconciled to 30 September?

How it works

What PopdockAI does when you ask

You give the period end date, and your AI assistant checks every area of Dynamics GP that can block the close. It reports what is outstanding and what it cannot check, and changes nothing.

01

Ask

You give the period end date.

Your AI tool

02

Batches

It reads unposted batches, separating those awaiting approval from the rest.

microsoft-dynamics-gp-get-cmp-batch

03

Documents

It checks unposted sales, receipts, timesheets, expenses and bank reconciliations.

microsoft-dynamics-gp-get-rm-sales-trx
microsoft-dynamics-gp-get-pm-receivings-trx
microsoft-dynamics-gp-get-pa-timesheet
microsoft-dynamics-gp-get-pa-employee-expense
microsoft-dynamics-gp-get-gl-checkbook

04

Report

You get a ready or attention checklist with counts and the oldest items.

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-cmp-batch

Returns transaction batches from Dynamics GP across all modules, including series, source, status, transaction counts and batch totals. Filter by checkbook ID, series, status, batch number, source, total, batch date and comment, and pick the company and the maximum number of records.
get-data

microsoft-dynamics-gp-get-rm-sales-trx

Returns Sales Order Processing documents such as quotes, orders and invoices from Dynamics GP Sales, with the customer, dates, salesperson and document totals. Filter by batch number, customer ID, SOP type, SOP number, salesperson ID, document amount, customer name and document date, and pick the company and the maximum number of records.
get-data

microsoft-dynamics-gp-get-pm-receivings-trx

Returns receivings transactions (purchase receipts) from Dynamics GP Payables/Purchasing, including vendor, receipt type, dates, status and amounts. Filter by vendor name, POP type, subtotal, vendor ID, batch number, receipt date, posting status and vendor document number, and pick the company and the maximum number of records.
get-data

microsoft-dynamics-gp-get-pa-timesheet

Returns employee timesheet documents from Dynamics GP Project Accounting, including employee, reporting period, quantities, costs and accrued revenue. Filter by transaction type, employee ID, batch number, document date, total costs, employee last name, status and timesheet number, and pick the company and the maximum number of records.
get-data

microsoft-dynamics-gp-get-pa-employee-expense

Returns employee expense documents from Dynamics GP Project Accounting, with the employee, dates, status, total costs and reimbursable amounts. Filter by batch number, employee expense document number, employee ID, transaction type, employee last name, status, document date and total costs, and pick the company and the maximum number of records.
get-data

microsoft-dynamics-gp-get-gl-checkbook

Returns checkbooks from Dynamics GP General Ledger (bank reconciliation), including bank, cash account, currency, current balance and last reconciliation. Filter by current balance, bank ID, currency ID, checkbook type, inactive, checkbook ID and description, and pick the company and the maximum number of records.
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

Close the period once, not twice

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