Connectors

/

Chargebee

/

Reconcile Chargebee invoices to Dynamics GP receivables
Report
Cross-Connector

Reconcile Chargebee invoices to Dynamics GP receivables

For finance teams who want billing and GP receivables to agree, just by asking their AI assistant about a customer.

Try PopdockAI free
Get a live demo
Reconcile Chargebee invoices to Dynamics GP receivables
Reconcile Chargebee invoices for northwind-001 to Dynamics GP receivables for the last 90 days.
9 Chargebee invoices checked: 7 matched, 1 different in amount and 1 missing from GP. - Missing from GP: INV-1051, USD 640 - Different: INV-1030, Chargebee USD 900, GP USD 880 - GP invoices with no Chargebee invoice: 0 - Net difference: USD 660 Want the matched list with document numbers?
Chargebee
Sample figures. Your results come from your own account.
chargebee-get-invoice
microsoft-dynamics-gp-get-rm-trx
microsoft-dynamics-gp-get-rm-customer

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Chargebee

Chargebee
Run it on your own Chargebee data.

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

Try PopdockAI free

The problem

Missing invoices in GP are found only at month end

Billing staff tick Chargebee invoices against Dynamics GP receivables line by line, relying on PO numbers, document numbers and amounts. Missing or mismatched invoices are found only at month end.

Without PopdockAI

  • List the customer's Chargebee invoices
  • List their receivables transactions in GP
  • Match by PO, document number or amount by hand
  • Find the gaps at month end

With PopdockAI

  • Chargebee invoices and GP receivables are read for the period
  • Matches use PO number, document reference, then amount
  • One GP transaction is never matched to two invoices
  • Totals per system and the net difference are shown, nothing added

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** For the customer `{customer-id}` compare Chargebee invoices with Dynamics GP receivables between `{date-from}` and `{date-to}` (default: the last 90 days). Use `{gp-company}` as the GP company when given.

**Step 1: Chargebee invoices**

Call `chargebee-get-invoice` (chargebee server) with `customer-id`, `date.from` and `date.to`. Keep id, date, total, amount-paid, amount-due, status, po-number and currency-code.

**Step 2: GP receivables**

Call `dynamics-gp-get-rm-trx` (dynamics-gp server) with `customer-id` (the same value; if nothing is returned, resolve the GP customer number with `dynamics-gp-get-rm-customer` using the customer name), `document-date.from` and `document-date.to`.

**Step 3: Match**

Match each Chargebee invoice to a GP transaction by `po-number` equal to `customer-po-number`, then by the Chargebee invoice id appearing in `document-number` or `document-description`, then by equal total against `document-amount` on a nearby date. Never match one GP transaction to two invoices.

**Step 4: Report**

Three lists: matched invoices with any amount difference, Chargebee invoices missing from GP, and GP invoice-type transactions with no Chargebee invoice. End with totals for each system and the net difference.

**Rules & Guidelines:**

* `chargebee-get-invoice` is on the chargebee server; `dynamics-gp-get-rm-trx` and `dynamics-gp-get-rm-customer` are on the dynamics-gp server.
* Read only. Do not call `dynamics-gp-rm-trx-add` or any other write tool.
* Ignore GP transactions whose void-status marks them voided, but count them separately.

**Validation:**

* If either side returns nothing, say which and stop after reporting the other side.
* If currencies differ, do not compare amounts; list the invoices unmatched by amount.

Who it's for

One answer, three teams that use it

Billing specialists

Catch missing invoices early

Chargebee invoices missing from GP show up during the month, not at close.

Reconcile Chargebee invoices for contoso-014 to Dynamics GP for the last 30 days.

AR accountants

Find GP invoices with no source

GP invoices with no Chargebee invoice are listed for investigation.

Does Fabrikam have GP receivables with no matching Chargebee invoice since July?

Finance controllers

See the net difference per system

Totals per system and the net difference tell you if a customer is clean.

Give me totals in Chargebee and GP for northwind-002 this quarter and the net difference.

How it works

What PopdockAI does when you ask

You give a customer id and your AI assistant reconciles their Chargebee invoices to Dynamics GP receivables. Voided GP rows are counted separately.

01

Ask

You give a customer id and optionally a date range.

Your AI tool

02

Read

It reads the Chargebee invoices and the GP receivables transactions.

chargebee-get-invoice
microsoft-dynamics-gp-get-rm-trx
microsoft-dynamics-gp-get-rm-customer

03

Match

It matches by purchase order, document reference and then amount.

No items found.

04

Report

You get matches, gaps on each side and totals per system.

Your AI tool

What PopdockAI provides

The tools behind the answer

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

get-data

chargebee-get-invoice

Returns Chargebee invoices with status, amounts, amount due and due date, filterable by customer and status. Read-only.
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.
Read only.Nothing in Chargebee 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

Missing and mismatched GP invoices found during the month

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