Cannot Open Table in Design Mode After Deleting 1 Field

rajeshreepatel

Hi everyone,

I have created 6 tables in Navision for Consignment Module which are as follows:
1) Consignment Header
2) Consignment Line
The above 2 tables have Document Type field with option string: Outward and Return. All the consignment outward and return entries will be added here first. After posting it will move to the following tables respectively.

Outward entries will goto -
3) Consignment Sales Header
4) Consignment Sales Line

Return entries will goto -
5) Consignment Return Header
6) Consignment Return Line

Now the problem is Consignment Sales Line table is not opening in Design and its giving me the following error:
FIELD NUMBER 1 IS NOT DEFINED IN THE CONSIGNMENT SALES LINE TABLE.
BECAUSE i have deleted Document Type field from Consignment Sales Line table as it was not required there and i had added it before.

Also the other 2 tables Consignment Line and Consignment Return Line is also giving me the same error. Though i can Run the tables and see entries in it.

Note: i have not deleted Document Type field from Consignmenrt Sales Header Table. I can open that table in design mode.

Can anyone help me and suggest some solution for this matter. How will i able to open this tables again?

Waiting for replies. Thanking you.

Rajeshree.

william_marcelinus

Perhaps this has something to do with code where you posting the consignment to consignment sales line,
if you delete related (link) field in table, some data may not change / deleted.
if you could try F11 (Compile) all objects related to your project, to see if some field not properly call or not match.

rajeshreepatel

Thank you mr. william_marcelinus for your quick response.

I tried compiling all my consignment tables but still same error is shown for all my line tables.

Pls suggest anything else i need to do for checking out this error.

rajeshreepatel

Hi,

Problem solved by reimporting the table object again with the missing field.