Hi folks

Anyone know of a simple, fast way to find the highest debtor number in a certain group?

I've been tasked with creating debtors (within a predefined group), starting with debtor number 1000000.

I know I can get all debtors in the group and then iterate them to find the highest debtor number in use - but I was wondering if there is a better way?