Extra Check on Invoice Creation: Vendor Invoice No.

In standard Business Central there is a check on double vendor invoice numbers, for the same vendor, when posting the invoice. In some environments this check is too late, as an invoice can be part of an approval flow and can be received on paper and by mail. this case it can happen that the same invoice goes twice through the approval flow.

Business Central Accelerator has put the double invoice number check on the invoice entry, when the field Vendor Invoice No. is validated. This way, an invoice cannot be ’prepared’ twice.

Setup

No setup is required for this functionality, Business Central Accelerator will automatically do the check on double vendor invoice numbers when validating the Vendor Invoice No. field on the purchase invoice header.

Execution

1. Choose the icon, enter Purchase Invoice
2. Choose the New action, don’t post the invoice yet.
3. Create another invoice, for the same vendor, and enter the same Vendor Invoice No. The comparison is made by the field Bill-to Customer No. and Vendor Invoice No..
4. Press enter or tab. On the moment you press, for example, enter or tab, Business Central validates the field, and Business Central Accelerator checks whether the Vendor Invoice No has already been used on another purchase invoice for the same vendor. Since the same Vendor Invoice No was used, Business Central will show the following error:purchase invoice xxxxx already exists for this vendor.

When the user creates a new purchase invoice, and a posted purchase invoice already exists for the same vendor with the same Vendor Invoice No, Business Central Accelerator will also give this error message when validating the Vendor Invoice No field. The comparison is made by the field Bill-to Customer No. and Vendor Invoice No..