We are using MSSQL to manage different systems, we use the input from Great Plains and then we post some information to other systems.

I started having some problems and we post a big invoice, the order was not correct. If I print the invoice the order was the correct one but if I open the MSSQL table, the order was not correct. After several test I found that if I sort using DEX_ROW_ID, I'll get the order order. Is this correct?

What is the best way to sort the table in base of the time when the row was created?

Thanks,
Monica