Forum Discussion

wesleyhillautos's avatar
wesleyhillautos
Contributing User
3 years ago

Duplicate supplier invoice numbers

Hi, I have been using the purchases in tray upload saved emailed invoices via the in tray, all working well until that last few weeks. We had a supplier change their bussiness information and invoici...
  • wesleyhillautos's avatar
    wesleyhillautos
    3 years ago

    Hi Lisa, I did as you suggested but it didn't resolve the issue. I have figured it out now though, so posting so others can see.

    When adding the invoice through the intray MYOB was pre-filling the previous supplier as the names were similar (Automotive Brands Group and AutoPro). I was changing these details, but I guess the system was not recognising it. I made the previous supplier card inactive then uploaded the invoice again. It then detected the new supplier and correclty pre-filled this information instead, then when I clicked create new bill it sucessful warned for the duplicate supplier invoice number :)

wesleyhillautos's avatar
wesleyhillautos
Contributing User

Hi Lisa, thank you for your reply.

 

The new supplier invoice numbers are different to the previous supplier invoice numbers eg 1090115 vs 115608 so they are not duplicating across the two cards, its only the new supplier invoices, which the system should be picking up and warning me about? eg I have two records for 113480,113759 and 115814 (see screen captures attached).

 

Also how do I reconcile supplier statements as you suggest?

 

Regards

Donna

LRBooks61's avatar
LRBooks61
Ultimate Cover User
3 years ago

Hi Donna,

 

I wondered if it had something to do with coming in from the intray and checked - there have been issues in the past I see

 

One suggestion is to change your preference ( in both purchases and sales tabs) using the drop down arrow to both invoices and orders

 

Try that and test to see if it works .

In the meantime delete the duplicates.

 

To reconcile a supplier statement

 

When your receive the statement you check off the invoices on your myob file against it as you would a bank statement

You can use the aged report in the first instance to see if it is the same as the supplier and you know it is all good

 

If there is a discrepancy you can run a detailed report and check what is either missing or duplicated

 

Hope this helps

 

Lisa

 

 

 

 

  • wesleyhillautos's avatar
    wesleyhillautos
    Contributing User
    3 years ago

    Hi Lisa, I did as you suggested but it didn't resolve the issue. I have figured it out now though, so posting so others can see.

    When adding the invoice through the intray MYOB was pre-filling the previous supplier as the names were similar (Automotive Brands Group and AutoPro). I was changing these details, but I guess the system was not recognising it. I made the previous supplier card inactive then uploaded the invoice again. It then detected the new supplier and correclty pre-filled this information instead, then when I clicked create new bill it sucessful warned for the duplicate supplier invoice number :)

Looking for something else?

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

Community home

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