One constraint I'm dealing with on a project is for all order numbers to be consecutive in nature.
Current: 1000, 1001, 1003, 1004, 1008, 1010
Desired: 1000, 1001, 1002, 1003, 1004, 1005
Problem Statement
Accounting systems can only record sales receipts and invoices in consecutive numbers. If a non-consecutive number comes through, the accounting system is forced to rewrite the number to a consecutive number.
When that happens, Magento and the accounting system are no longer synced by transaction number. I have a clear understanding of why Magento does not store consecutive order numbers - due to sales quotes being created before order is transacted.
Requirements & Question
The requirement is to keep some form of sync between Magento and the accounting system. That means a transaction number or another identifier.
Questions
- Is there a way to maintain consecutive order numbers in Magento without breaking the core?
- Is there another common identifier that can be used between the accounting system and Magento if the transaction numbers don't sync up?