Hi, I have added a new field in the G/L entry table, when i insert a new record ig gets updated but when i try to update that field it gives me error on the client’s licence but when i try to do the same with developer’s licence it works fine. why? Rgrds[8D]
Hi, Must be the “Field Number” you have specified is not valid in the clients licence. All the Best ! Regards, Srinivas Shetty
I think I have seen this sort of question before… Only Solution Developer licence allows you to build an object that can modify Table 17 and allows direct modification of same table. This restriction is for Audit purposes; you cannot directly modify the ledger entry tables.
quote:
Originally posted by chadharajan
Hi, I have added a new field in the G/L entry table, when i insert a new record ig gets updated but when i try to update that field it gives me error on the client’s licence but when i try to do the same with developer’s licence it works fine. why? Rgrds[8D]
To update G/L Entry table you must write a codeunit based on table 17, give it modify permission to the same table and launch it from the OnModifyRecord trigger in the form. See codeunit 103 and form 25 for inspiration. [:)] Anna
HI, I have tried modification of G/L entry table from 3 different customer’s licence but it doesn’t work. Have u ppl tried it with the client’s licence? Regards [:(]
Hi Rajan, Create a new function in Codeunit 12 and write ur modification code for G/L entry here. This will allow u to modify the G/L Entry table with clients license, as this codeunit has permission to modify the above. regards, JHC
Hello, You need to use a solution developer licence, ethier to change the data or change codeunits that change the data (eg codeunit 12). Very few clients buy this granule. Basically if you are not a full NSC solution developer, you cannot do this.
Thanx Guys Write the Code in Codeunit 12 and it works fine. Thanx Again Regards [8D][:o)][:I]
quote:
Originally posted by EBloom
Hello, You need to use a solution developer licence, ethier to change the data or change codeunits that change the data (eg codeunit 12). Very few clients buy this granule. Basically if you are not a full NSC solution developer, you cannot do this.
Forgive me, you need a solution developer license to change the data directly by a form or by the run function in Object Designer. If a customer was not allowed to change data in a legally owned table through a legally authorized codeunit, nothing would work. [:D] So the problem is to do it in the right way or, to be more precise, in the Navision way. [:p] That is - don’t try to change data directly by a form, but have a codeunit function doing the dirty work. The codeunit must have modify permission assigned in the permissions property and must be executed in the OnModifyRecord trigger of the form acting as user interface. The codeunit can be a new one or, if the customer has not license to run codeunits but the standard ones (the basic customer license only provides forms and reports numbers), you can add a function to an existing one. In a few cases (I didn’t understand why, just complied) I had to give explicit modify permission to the form also. [?] That might be the case with Rajan’s problem? Anna
This is what i was doing. i was updating g/l entry table directly from Gen. journal line and it was giving me stupid problem Regards [:D]
quote:
Originally posted by Anna Perotti
quote:
Originally posted by EBloom
Hello, You need to use a solution developer licence, ethier to change the data or change codeunits that change the data (eg codeunit 12). Very few clients buy this granule. Basically if you are not a full NSC solution developer, you cannot do this.
Forgive me, you need a solution developer license to change the data directly by a form or by the run function in Object Designer. If a customer was not allowed to change data in a legally owned table through a legally authorized codeunit, nothing would work. [:D] So the problem is to do it in the right way or, to be more precise, in the Navision way. [:p] That is - don’t try to change data directly by a form, but have a codeunit function doing the dirty work. The codeunit must have modify permission assigned in the permissions property and must be executed in the OnModifyRecord trigger of the form acting as user interface. The codeunit can be a new one or, if the customer has not license to run codeunits but the standard ones (the basic customer license only provides forms and reports numbers), you can add a function to an existing one. In a few cases (I didn’t understand why, just complied) I had to give explicit modify permission to the form also. [?] That might be the case with Rajan’s problem? Anna
Rajan, You have found the problem. Only a Solution Developer Licence (or stronger) allows the system to update these tables. This is done for audit control. If you wnat to change the table you need that licence. Good luck.
It’s not true. To update that table it’s necessary to set on the form, report or codeunit the permission property to: Object ID Object Name Read Permission Insert Permission Modify Permission Delete Permission 17 G/L Entry Yes Yes Yes Yes Bye
Vescovo, To give G/L Entry modify,delete,insert permission on a form,report you need to have solution developer license. Sat
@vescovo: you are only allowed to set these permission rights with a license that anyway allows you to directly modify g/l entries. otherwise every customer would be able to add rights that his license does not allow him to have. try to add the rights you mentioned to a form using a customer’s license. You will not succeed