Where can I find the sort order or index of the lists (for example, chart of accounts) so my reports based on exported information will print in the order they appear in the QB Lists.

Thank you!

You can sort the list any way you like using a ORDER BY clause, for example:

SELECT * from Account Order by AccountType

SELECT * from Account Order by AccountNumber

SELECT * from Account Order by FullName

Thanks.  I was actually looking for the sort order that is maintained in QB.  For example when you open a list, you can move the items around to place them in the order you want to see them on your reports.  The order is maintained when you generate the reports.

When I pull the data out via SQL, I have not found a way to print them in the same order they have in the list view in QB.  They will print either alphabetically or in an order specified by the sql statement as you have shown below.

For Example if my chart of accounts lists expenses for Salaries & Wages, Employee Benefits then Travel.  I want them to print out in that order.  I thought the straight output from SQL might have them in the order I see them in the List view in QB, but it brings them out in order entered.

I was looking for some sort of index that might be used to maintain the sort order in the List View of the accounts.  Thanks for your help!