Connectors

/

Stripe

/

Post Stripe invoices to Dynamics GP
Write
Cross-Connector

Post Stripe invoices to Dynamics GP without duplicates

For receivables teams who want finalized Stripe invoices added to a Dynamics GP batch by asking their AI assistant, with no invoice keyed twice.

Try PopdockAI free
Get a live demo
Post Stripe invoices to Dynamics GP
Post finalized Stripe invoices from September to Dynamics GP batch STRIPE0930.
14 finalized Stripe invoices from September are not in Dynamics GP; 12 are ready for batch STRIPE0930. - Ready: 12 invoices totalling 28,640.00 - No clear customer: INV-1042, two GP customers match the name - Not posted: INV-1051 is in EUR, not the functional currency Shall I add the 12 invoices to the batch?
Stripe
Sample figures. Your results come from your own account.
stripe-get-invoice
microsoft-dynamics-gp-get-rm-trx
microsoft-dynamics-gp-get-rm-customer
microsoft-dynamics-gp-rm-trx-add

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Stripe

Stripe
Run it on your own Stripe data.

Connect Stripe, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

Keying Stripe invoices into GP twice or to the wrong customer

Getting Stripe invoices into Dynamics GP receivables means exporting from Stripe, checking each number against GP and finding the right GP customer. Pick the wrong customer or miss one already keyed and the receivables ledger is wrong until someone spots it.

Without PopdockAI

  • Export finalized invoices from Stripe
  • Check each number against GP
  • Find the right GP customer for each
  • Key them into a batch by hand

With PopdockAI

  • Invoices whose number GP already holds are skipped
  • Each is matched to one clear GP customer by name and email
  • Unclear matches, other currencies and long numbers are held back
  • You approve the table, and each invoice is added to the batch once

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 the finalized Stripe invoices created from `{start-date}` to `{end-date}` that have no receivables document in Dynamics GP, and add the ones the user confirms to GP batch `{batch-number}` in company `{company}` (empty means the default company).

**Step 1: Read the Stripe invoices**

Call `stripe-get-invoice` with `created-date.from` = `{start-date}` and `created-date.to` = the day after `{end-date}`. Keep invoices with status `open`, `paid` or `uncollectible`, and drop any created after `{end-date}`.

**Step 2: Skip the ones GP already has**

For each invoice, call `dynamics-gp-get-rm-trx` with `document-number` = the Stripe `number`. If a record comes back, skip the invoice.

**Step 3: Map the customer**

For each remaining invoice, call `dynamics-gp-get-rm-customer` with `customer-name.contains` = the Stripe `customer-name`, and accept the GP customer whose `main-email-address` equals the Stripe `customer-email`, ignoring case. If none matches, or more than one does, mark the invoice as unmapped. Do not post it.

**Step 4: Propose and confirm**

Show a table: Stripe number, created date, due date, customer, GP customer ID, total, status. Show the unmapped invoices separately and suggest `backfill-stripe-customers`. Then stop and wait. Post nothing until the user confirms, and post only the rows they confirm.

**Step 5: Post**

For each confirmed invoice, call `dynamics-gp-rm-trx-add` once with `document-type` = the code the tool lists for an invoice, `document-number` = the Stripe `number`, `customer-id` = the GP customer ID, `document-date` = the Stripe created date, `due-date` = the Stripe due date, `document-amount` and `sales-amount` = the Stripe `total`, `batch-number` = `{batch-number}`, `description` = "Stripe " followed by the Stripe number, `create-distributions` = 1 and `company` = `{company}`. Stripe totals include tax, so do not also set `tax-amount`.

**Step 6: Report**

A table of what was posted, what failed (with the error) and what was skipped, and a closing line saying the batch still has to be posted in Dynamics GP.

**Rules & Guidelines:**

* `stripe-get-invoice` is on the stripe server. The dynamics-gp tools are on the dynamics-gp server.
* The only write tool this prompt may call is `dynamics-gp-rm-trx-add`, once per confirmed invoice. Do not call `dynamics-gp-rm-sales-trx-add`, `dynamics-gp-rm-customer-add`, `dynamics-gp-gl-bank-deposit-add` or any other dynamics-gp write tool. The stripe server has no write tools.
* Payments are not posted here. A paid Stripe invoice goes in as an invoice only.

**Validation:**

* If every Stripe invoice is already in GP, say so and stop.
* If a Stripe number is longer than 21 characters, GP cannot hold it. Report it and do not post it.
* If a post fails, report the error, do not retry it, and continue with the next invoice.
* If the invoice currency is not the GP company's functional currency, do not post it. Report it instead.

Who it's for

One answer, three teams that use it

Accounts receivable

Load Stripe invoices without rekeying

Invoices go into your batch ready to post, with duplicates already removed.

Post finalized Stripe invoices from October to Dynamics GP batch STRIPE1031.

Controllers

Keep the receivables ledger right

Invoices without a single clear customer are held back rather than guessed.

Which Stripe invoices from last week could not be matched to a GP customer?

Billing specialists

See what will be posted first

A table of every invoice lets you check before anything enters GP.

Show me the Stripe invoices from 1 to 15 November that would go into GP batch STRIPEMID.

How it works

What PopdockAI does when you ask

You give a date range and a batch, and your AI assistant prepares Stripe invoices for Dynamics GP. Nothing is written until you confirm, and posting the batch stays with you.

01

Ask

You give a date range and a GP batch.

Your AI tool

02

Check

It skips Stripe invoices whose number Dynamics GP already holds.

stripe-get-invoice
microsoft-dynamics-gp-get-rm-trx

03

Match

It finds one clear GP customer by name and email, holding back the rest.

microsoft-dynamics-gp-get-rm-customer

04

Confirm

You approve the table, then each invoice is added to the batch once.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for Stripe and one secure connection to your AI tool. No code, no exports.

get-data

stripe-get-invoice

Returns invoices (number, customer, status, dates, totals, amount remaining) from Stripe.
get-data

microsoft-dynamics-gp-get-rm-trx

Returns receivables transactions such as invoices, payments and credit memos from Dynamics GP Receivables Management, including customer, dates, amounts and outstanding balances. Filter by customer ID, document type, customer name, document date, document amount, document number, batch number and void status, and pick the company and the maximum number of records.
get-data

microsoft-dynamics-gp-get-rm-customer

Returns customer records from Dynamics GP Receivables Management, including contact details, class, terms and balances. Filter by salesperson ID, hold, customer name, state, zip, customer balance, customer class and city, and pick the company and the maximum number of records.
run-action

microsoft-dynamics-gp-rm-trx-add

Adds a receivables transaction in Dynamics GP through eConnect; GP defaults any field not listed. Requires document number, customer ID, document type, document date and batch number. Optional: due date, sales amount, payment terms ID, freight amount, salesperson ID and description. Writes to the live Dynamics GP company database.
Read only.Nothing in Stripe 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

Stripe billing in GP, with no duplicates

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