Small and medium business | Business Central, N...

Permission to modify entry

(0) Share

Report

Posted on by Morten Steengaard

555

Hi experts,

I use NAV 2016.

I need to change a few fields on a single Item Ledger Entry record.

I have made a new codeunit that would do the trick, if only I had the permissions to modify Item Ledger Entry.

I am SUPER.

When I try to add the Modify permission to the properties of the codeunit, it says that I do not have permissions to modify that record.

What am I doing wrong?

(I have also tried to put my code in OnOpen on the Item Card page. There I can add the permissions, but when I open the page, I get the same error.)

Hope you can help...

I have the same question (0)

All responses (12)

Answers (0)

Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report

Hi,

Please open your Codeunit and go the Codeunit Property and provide the Permission property with your Table - Item Ledger Entry.

Was this reply helpful? Yes No
Morten Steengaard 555 on at

Like (0)

Report

Hi Nitin,

If I enter "TableData Item Ledger Entry=m" and save my codeunit, it says something like "You do not have permissions to modify records in the table Item Ledger Entry".

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report

Please try to give permission = rm

Thanks.

Was this reply helpful? Yes No
Morten Steengaard 555 on at

Like (0)

Report

Now I have tried with rm, rimd and m. Same result.

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report

Have you written your code to modify ILE into custom CU?

Please share your code.

Thanks.

Was this reply helpful? Yes No
Morten Steengaard 555 on at

Like (0)

Report

Yes, I have made a new codeunit - number 50002:

It only contains this code:

ItemLedgerEntry.SETFILTER("Entry No.", '1336812');

IF ItemLedgerEntry.FINDSET(TRUE) THEN
REPEAT
ItemLedgerEntry."Remaining Quantity" := 0;
ItemLedgerEntry.Open := TRUE;
ItemLedgerEntry.MODIFY;
UNTIL ItemLedgerEntry.NEXT = 0;

If I out comment this code, I still get the error, when trying to save the codeunit.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,718 Super User 2025 Season 2 on at

Like (0)

Report

Hi, Does the user performing the operation have Super permission? Nitin's suggestion is absolutely correct, you can follow Codeunit 80's practice. The same error will also be prompted if the user has insufficient permissions.

PS: Personally do not recommend doing this, it will destroy the consistency of the data.

Alternatively, you can modify the data directly in SQL.

Hope this helps as well.

Thanks.

ZHU

Was this reply helpful? Yes No
Morten Steengaard 555 on at

Like (1)

Report

Hi ZHU,

Thank you for your reply.

On a Danish forum, I have been told that some tables have special permissions. The problem in my case was that I did not have the developer licens installed at the time.

I totally agree with you, that this kind of programming is not recommended. I only do this in order to fix an inconsistency of the data, that a bug in a program has made.

Thank you both ZHU and Nitin.

Was this reply helpful? Yes No
Suggested answer

Amit Baru 3,037 on at

Like (0)

Report

Hi,

Pls use Dev License for doing the above activity.

Regards

Amit Sharma

www.erpconsultors.com

https://www.linkedin.com/in/amit-sharma-94542440/

Press Yes if Info is useful.

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (0)

Report

If you do not have a dev license / partner license you can modify the field directly on the SQL server as long as it is not a flow field.

But you really need to know that you do not do any changes that make things worse by creating even more inconsistency.

Was this reply helpful? Yes No