I'm currently running an Magento 2.2.9 shop and investigate an issue where invoice sequence numbers gone missing.

For example we have an order and by simply clicking the send invoice button, the System creates an new invoice with the old one nowhere to be found.

So I investigated this in the Database:

SELECT entity_id,increment_id FROM `sales_invoice` where increment_id BETWEEN 'OS-R-045315' and 'OS-R-045317'

As you can see OS-R-045316 is clearly missing.

So my questions are:

  • Why does magento delete invoices? What could trigger such an behavior?
  • Is there any audit trail, where i can find missing invoice sequences?
  • Is there an way to ensure all invoice numbers could be found within magento?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.