Problems with the Account Schedule in SQL Database

esl · 2007-05-05

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 · 2007-05-05

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 · 2007-05-06

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

kriki · 2007-05-08

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 · 2007-05-08

This article explains it in a little more detail:

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

Problems with the Account Schedule in SQL Database

Comments

Categories