Forum Discussion
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.
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.
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?
