Acc. Schedule & SQL Server

Business Central/NAV Technical Forum
1

Hi Has anybody ever experienced an error while using Acc. Schedules on a SQL DB ? Create an Acc. Schedule (any version 2.60.3.10,3.60) with an entry which has Totaling Type = formula and totaling = 20…100 or 50…100 And then go to overview for that Acc. schedule. It gives following error: “You have entered an illegal value or a nonexistent row No. …” Any Ideas…?

2

Remember that Code fields are defined in SQL as VarChar (unless you change the SQLDataType) You can try: 1. Maintain as Varchar and - use alphanumeric rows id or - number the rows with fixed number of digits and then on formula: 020..100 or 050..100 2. Change SQLDataType to Variant (SQL 2000) Hope this helps

3

Thanks a lot Soage. It works.

4

The Other solution is to Use the an Alphabet in the Row No. A10,A20,A30… This will not need any change to the datatype.