/
/
Check who is safe to bill before the billing run
For billing teams who want uninvoiced Harvest work checked against Business Central holds and credit limits by asking their AI assistant.
On this page
Connector
Connect Harvest, pick your AI tool and paste the prompt.
The problem
Clients that should not be billed still get invoiced
Billers total uninvoiced work in Harvest, then look up each client in the ERP for holds and credit limits. Under time pressure the lookups are skipped, and a blocked or overdue client receives another invoice.
Without PopdockAI
- Run the uninvoiced report and group by client
- Look up each client in the ERP
- Compare balance with credit limit by hand
- Bill a client that should have been held
With PopdockAI
- Uninvoiced work is grouped by client for you
- Block, overdue and credit limit are checked per customer
- A zero credit limit is treated as unset
- No invoice is created, billing stays your decision
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** For the period `{period-start}` to `{period-end}` (default: last month), list clients with uninvoiced work in Harvest and check whether the matching Business Central customer can be billed.
**Step 1: Uninvoiced work (Harvest server)**
Call `harvest-get-uninvoiced-report` with `period-start` = `{period-start}`, `period-end` = `{period-end}`, `uninvoiced-amount.min` = `{minimum-amount}` if provided, and `client-name.contains` = `{client-name}` if provided. Group by `client-name` and total `uninvoiced-amount`, `uninvoiced-hours` and `uninvoiced-expenses`.
**Step 2: Customer standing (Business Central server)**
For each client, call `business-central-get-customer` with `name` = the client name (fall back to `name.contains`). Keep `customer-number`, `blocked`, `balance`, `balance-due`, `credit-limit`.
**Step 3: Report**
A table with client, uninvoiced amount, customer-number, customer balance, credit limit, and a verdict: Ready to bill; Over credit limit (balance plus uninvoiced amount above `credit-limit` when the limit is above 0); Customer blocked; Overdue balance (`balance-due` above 0); No customer in Business Central. Sort by uninvoiced amount, largest first.
**Rules & Guidelines:**
* `harvest-get-uninvoiced-report` is on the harvest server; `business-central-get-customer` is on the business-central server.
* Read-only. Do not call `harvest-invoices-create`, `harvest-invoices-create-from-tracked-time`, `business-central-create-sales-invoice` or any update or delete tool. Billing is a separate decision for the user.
**Validation:**
* A `credit-limit` of 0 means no limit is set; do not report it as over limit.
* If Harvest shows no uninvoiced work, say so and stop.
* Amounts in different currencies are listed separately, never summed.Who it's for
One answer, three teams that use it
Billing specialists
Start the run with a clean list
See which clients are ready to bill and which have a hold or a limit problem, sorted by how much work is waiting.
Which clients have uninvoiced Harvest work for September and are ready to bill according to Business Central?
Credit controllers
Spot limit breaches before they grow
The check adds the uninvoiced amount to the customer balance and flags it when it would push them past their credit limit.
Would billing Contoso for their uninvoiced work put them over their Business Central credit limit?
Finance managers
Approve the run with confidence
Get a one table view of uninvoiced value by client with the verdict beside it, so approval does not depend on memory.
Show uninvoiced work above 2,000.00 for last month with a billing verdict for each client.
How it works
What PopdockAI does when you ask
You choose the period and your AI assistant does the checks for every client. It lists currencies separately and never creates an invoice.
Ask
You give a period and optionally a minimum amount or client.
Total
It groups uninvoiced Harvest hours, expenses and amounts by client.
Check
It finds each Business Central customer and looks at block status, balance, overdue and credit limit.
Report
You get a table with a verdict per client, largest uninvoiced amount first.
What PopdockAI provides
The tools behind the answer
Ready made tools for Harvest and one secure connection to your AI tool. No code, no exports.
harvest-get-uninvoiced-report
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
Bill the right clients first
Related use cases
More ways to put this data to work
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.

.webp)
