Issue with Order/Invoice Number Sequence

Hi,

Could you please assist with an issue we're experiencing around our numbering sequences?

We've configured our system so that order numbers and invoice numbers follow the same sequence, while quotes use a separate one. Previously, this worked seamlessly whenever we created an order or invoice, the system would automatically pick up the latest number from either sequence and increment accordingly.

However, this is no longer functioning as expected. We're now having to manually adjust both order and invoice numbers, which defeats the automation we had in place.

For example:
If the last order/invoice number used is 00327326, creating a new invoice correctly generates 00327327. But when an EDI order comes through, instead of continuing from 00327327, it reverts to 00327326, which has already been used causing duplication and confusion.

Could you please advise on how we can resolve this and restore the automated sequencing? We have tried fixing it from the Set-up and going to Sales Numbering but until now we can't resolve it. We are using MYOB Account Right.

Thanks so much,
Victoria