Do not have permission to modify records

lakshanvindana

hi all,

Please give me a solution for this issue.

---

One of the customer user getting this message, its purely the modification you did to customer, (if non inventory item update the job ledger entry at the time of posting the invoice), but I have given sufficient permission to the user as you can see below . but still user getting the same message. Do you need to do any code change ? they close NAV and restarted and restarted the computer also but not working.

mohana_cse06

Did you synchronize the logins after modifying?

navvenkat

Are there new fields added in Job Ledger Entry table where the Field ID is out of permission range(License).

lakshanvindana

thanks for reply

@ Mohana
this is 5.0 native

@navvenkat
yes, we have added new 50000 series field, and updating by a function

ssingla

Posted entry tables can't be modified by client license except when specific table modification permission is set with a Partner License.

Check for permission property on the form.

hansika

ssingla wrote:

when specific table modification permission is set with a Partner License.

You mean to say partner license also cannot modified all posted tables and Ledger entry tables . If yes, can you post some table names ?

ssingla

hansika wrote:

ssingla wrote:

when specific table modification permission is set with a Partner License.

You mean to say partner license also cannot modified all posted tables and Ledger entry tables . If yes, can you post some table names ?

I never said that partner license cannot modify tables, but I said Partner License is required for setting permission to tables to enable Client License to modify posted table. However the option should be used sparingly with extreme caution.

David_Singleton

lakshanvindana wrote:

hi all,

Please give me a solution for this issue.

Contact your partner that made the customizations and have them sort it. As part of development they should have tested this before delivering the code to you.

hansika

ssingla wrote:

Partner License is required for setting permission to tables to enable Client License to modify posted table. However the option should be used sparingly with extreme caution.

From the above statement what i have understood is using partner license if we give the table modify, delete permissions - yes for posted tables. Then client license also can allow to modify the posted tables and ledger tables.

Am i right ? :-k

ssingla

Yes.

Savatage

hansika wrote:

From the above statement what i have understood is using partner license if we give the table modify, delete permissions - yes for posted tables. Then client license also can allow to modify the posted tables and ledger tables.

Am i right ? :-k

I don't know if I agree with that. What do you mean by modify. Open the entire table to editing? If permissions alone were enough for client license to modify posted tables and ledger entries then why cu391?
Are you talking indirect changes by code?
Where's this code in the post sales order cu?

ssingla

Savatage wrote:

hansika wrote:

From the above statement what i have understood is using partner license if we give the table modify, delete permissions - yes for posted tables. Then client license also can allow to modify the posted tables and ledger tables.

Am i right ? :-k

I don't know if I agree with that. What do you mean by modify. Open the entire table to editing? If permissions alone were enough for client license to modify posted tables and ledger entries then why cu391?
Are you talking indirect changes by code?
Where's this code in the post sales order cu?

CU 391 is the way to allow modifications with Client license where such license cannot modify the data directly even in the table.

vijay_g

Savatage wrote:

I don't know if I agree with that. What do you mean by modify. Open the entire table to editing?

Even then they can't make change in posted table with customer license.

I think the permission is about to the object(setting by permission property of object) through that they are modifying(by code) posted table.

ssingla

vijay_g wrote:

Savatage wrote:

I don't know if I agree with that. What do you mean by modify. Open the entire table to editing?

Even then they can't make change in posted table with customer license.

I think the permission is about to the object(setting by permission property of object) through that they are modifying(by code) posted table.

Vijay you are wrong. The permssion can be given on the "form" too. This will allow user with client license to modify values in the form without any coding.

vijay_g

Yes..!! i knew this but is that possible in practical scenario to give permission directly to a posted form for modify?

As i understand about modifying posted record with this post is to give permission for a object(that is begin used in a process and that can not be a posted form directly).

David_Singleton

ssingla wrote:

The permssion can be given on the "form" too. This will allow user with client license to modify values in the form without any coding.

[-X NOOOOO you should never do this. :thumbsdown:

skulla

Give permission to the posting codeunit in this case 90 purch.-post. Open properties for this codeunit and you have option to specify permission for tables.

ssingla

David Singleton wrote:

ssingla wrote:

The permssion can be given on the "form" too. This will allow user with client license to modify values in the form without any coding.

[-X NOOOOO you should never do this. :thumbsdown:

When in my post I said you should do it? I just said it is possible and which is a fact. I have already given the warning against the use of option.

lakshanvindana

thanks guys :thumbsup:

lakshanvindana

skulla wrote:

Give permission to the posting codeunit in this case 90 purch.-post. Open properties for this codeunit and you have option to specify permission for tables.

thanks, it works :thumbsup: =D>