Table 243

bma

Hi all,

I have a customer from france, and i get an error when i try to sincronize the database. The error message said that the table 243 is not found. In Spain databse doesn´t exist this table, has anybody know which table is the 243 table in a french database??

vanrofi

Don't know what you mean with synchronise...

Table 243 is table report List in versions before 4.0...maybe you are confronted with an upgraded version or something.

Please give more info than this...then you would have a response much quicker...

bma

My database is Navision version 4, and it doesn´t come from an upgrading.They began with this version last year. it is a SQL database, so when we choose Tools-->security-->sincronise, is when i get the error. I have thought that it is because the objects in spain and in Frnace doesn´t have the same numeration, so i would like to know if exists in Nav 4 an object numbered table 243, but it has to be in a french database.
thanks!!!

vanrofi

Not familiar with it...check maybe the roles and permissions. If you have a role with a defined permission on this table (?) it might generate this error...just a very wild guess though...

Savatage

You can have a fob of my Table 243.
If you want to import it and see it that helps?

It is a simple report list table.

keys: Menu ID,Line No.
My Fields: (probably just need 2 thru 7) hmm no 1?

Enabled	Field No.	Field Name	Data Type	Length
Yes	2	Line No.	Integer	
Yes	3	Text	Text	100
Yes	4	Report ID	Integer	
Yes	5	Report Name	Text	80
Yes	6	Menu ID	Integer	
Yes	7	Menu Name	Text	30
Yes	100	G/L Reports	Integer	
Yes	102	Sales Reports	Integer	
Yes	103	Sales Documents	Integer	
Yes	104	Purchase Reports	Integer	
Yes	105	Purchase Documents	Integer	
Yes	106	Item Reports	Integer	
Yes	108	BOM Reports	Integer	
Yes	110	Resource Reports	Integer	
Yes	112	Job Reports	Integer	
Yes	5000	Relationship Mgt. Reports	Integer	
Yes	5001	Relationship Mgt. Documents	Integer	
Yes	5200	Employee Reports	Integer	
Yes	5600	Fixed Asset Reports	Integer	
Yes	5750	Warehouse Reports	Integer	
Yes	5751	Warehouse Documents	Integer	
Yes	5900	Service Mgt. Reports	Integer	
Yes	5901	Service Mgt. Documents	Integer	
Yes	6201	Commerce Portal Reports	Integer	
Yes	10050	Payroll Documents	Integer

flesenne

Hello everybody,

I have exactly the same problem ("When security sync. we get error message : "Table 243 doesn't exist") , so i would like to know if you solved your problem and how ?
Thanks
Nav 5.01 / SQL Server 2008 R2