We have been exporting a supplier report using Record ID and last name. Previously sequential b ...

Question

ut now not.  How do we fix this please.

Mike_James · Answer

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?

MM2 · Answer

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.

Mike_James · Answer

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.