Forum Discussion

wesleyhillautos's avatar
wesleyhillautos
Contributing User
3 years ago
Solved

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 :)

LRBooks61's avatar
LRBooks61
Ultimate Cover User

Hi Donna,

 

Indeed you are correct, it is only looking at the new supplier info card so you need to manually check that haven't doubled up your invoices

 

Reconciling your Supplier Statements is also a great way to ensure invoices arent entered twice

 

You will need to determine which invoices belong to which supplier card and delete where possible

 

Hope this helps

 

Lisa

 

 

wesleyhillautos's avatar
wesleyhillautos
Contributing User
3 years ago

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 :)