Forum Discussion

SDSTLMAN's avatar
SDSTLMAN
Member
1 year 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

 

1 Reply

  • Princess_R's avatar
    Princess_R
    MYOB Moderator
    1 year ago

    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

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Learn:

 

Level up your skills using MYOB software.

 

Find help guides and technical solutions for all MYOB products here

Explore video tutorials for our software at the MYOB Academy here

 

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.