Forum Discussion

H-TS's avatar
H-TS
Trusted User
2 months ago

Duplicate sales invoice numbers

Hi, 

 

Today I turned on the option to have a different number sequence for orders, quotes and invoices. Then I spent the afternoon sending invoices before realising that I'm no longer getting the warning for duplicate invoice numbers and every invoice I sent this afternoon is a duplicate number.

 

What happens if any of the recipients want to pay with online payments? Will the system still work out who they are and what their invoice amount is?

 

I've submitted a support request but thought maybe I'd get a quicker answer here. Anyone else experienced this?

 

I've now forced the numbering to skip a few to the numbers that are actually free but if someone deletes an incorrect invoice this might cause the issue to happen again.

 

I've checked that the 'warn for duplicate invoice numbers' setting is still turned on in preferences.

 

 

7 Replies

  • Albare's avatar
    Albare
    Trusted Cover User
    2 months ago

    When I fiddled with this option I forgot to manually enter in the next Sales Number, for the various Sales Types in the respective fields where this option is turned on. Hence, I also created duplicate invoice numbers for a day.

     

    You just have to go and enter the next Sales number for each type of sales in the setup tab of sales numbering and hopefully no duplicates will be created.

     

    I just checked again and if I turn on the function the next invoice number it would create is 32500398 when we are actually up to 32500416 so I would need to enter 32500417 in the Sales number field.

  • H-TS's avatar
    H-TS
    Trusted User
    2 months ago

    Thanks Albare, I did manage to change that before posting but I'm still concerned about the warning not coming up and what's going to happen to the invoices I've already sent.

  • Albare's avatar
    Albare
    Trusted Cover User
    2 months ago

    Luckily my advice was free...as it didn't add any help :)

  • Albare's avatar
    Albare
    Trusted Cover User
    2 months ago

    Interesting to see what the answer is, you would hope online matching has a selection matching algorithm of say - Customer name/Invoice#/amount paid .... and if those fail it prompts to ask you to decide who to allocate the payment to.

  • H-TS's avatar
    H-TS
    Trusted User
    2 months ago

    Thank you for your free assistance :)

     

    MYOB support replied that this is a known issue and added me to the list of customers to be notified when there's a fix. They conveniently closed my support case while still ignoring my question about whether there will be any issues with customers choosing the online payment option. Guess I have to trust that it'll work.

     

    Hahahahahaha

  • H-TS's avatar
    H-TS
    Trusted User
    2 months ago

    Further reply from support:
    "About your query, when customers receive payment emails, each email contains a unique payment link assigned to that particular customer, even if there are duplicate invoice numbers. This system ensures that each customer is directed to their specific invoice for payment. Consequently, customers will not encounter issues when accessing and paying the correct invoice online, regardless of any duplicated invoice numbers."

    That's a relief. Could still be an issue I imagine, if people wanted to pay by bpay since they wouldn't have unique reference numbers but fortunately we have that option turned off.