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

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. 

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.

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.

I wish that were so but previously we put did the same thing ID first to ensure that it was sequential and then the name matched the number.  That we don't need in alphabetical order.  Just the numerical sequence and we have no idea why that has changed.  Is there an easy way to find a record ID.  I feel sure that this will come up more.

Hi MM2 , the record ID is not accessible from the core program in any other way. And specifying the record ID as the first field doesn't indicate a sort order, as far as I know (going back years). However, changes are sometimes made to the (import/export) program that are not publicised. 

Why does the list need to be sorted in any way?