How to Add field in Nav existing table ?

Business Central/NAV Developers Forum
1

Hi expert,

I want to add a field in Customer /SalesOrder .When i am going to add field then a error message “we don’t have permission” .But we have a developer license and able to add new table. Please give me suggestion how to add a field in NAV table.

Thanks

Surajit

2

You need to add field using super user. Your user id should have super rights.

3

Hi Amol,

You want to say that i am not super user ? But i am able to added new table . Can you told me please how to create super user ?

Thanks

Surajit

4

You can use default ‘SA’ user if you r using SQL Database.

5

Hi amol

No, i am using Nav Object Designer and also loging with sa user. Then how to create super user?

Thanks

Surajit

6

‘SA’ is basically a super user .You can add field using Developer License/Customer license.

What is field no you r giviing to new field ??

7

Hi Amol,

I have developer license .Field no is ‘7602’ which value is auto-generated by nav during add a field in Customer .I specifying only field name .

Thanks

Surajit

8

What are trying to do ??

Are you trying to Add the new field or changing the name of existing field.

9

Hi amol,

I am trying to add new field in Customer table.

Thanks

Surajit

10

You can use any ID between 50000 and 99999.

Not below that and not above (except for very Special cases)!!!

11

HI Thomas,

Thanks for reply .