Connectors

/

DonorPerfect

/

Audit DonorPerfect GL code mapping in Dynamics 365 Business Central
Report
Cross-Connector

Catch broken DonorPerfect GL codes before journal lines fail

For finance teams who need every DonorPerfect GL code checked against Business Central accounts, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Audit DonorPerfect GL code mapping in Dynamics 365 Business Central
Check that all our DonorPerfect GL codes still map to valid accounts in Business Central for the Northwind Traders company.
38 DonorPerfect GL codes checked, and 5 need attention. - Missing: code 4150 has no matching account - Blocked: account 4200 is blocked - Heading: 4000 is a heading, not a posting account - Review: 2 codes map to balance sheet accounts Want the fix for each problem group?
DonorPerfect
Sample figures. Your results come from your own account.
donorperfect-get-code

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

DonorPerfect

DonorPerfect
Run it on your own DonorPerfect data.

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

Try PopdockAI free

The problem

Gift entries fail because a GL account changed

Every DonorPerfect GL code needs a Business Central account that can take a posting. When an account is blocked, renamed or turned into a heading, gift entries fail and nobody knows which codes are affected.

Without PopdockAI

  • Export GL codes from DonorPerfect
  • Look up each account in Business Central
  • Check blocked, heading and direct posting settings by hand
  • Find out at month end when journal lines are rejected

With PopdockAI

  • Every GL code and mapped campaign is collected
  • Each account is checked in Business Central
  • Problems are classed as missing, blocked, heading or closed
  • One fix per problem group, and nothing is 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:** Check that every GL code DonorPerfect assigns to gifts matches a G/L account in Business Central that can take a direct posting. If `{company}` is given, pass it as `company` on every Business Central call. Include inactive DonorPerfect codes only when `{include-inactive}` is "true" (default: active codes only).

**Step 1: Collect the GL codes from DonorPerfect**

Call `donorperfect-get-code` with `field-name` = GL_CODE and `inactive` = false (leave `inactive` out when `{include-inactive}` is "true"). Keep `code`, `description`, `account-number` and `inactive`. If nothing comes back, try `field-name` = GL and then GLCODE. If none of those return rows, ask the user for the name of the GL code field and stop.

Also call `donorperfect-get-code` with `field-name` = CAMPAIGN and keep any row with a non-blank `account-number`. A campaign mapped to an account also has to match the Business Central chart.

For each code, the account to look up is `account-number` when it is filled in, and otherwise `code` itself.

**Step 2: Look up each account in Business Central**

Call `business-central-get-account` with `account-number` = that account. Record `name`, `account-type`, `blocked`, `direct-posting` and `income-balance`.

**Step 3: Classify and report**

Put each code in exactly one group, the first that applies:

1. **Missing:** no G/L account with that number.
2. **Blocked:** `blocked` is true.
3. **Not a posting account:** `account-type` is anything other than Posting (a heading, total or begin/end total cannot take entries).
4. **No direct posting:** `direct-posting` is false, so a journal line against it will be rejected.
5. **Balance sheet account:** `income-balance` is Balance Sheet. Allowed, but unusual for gift revenue, so flag it for review.
6. **OK.**

Report a table: DonorPerfect field (GL_CODE or CAMPAIGN), code, DonorPerfect description, account looked up, Business Central account name, group. List groups 1 to 5 first, then a single count of the codes that are OK.

Finish with one line per problem group saying what to fix and where (for example, "create account 4105 in Business Central, or change the account number on code 4105-EVT in DonorPerfect").

**Rules & Guidelines:**

* `donorperfect-get-code` is on the donorperfect server. `business-central-get-account` is on the business-central server.
* This prompt is read-only. Do not call any save, create or update tool on either server, including `business-central-create-journal-line`.

**Validation:**

* If a code matches no account exactly, retry once with spaces and dashes removed. Report a match found this way as OK but say the formats differ.
* If Business Central returns more than one account for a number, list them all under that code and put it in the Missing group with a note to check the company.

Who it's for

One answer, three teams that use it

Nonprofit accountants

Stop rejected journal lines

Find the codes that will fail before gifts are posted.

Which DonorPerfect GL codes map to blocked or missing accounts in Business Central?

Finance directors

Keep fundraising and the ledger aligned

A clear table shows which mappings need attention and why.

Audit DonorPerfect GL code mapping against the Contoso Foundation company in Business Central, including inactive codes.

Database managers

Know exactly what to change

Each problem group comes with what to fix and in which system.

Do any DonorPerfect campaigns point at Business Central heading accounts?

How it works

What PopdockAI does when you ask

You optionally name the company and your AI assistant checks every DonorPerfect GL code against Business Central accounts. It only reads and tells you what to fix and where.

01

Ask

You optionally name the Business Central company and whether to include inactive codes.

Your AI tool

02

Collect

It gathers every DonorPerfect GL code and campaign mapped to an account.

donorperfect-get-code

03

Check

It looks up each account in Business Central and classifies any problem.

No items found.

04

Report

You get a table and one fix per problem group, with nothing changed.

Your AI tool

What PopdockAI provides

The tools behind the answer

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

get-data

donorperfect-get-code

Returns the configuration code values behind DonorPerfect's drop-down fields, such as campaign, solicitation, gift type and GL codes. Use it to validate a code before writing a gift, pledge or donor record.
Read only.Nothing in DonorPerfect 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

Broken mappings fixed before month end

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