Failed to add field in my sales line table NAV

(0) Share

Report

Posted on by jllau

Hi,

I Tired to add few new field in my sales line table and after i add it in object design --> salesline Table --> Design
and compiled with no error. But user facing the following error while they doing posting. Anything i forgot to change? or anyway to define the field to accept NULL value?

Hope to get help from you guys.

Thanks.

*This post is locked for comments

I have the same question (0)

All responses (24)

Answers (0)

Suggested answer

Maneesha 5,891 on at

Like (0)

Report

You are going to insert null values (Empty values) to "Time Arrive Plant"

check your validation , if u wanna keep empty values , change your validation on the fields

please verify answer if you get helped to your issue

Was this reply helpful? Yes No
Suggested answer

Yogesh Kulkarni_ 1,762 on at

Like (0)

Report

Hi,

Please check the NotBlank Property of a field, you have added.

It should be No to non-primary fields in a table.

-Yogesh Kulkarni

Please verify, if you find answer helpful.

Was this reply helpful? Yes No
jllau on at

Like (1)

Report

Hi Maneesha,

yeah.. i would like to keep empty value at the moment, as the field will be use for my GPS data. So while they are doing posting to Sales Line table, the value is 0 or empty.

by the way, where to check the validation on the field?

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

Hello,

You will run into this issue if the change are sync, using Tool -> Security Run the Synchronization for that user or for all users.

Was this reply helpful? Yes No
jllau on at

Like (0)

Report

Hi Yogesh,

attached is the field properties.
i change "enable" to no because if i enable it ... my staff cannot do any posting that related to sales line table.

Was this reply helpful? Yes No
jllau on at

Like (0)

Report

Hi Suresh,

Not understand.. could you explain in more detail?

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

Check this link you need to update security, check page 8 in the PDF link for the steps to perform.

https://dynamicsuser.net/nav/m/documentation/3851

Was this reply helpful? Yes No
Suggested answer

Maneesha 5,891 on at

Like (0)

Report

Hi jllau

go to your Microsoft Dynamics NAV Development tool ==> go to relevant table ==> right click and design

Keep your relevant data field with acceptable null values

Its grate to help if you verify the answer

Was this reply helpful? Yes No
Suggested answer

keoma 32,729 on at

Like (0)

Report

goto menu entry "Tools/Security/Synchronize All Logins" in classic client (development environment), then close the classic client, re-open it, try again.

Was this reply helpful? Yes No
jllau on at

Like (0)

Report

did u meant just synchronize all login will solve the problem? but why it related to login security? and will it affected / corrupted my database if i run the synchronization? i got no testing environment so can't take the risk to test it......

Was this reply helpful? Yes No