BC Tip #20 - Prevent Duplicate Vendor Invoices in Business Central
- Ben Cole
- Jun 22
- 5 min read
The only thing worse than paying vendors is paying the same invoice twice.
If you work in Accounts Payable inside Dynamics 365 Business Central, there is one small setting that can save you from a very expensive mistake.
It lives in Purchases & Payables Setup, and it is called External Document Number Mandatory.
It is one checkbox, but it adds a real layer of protection against duplicate vendor invoices.
Let's dive in.
Table of Contents
Why this setting matters
When this setting is turned off, users can leave the vendor invoice number blank. That creates a problem right away.
Business Central needs an external invoice number to compare against previously posted invoices.
If there is no number entered, the system has nothing to validate. That means the same vendor invoice can be entered and posted again without any duplicate warning.
Basically, f the field is optional, duplicate payments become much easier to slip through.
Where to find the duplicate invoice protection
Go to Purchases & Payables Setup and look for the Ext. Doc. No. Mandatory toggle.
This is the control that forces entry of the vendor's invoice number and enables duplicate checking against posted vendor invoices.
What happens when External Document Number Mandatory is off
With the setting off, you can create a purchase invoice and leave the vendor invoice number empty.
That means you could take an invoice that was already posted last week, enter another invoice for the same amount, and post it again without the system stopping you.
In the example (video) shown above, a $1,300 invoice was entered again and posted successfully with no error.
That is exactly the kind of simple human mistake that leads to duplicate vendor payments.
What changes when you turn the setting on
Once External Document Number Mandatory is enabled, two things happen immediately:
The vendor invoice number can no longer be left blank.
Business Central starts checking posted invoices for duplicate external document numbers for that vendor.
So now, instead of relying on memory or manual review, the system helps enforce a basic but critical control.
How the duplicate check works in practice
Here is the test.
After turning the setting on, enter the actual vendor invoice number into the purchase invoice. In the example, the invoice number used was 1234, which had already been posted for that same vendor.
As soon as that number is used, Business Central flags it. The system shows an error indicating that the invoice number has already been used and needs to be changed before posting.
The warning is visible right on the document, and if you try to post anyway, you get stopped again.
This is the key benefit. It does not just suggest that something might be wrong. It actively prevents the duplicate from being posted for the same vendor.
Important limitations to know
This setting is useful, but it is not magic. There are a few boundaries you need to understand so your team knows exactly what it does and does not cover.
1. It checks against posted invoices
If you have two open purchase invoices with the same vendor invoice number, Business Central will not necessarily stop you right away.
The duplicate validation happens against posted invoices. So two open invoices can exist with the same number until one of them gets posted. After that, the duplicate check kicks in for the next posting attempt.
2. It does not check across companies or environments
If you work in multiple companies inside Business Central, or across separate environments, this validation stays within the current company context.
So if invoice 1234 exists in another company or environment, that will not trigger a duplicate warning here.
3. The check is vendor specific
This is another important detail.
The same external invoice number can exist for two different vendors without causing an error. That is intentional. Different vendors can absolutely issue invoices that share the same number.
Business Central only treats it as a problem when the duplicate belongs to the same vendor.
What this checkbox really gives you
No ERP setting can remove all human error.
But this one gives your finance and accounting team a solid control at the point of entry. If someone accidentally tries to post the same invoice twice for the same vendor, Business Central can catch it before the duplicate payment goes out the door.
That is a high-value improvement for such a simple setup change.
Sometimes the best Business Central tips are not the flashy ones. They are the quiet little settings that prevent costly mistakes.
Recommended takeaway for Accounts Payable teams
If Ext. Doc. No. Mandatory is still off in your environment, it is worth reviewing (and turning on) as soon as possible.
At a minimum, enabling it helps you:
Require entry of the vendor's invoice number
Reduce the risk of duplicate invoice posting
Add a cleaner control to your AP process
Prevent duplicate payments for the same vendor invoice
For many organizations, that one checkbox is an easy win (and a non-negotiable in my book on all of my client projects).
FAQ
What setting prevents duplicate vendor invoices in Business Central?
The setting is External Document Number Mandatory in Purchases & Payables Setup. It requires the vendor invoice number and helps Business Central detect duplicate posted invoices for the same vendor.
Does Business Central prevent duplicates if the vendor invoice number is blank?
No. If the setting is off and the field is left blank, the system has no external document number to compare, so duplicate invoices can be posted without that specific validation.
Does duplicate checking work on unposted purchase invoices?
Not in the same way. Two open invoices can exist with the same invoice number. The duplicate warning is triggered when a posted invoice already exists for that vendor and invoice number combination.
Does Business Central check for duplicate invoices across different companies?
No. The validation does not look across other companies or separate environments.
Can two different vendors use the same invoice number?
Yes. The duplicate check is vendor specific, so the same invoice number can be used by different vendors without creating an error.
Ready to optimize your Business Central environment with guidance from a BC expert?
Contact Ben Cole at Ben@BenColeBC.com or (214) 433-0923.
Don't forget to subscribe so that you never miss a weekly tip.
Ben Cole is passionate about making Microsoft Dynamics 365 Business Central work smarter for real people—users and partners alike. With roots in public accounting, Ben’s seen firsthand how automation and clever solutions can transform the Business Central experience. He’s known for breaking down complex topics with a dash of wit and plenty of practical advice. If you want to get more out of Business Central (and maybe even enjoy the process), Ben’s your go-to guide.
(214) 433-0923
Comments