Item numbers are auto sequenced but not in the same order of FBDI

Summary:

Items are being imported via FBDI and item number generation method is set as 'auto sequenced' in item class. I have given item numbers and descriptions till row 1000 in FBDI. when item is created, it is not in an order given in FBDI; auto sequenced item number is assigned to random rows from FBDI. Example: row1000 is created first, then row 500, then row1 etc.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

24C

Code Snippet (add any code snippets that support your topic, if applicable):