Sorting order change from Native to SQL in NAV

Asiri

Hi,

We have converted NAV Native DB to SQL 2000. Now all the records in the Chart of Accounts and Dimensions has changed their order. Earlier it was like 100, 110, 120,...... 1000.

Now this has changed as 100, 1000, 110, 120...... And our Begin Totals & End totals has gone mad. Is there any solution for this.

Please help me on this.

Thks,
Asiri

garak

Take a look into the properties of these field (in table designer)
There is a property for SQL. Here you can change the SQL Datatype and the order.

For more questions, search the forum, there are many posts about this..

Regards

kriki

garak wrote:

Take a look into the properties of these field (in table designer)
There is a property for SQL. Here you can change the SQL Datatype and the order.

For more questions, search the forum, there are many posts about this..

Regards

Yes, but you should change the property on ALL fields where G/L Accounts are used. This means also "No." in sales line and in those you can also put items....
So in short it is better to rename the G/L accounts.

ajhvdb

kriki wrote:

So in short it is better to rename the G/L accounts.

To what? 100 = 000100

Asiri

Thks sir

ara3n

ajhvdb wrote:

kriki wrote:

So in short it is better to rename the G/L accounts.

To what? 100 = 000100

I would add a one at the beginning of the account no.

100 = 1000100
1000 = 1001000

kriki

The idea for renaming is that in every account you have the same number of digits and not a variable number.

Waldo

If you do go for changing the SQL datatype - change it to Variant to avoid problems with the AltSearchField.