30-min call with RobBook a proof-of-concept call
System page · Dynamics 365 Business Central

// Business Central · AP automation

Purchase invoices drafted against the order and its posted receipts, the way Business Central holds them.

For manufacturers and distributors whose payables team keys supplier invoices into Business Central, or into Dynamics NAV before it. From copies of 20 to 30 invoices already posted, AI drafts each purchase invoice with its receipt lines, item charges and approval route, and names every line that disagrees with the order. Your reviewer, the person who knows your Business Central payables best, scores each draft against what your team posted. We never log in to Business Central, and nothing is approved, posted or paid.

Book a proof-of-concept call30 minutes with Rob
Posted invoices used
20 to 30
Business Central users we hold
None
Invoices we post
None

// The one job

A vendor's invoice in, a Business Central purchase invoice drafted from its receipts

Today someone opens a new purchase invoice, picks the vendor and types the number from the vendor's paper into Vendor Invoice No. If the goods came in on two receipts, they pull both in with Get Receipt Lines. Freight goes on as an item charge and gets spread across the items, and the invoice then waits for whoever can approve that amount. The slow part is deciding what to do when the invoice and the receipt disagree.

For the test, AI reads copies of invoices your team already posted, with the orders and posted receipts behind them, and drafts each as a Business Central purchase invoice: vendor, invoice number, receipt lines, item charges and the approver it would go to, with a note on every choice. Nothing is created or posted in Business Central. Your reviewer puts each draft beside the posted invoice and marks what differs.

Vendor invoicePDF by email
Invoice no.
Order no.
Ship date
Freight
ItemQty, unitUnit cost
Made-up invoice for illustration
Drafted as
a purchase invoice
Purchase invoice draftFor your reviewer
Vendor Invoice No.
Receipt lines
Item charge
Approver
Receipt lineQty. to invoiceDifference
Made-up draft, not a real document

// Inside Business Central

What Business Central settles between the receipt and the posted invoice

Receipts arrive through Get Receipt Lines. On a new purchase invoice, Get Receipt Lines brings in posted receipt lines that were received but not yet invoiced, as long as they come from one vendor in one currency. Posting updates Quantity Invoiced on each order but leaves the order in place, even fully received and invoiced, until someone deletes it or runs Delete Invoiced Purchase Orders. Microsoft's help also warns that an invoice built this way can't be changed or canceled afterwards, only corrected with a purchase credit memo. So a wrong receipt line chosen today costs a credit memo later. The draft names the posted receipt behind every line and lists any open receipt it left out on purpose.

Newer releases match to order lines. Get Order Lines lets one invoice line cover several purchase order lines whether or not anything has been received, with a Matched Order Lines page to review the match. With Receipt on Invoice turned on for a line, posting the invoice posts the receipt first. Microsoft lists where it can't be used: prepayment orders, item charge lines, project, subcontracting, blanket and intercompany orders, and, for Receipt on Invoice, lines with item tracking or a location that uses directed put-away and pick. For incoming invoice drafts, a Price difference warning appears only when the gap passes the E-Document Matching Difference % on Purchases & Payables Setup, and it doesn't have to be cleared. The draft follows whichever route your team uses, and says when a line would have needed the other.

Freight is an item charge. A freight or duty line goes on the invoice with the type Charge (Item), and its Qty. to Assign shows in red until Item Charge Assignment has spread it over the items. Suggest Item Charge Assignment offers Equally, By Amount, By Weight or By Volume, and the last two read Net Weight and Unit Volume from each item card, so a blank weight skews the split. A carrier's bill that arrives after the receipt was posted is assigned through Get Receipt Lines on the assignment page instead. On items costed at Standard, the charge doesn't move unit cost; it posts as a purchase variance. The draft gives each freight line its charge number, the method your team used and the receipt lines it lands on.

Approvals run from Approval User Setup. Everyone in an approval workflow gets a line there: an Approver ID, a Purchase Amount Approval Limit in local currency or Unlimited Purchase Approval, and a Substitute for when the approver is out, with a single Approval Administrator for the company. Microsoft's help notes one catch: a user who is both requester and approver in a workflow user group has their own requests approved automatically. The draft names the approver your setup would send each invoice to, and flags any invoice whose requester could approve it alone.

Holds, blocked vendors and repeat numbers, and what your reviewer watches. A disputed invoice is held on its vendor ledger entry, with up to three characters, often initials, in On Hold, and Suggest Vendor Payments leaves it out until someone clears it. A vendor whose Blocked field says Payment can't get new payments; All stops every transaction. Business Central does check for a vendor invoice number the same vendor already used, but one partner's documentation notes that the standard check runs at posting, not when the number is typed. Your reviewer, often the AP lead or the person who keeps your approval setup, looks hardest at the receipt lines chosen, item charge assignments and repeat numbers, because each is hard to undo once posted.

// What you send

Excel exports and invoice copies, never a Business Central user

Exported lists
No extension, no login
01

20 to 30 posted invoices and their receipts

Each vendor invoice as it arrived, the posted purchase invoice your team made from it, and the orders and posted receipts it drew on. An invoice that combined two receipts and a freight bill posted on its own make the sample worth more.

02

Items and item charges

Your items with their units, Net Weight and Unit Volume, and your item charge numbers with the G/L accounts behind them. Lists exported to Excel are fine.

03

Approval setup and vendor holds

Your Approval User Setup lines and workflow user groups, plus the vendors in the sample with their Blocked values and any entries put On Hold.

04

First an NDA, then copies

Signed before the first export. We get no Business Central user, license or web service key, and nothing touches your payment journals. If invoices can't leave the building, your reviewer helps us build look-alikes that keep the hard cases.

// Before it starts

Decided by the owner before a single invoice is pulled

The owner agrees each of these with us before your team exports anything from Business Central.

Settled firstOwner's call
Your reviewer
Named by the owner, often the AP lead or whoever maintains your approval user setup
Success criteria
Written down: which header and line fields must match, and how item charges and holds are scored
Sample
Chosen by your reviewer, with a combined receipt and a late freight bill in it
Price
A range for the live job, given before the test
NDA
Signed before any export

// How it's judged

Each draft scored against the purchase invoice your team posted

Same vendor invoices
Header and lines
Checked invoice by invoicePosted in Business CentralThe AI draft
Vendor and Vendor Invoice No., with numbers already used flaggedFrom your invoicesFrom your invoices
Posted receipt lines pulled in, and any left outFrom your invoicesFrom your invoices
Quantities invoiced against what was receivedFrom your invoicesFrom your invoices
Unit cost differences against the orderFrom your invoicesFrom your invoices
Freight as an item charge, with its assignment methodFrom your invoicesFrom your invoices
The approver the invoice would route toFrom your invoicesFrom your invoices
Blocked vendors, and invoices that belonged On HoldFrom your invoicesFrom your invoices
Nothing in it yet. Every cell waits for your own invoices to be drafted.The scores are your reviewer's, row by row.

// After a yes

Roughly 30 days of new vendor invoices, with a person approving each draft

With a yes against the success criteria, new vendor invoices get the same drafting for about 30 days.

A person on your AP team approves, corrects or rejects each draft before a purchase invoice exists in Business Central, and your approval workflow still runs after that. Your partner or in-house admin picks the route for approved drafts, typed in from the sheet or brought in by an import you already use. Posting and payment runs stay with your team.

// Later, one at a time

What could come after AP on Business Central

Ranked possibilities
One job live before the next
  1. 01

    Purchase credit memos

    Vendor credit notes for returns and short shipments drafted as purchase credit memos, applied to the invoice they reduce, for AP to check.

    Next
  2. 02

    Received but not invoiced

    A month-end list of posted receipts still waiting for an invoice, with the vendor and order behind each, for the controller's close.

    Then
  3. 03

    Sales orders from emailed POs

    Customer POs drafted as sales orders for your order desk to review before anything is released.

    After that

// One hard limit

It never approves, posts or pays a purchase invoice, and we never log in to Business Central.

Drafts stay on a review sheet until a person on your team approves each one, and posting and payment journals remain yours. We hold no Business Central user or license, install no extension or AppSource app, and claim no integration, partnership or certification with Microsoft. Business Central and Dynamics NAV appear here only because they name the system you run. Business Central, Dynamics 365 and Dynamics NAV are trademarks of the Microsoft group of companies.

One job, one price: a range before the proof of concept, a fixed price before you sign.

The range follows how many vendor invoices your AP desk posts in Business Central a month, and how many combine receipts or carry item charges.

// Questions

Questions from Business Central payables teams

Do you install anything in our Business Central tenant?
Nothing at all. No extension, no AppSource app, no user account and no web service key on our side, and we claim no integration, partnership or certification with Microsoft. Your team sends exports and invoice copies, the drafts come back on a review sheet, and we never log in to Business Central.
Doesn't Business Central have its own Payables Agent?
Microsoft's help describes a Payables Agent that reads PDF invoices from a monitored mailbox, prepares purchase document drafts for a person to review and doesn't post them. We have no connection to it. This proof of concept stands on its own: copies of invoices you have already posted, judged by your reviewer, with nothing running in your tenant.
Our company still runs Dynamics NAV. Can we take part?
Yes. The test runs on exports, so the version matters only for screen and field names, and NAV already had Get Receipt Lines and item charges, even where its screens look different. Get Order Lines and incoming invoice drafts are newer, so your reviewer writes the success criteria around the screens you actually have.
Can the drafts handle an invoice that covers two receipts?
Yes. That is what Get Receipt Lines is for, and the draft lists each posted receipt line it used and the quantity taken from it. Your reviewer checks those choices first, because once posted, an invoice built from receipt lines can only be corrected with a credit memo.
Which exports do you need from us?
Exports, not access: the posted purchase invoices in the sample with their lines, the orders and posted receipts behind them, your items with weights and units, your item charge numbers, and your approval user setup. Your own staff pulls them, as Excel files.
Rob Eason

Rob Eason, founder

// Book a call with Rob

Bring a month of posted purchase invoices from Business Central.

A 30-minute call with Rob. Booking asks for your company and role, the job to test, and about how many vendor invoices your AP desk posts in Business Central each month. Hold on to every invoice until the NDA is signed.

  • Co-owned a 60-employee financial services firm and sold his share to his partner.
  • Ran GOSO Technologies, a Boston solar company rated 5/5 across 24 Google reviews.
  • 5/5 across 83 reviews in HighLevel's Certified Admin Directory.
  • 4.3/5 from 6 Google reviews of Massmarket AI.
  • Every directory and Google review, critical ones included, is shown word for word at massmarket.ai/reviews.
  • Takes every proof-of-concept call himself.