Forum Discussion

MM2's avatar
2 years ago

We have been exporting a supplier report using Record ID and last name. Previously sequential but now not. How do we fix this please.

  • Sean_DC's avatar
    Sean_DC
    Former Staff

    Hi MM2 

     

    Thank you for your post. May I extend a warm welcome to the MYOB Community Forum.

     

    I would like to ask if it's the bill reference number that is not sequential. If that's the case, this is a known concern that is still under investigation. The workaround for the software to 'remember' a new sequence, is to manually change the invoice number to the desired number. After doing this manually for about 5-7 invoices (enter 00000200, 00000201, 00000202, etc), the software will 'remember' the new sequence and automatically process this for any future invoices.

    If you're referring to a different concern, please let me know which sequence is out of order. 

     

     

    Please feel free to post again. I'm happy to assist further.

     

    If my response has answered your enquiry please click "Accept as Solution" to assist other users in finding this information.

     

    • MM2's avatar
      MM2

      We have engaged a company for payment verification purposes.  They require a customer number.  If you can tell me where to access that easily that would be great but previously we would go to File, Import/Export Assistant, Export, Card, Suppliers.  Then we would select Record ID first and then Company last name.  Previously this would come out in numerical order.  For some reason it has stopped doing this.  Are you able to help please.

      • Mike_James's avatar
        Mike_James
        Ultimate Cover User

        Hi MM2 , a possible cause is that the supplier cards are exported in alphabetical order, and so far as the record ID is also in sequence, that reflects the initial uptake of supplier cards, possibly by importing them. Subsequent additions to the card list occurred in random alphabetical order, but were assigned record ID's sequentially from the last one. Hence the exported record IDs will only be partially in numeric order.