Edit field on Sales Invoice Header Table 112

HLL

Hello
We have created a function to a customer, where we mark invoices on Table 112 Sales Invoice Header to be mailed via a job queue, which only will run one time daily.

But when we try to edit the field - with the customer's NAV license, we get an error:

You do not have the following resrictions on Table Data Sales Invoice Header: Modify.
But if we use our Partner NAV codes the function works fine.


Can anyone help with an explanation / solution ??

muca

function (codeunit,form,report .... I do not know what exactly is used) should have property
Permissions to modify 112 Sales Invoice Header table data.
(this permission properties you can change using developer license)

HLL

Thank you for your answer, I found out that modifying protected tabels, is only possible with a full developer license.
But is it possible to change permissions for a codeunit, and then use a license without developer module to modify Table 112 ?

Kishorm

HLL wrote: »

Thank you for your answer, I found out that modifying protected tabels, is only possible with a full developer license.
But is it possible to change permissions for a codeunit, and then use a license without developer module to modify Table 112 ?

Yes, and this is why you need to set the Permissions property - you have to set this using a developer license and then the permissions set are available when using a non developer license.

sorenhinrup

I have achived this for a customer at some point by adding a variable to the page that, when validated, runs a codeunit with the permissions.
In your case, it could be a boolean on page 132, that when validates runs a function in a codeunit that updates the your mail by Jobqueue field. In the codeunit you can add modify permissions for table 112.

I hope this gives you a solution for your issue.

HLL

Hello
Thank you for your answers they were very helpfull and the issue is solved.

muca

function (codeunit,form,report .... I do not know what exactly is used) should have property
Permissions to modify 112 Sales Invoice Header table data.
(this permission properties you can change using developer license)

HLL

Thank you for your answer, I found out that modifying protected tabels, is only possible with a full developer license.
But is it possible to change permissions for a codeunit, and then use a license without developer module to modify Table 112 ?

Kishorm

HLL wrote: »

Thank you for your answer, I found out that modifying protected tabels, is only possible with a full developer license.
But is it possible to change permissions for a codeunit, and then use a license without developer module to modify Table 112 ?

Yes, and this is why you need to set the Permissions property - you have to set this using a developer license and then the permissions set are available when using a non developer license.

sorenhinrup

I have achived this for a customer at some point by adding a variable to the page that, when validated, runs a codeunit with the permissions.
In your case, it could be a boolean on page 132, that when validates runs a function in a codeunit that updates the your mail by Jobqueue field. In the codeunit you can add modify permissions for table 112.

I hope this gives you a solution for your issue.

HLL

Hello
Thank you for your answers they were very helpfull and the issue is solved.