Forum Discussion

SDSTLMAN's avatar
2 months ago

Removal of leading zeros for Quote/Order Numbers

Hi, 

After years of using MYOB have we had started having the issue where the leading zeros get removed on a new sale and it creates the order with an older number which has already been used (albeit with the leading zeros). This causes a downstream issue for us as the MYOB recognises the leading zeros whereas other software we have removes them, so duplicates become an issue.  

None of our team have manually changed a sale to remove the zeros which would create a new sequence.

Has anyone else experienced this issue, or is there something else you can think of that might be causing this to happen now?

Let me know if you need clarification

 

Thank you

 

  • Hi SDSTLMAN,

     

    The issue with leading zeros being removed and causing duplicate order numbers happens because different systems handle numbers differently. For example, Excel often strips off leading zeros. To fix this, make sure your numbering settings in MYOB are set up correctly. You can reset the auto-numbering sequence by manually typing in the invoice number. The software will remember this for the next sale. If it doesn't pick up the sequence right away, just keep manually entering the invoice number until it does.

     

    Cheers,

    Princess