Problems with the Account Schedule in SQL Database

esl

Hello,
I am running a Navision 3.70 Database in SQL Server and when i'm trying to generate the overview of the Account Schedule it's produce an error:
"Circular Reference", i don't know what is wrong because when i trying to do the same in a Navision 3.70 native everithing going fine.

Please, somebody help me!!!

Alex_Chow

When you setup your row numbers, make sure you use alpha numberic instead of just numeric.

So instead of
100
110
120

do

A100
A110
A120

diptish.naskar

Do try to test the database in SQL, this might be of some help

kriki

This is because SQL sorts data differently from Navision.
Eg. in one the string '9' comes before the string 'A' and in the other it is the other way.
So you need to create your codes differently or recreate your formulas differently.

David_Singleton

This article explains it in a little more detail:

http://wiki.dynamicsbook.com/index.php?title=Sorting_in_NAV_vs_SQL