Invoice number already exists - check

It is frustration to get all the way to the end of entering an invoice - sometimes many lines - to then get the warning "this invoice already exists". Can the check be initiated as soon as a combination of invoice number and supplier number is entered?

ADMIN RESPONSE

Jun 28, 2018

Unfortunately the check is only performed when the invoice / bill is saved. Until then the database is unaware of what number has been entered. The workaround, if this is a constant issue, is 1 of 2 things:

• Create an invoice list report (memorised) and sort by invoice number. This can be used to alert the user what the last (highest) invoice number was. Once the first new number is created they will increase sequentially.
• Quickly save the invoice after the first line is created and then continue to edit the invoice once the invoice number is validated.

** The invoice list is often a good idea when the invoice numbers are constantly being manually altered.

Attach files

Enter a subject

Please enter your email address

RELATED IDEAS

Invoice number already exists - check