What can/can't a Client License do?

gulamdastagir

I have noticed a client can be used to modified tables like unit of measure but it CAN'T use MODIFY,INSERT on tables like Customer Ledger Entry

Is there anyway we can make it do this MODIFY ,INSERT into Customer Ledger Entry.

I dont want to use a Developer license at the client site

diptish.naskar

The NAV Client liecense generally doesnot have direct rights to modify the Ledgers present in NAV. and there is no way that you can direcly modify the ledgers with the client license.

Revolution1210

There is a good reason for this... ..it prevents users from accidently or purposely affecting the integrity of the database by hacking away at the ledgers. Entries to ledgers should be done via the normal posting methods provided by the system.

If you have a situation where you really need to allow a user to edit ledger entries, you can create a form in a number range they have access to, base the form on the ledger you're interested in, give it (the form) permissions to the table as required, make all fields non-editable apart from the one(s) you want them to be able to manipulate

Again though, this is not a normal solution. If you have situations where users say they need to edit ledger entries directly then you need to take a look at the underlying causes.

ashisha

Revolution1210 wrote:

There is a good reason for this... ..it prevents users from accidently or purposely affecting the integrity of the database by hacking away at the ledgers. Entries to ledgers should be done via the normal posting methods provided by the system.

If you have a situation where you really need to allow a user to edit ledger entries, you can create a form in a number range they have access to, base the form on the ledger you're interested in, give it (the form) permissions to the table as required, make all fields non-editable apart from the one(s) you want them to be able to manipulate

Again though, this is not a normal solution. If you have situations where users say they need to edit ledger entries directly then you need to take a look at the underlying causes.

hi everyone
i am using customer license file on cside client.we want to open all tables with this customer license file at that time we are facing problem for opening some tables but when we are using developer license file we can open it .how we can open such like (tabledata 160 to 169,tabledata 237 to 246) with customer license fileand so on.please help me how we can do this .
thanks in advance

kine

Of course, you cannot open tables which are not in customer license file (in the active license you have in client).

To temporary change of license in your client you need to use Change button on License Information form. It wil lchange the license for your and you can do what you want. After closing the client, the standard license will be used.

Main thing is one: just delete the License file after you did the change. You do not need it anymore to have it on the PC. It means, when you are working on customer Live DB through RDP or citrix, you just needs to open the license and you are done. You do not need to upload it there pernamently etc...

ashisha

Is there any way to change the permissions that are assosiated with the Customer License File??
Actually we want to access the table "Requisition Line" (id->246) using the customer license file. This table is opening using our developer license file but not with customer license file. Can we set the permission in customer license file to access that table??

Revolution1210

ashisha wrote:

Is there any way to change the permissions that are assosiated with the Customer License File??
Actually we want to access the table "Requisition Line" (id->246) using the customer license file. This table is opening using our developer license file but not with customer license file. Can we set the permission in customer license file to access that table??

Purchase the Requisition Management granule :roll:

AdamRoue

Yes, you buy the module, it then appears on the license and you have rights. Anything else is likely to be slightly frowned upon by Microsoft

PerJuhl

gulamdastagir wrote:

I have noticed a client can be used to modified tables like unit of measure but it CAN'T use MODIFY,INSERT on tables like Customer Ledger Entry

Is there anyway we can make it do this MODIFY ,INSERT into Customer Ledger Entry.

I dont want to use a Developer license at the client site

Hi

Yes, the user can edit the "On Hold" field and "Due date" on Customer
Ledger entry. Try F2 ("Edit") on "Due date".

Look in codeunit CODEUNIT.RUN(CODEUNIT::"Cust. Entry-Edit",Rec);

Take a look on the codeunits permisions:

TableData Cust. Ledger Entry=imd,TableData Detailed Cust. Ledg. Entry=m

and take care !!!!!!!!!! don't change m to d !!!!!!!!!!!!

BR Per

PerJuhl

diptish.naskar wrote:

The NAV Client liecense generally doesnot have direct rights to modify the Ledgers present in NAV. and there is no way that you can direcly modify the ledgers with the client license.

Sorry, but his is NOT right. As you write, no direct rights.

But the customer licens have indirect rights, to Ledger tables.

Eg. modify due data, date compression and post a ledger entry.

BR Per

gulamdastagir

1.How can i send the "VAR Rec" variable from a codeunit to call the onrun trigger of Codeunit number 103 "cust. entry edit" ? i know it can be easily done from a form.

OnRun(VAR Rec : Record "Cust. Ledger Entry")
CustLedgEntry := Rec;
CustLedgEntry.LOCKTABLE;
CustLedgEntry.FIND;
xRecRef.GETTABLE(CustLedgEntry);
CustLedgEntry."On Hold" := "On Hold";
IF CustLedgEntry.Open THEN BEGIN
  CustLedgEntry."Due Date" := "Due Date";
  DtldCustLedgEntry.SETCURRENTKEY("Cust. Ledger Entry No.");
  DtldCustLedgEntry.SETRANGE("Cust. Ledger Entry No.",CustLedgEntry."Entry No.");
  DtldCustLedgEntry.MODIFYALL("Initial Entry Due Date","Due Date");
  CustLedgEntry."Pmt. Discount Date" := "Pmt. Discount Date";
  CustLedgEntry."Applies-to ID" := "Applies-to ID";
  CustLedgEntry.VALIDATE("Remaining Pmt. Disc. Possible","Remaining Pmt. Disc. Possible");
  CustLedgEntry."Pmt. Disc. Tolerance Date" := "Pmt. Disc. Tolerance Date";
  CustLedgEntry.VALIDATE("Max. Payment Tolerance","Max. Payment Tolerance");
  CustLedgEntry.VALIDATE("Accepted Payment Tolerance","Accepted Payment Tolerance");
  CustLedgEntry.VALIDATE("Accepted Pmt. Disc. Tolerance","Accepted Pmt. Disc. Tolerance");
  CustLedgEntry.VALIDATE("Amount to Apply","Amount to Apply");
  CustLedgEntry.VALIDATE("Applying Entry","Applying Entry");
END;
CustLedgEntry.MODIFY;
Rec := CustLedgEntry;
RecRef.GETTABLE(CustLedgEntry);
ChangeLogMgt.LogModification(RecRef,xRecRef);

2.When you can send reference variables as parameters in NAV why cant u return reference variables from NAV Functions?


3.I know that customer ledger entries can be modified with client license using a form,so is it possible that my codeunit can call the form and then modify the customer ledger entry at run time?

:-k

PerJuhl

gulamdastagir wrote:

1.How can i send the "VAR Rec" variable from a codeunit to call the onrun trigger of Codeunit number 103 "cust. entry edit" ? i know it can be easily done from a form.

OnRun(VAR Rec : Record "Cust. Ledger Entry")
CustLedgEntry := Rec;
CustLedgEntry.LOCKTABLE;
CustLedgEntry.FIND;
xRecRef.GETTABLE(CustLedgEntry);
CustLedgEntry."On Hold" := "On Hold";
IF CustLedgEntry.Open THEN BEGIN
  CustLedgEntry."Due Date" := "Due Date";
  DtldCustLedgEntry.SETCURRENTKEY("Cust. Ledger Entry No.");
  DtldCustLedgEntry.SETRANGE("Cust. Ledger Entry No.",CustLedgEntry."Entry No.");
  DtldCustLedgEntry.MODIFYALL("Initial Entry Due Date","Due Date");
  CustLedgEntry."Pmt. Discount Date" := "Pmt. Discount Date";
  CustLedgEntry."Applies-to ID" := "Applies-to ID";
  CustLedgEntry.VALIDATE("Remaining Pmt. Disc. Possible","Remaining Pmt. Disc. Possible");
  CustLedgEntry."Pmt. Disc. Tolerance Date" := "Pmt. Disc. Tolerance Date";
  CustLedgEntry.VALIDATE("Max. Payment Tolerance","Max. Payment Tolerance");
  CustLedgEntry.VALIDATE("Accepted Payment Tolerance","Accepted Payment Tolerance");
  CustLedgEntry.VALIDATE("Accepted Pmt. Disc. Tolerance","Accepted Pmt. Disc. Tolerance");
  CustLedgEntry.VALIDATE("Amount to Apply","Amount to Apply");
  CustLedgEntry.VALIDATE("Applying Entry","Applying Entry");
END;
CustLedgEntry.MODIFY;
Rec := CustLedgEntry;
RecRef.GETTABLE(CustLedgEntry);
ChangeLogMgt.LogModification(RecRef,xRecRef);

2.When you can send reference variables as parameters in NAV why cant u return reference variables from NAV Functions?


3.I know that customer ledger entries can be modified with client license using a form,so is it possible that my codeunit can call the form and then modify the customer ledger entry at run time?

:-k

It's not done from the form, the form (field) call the codeunit that do
the modify. (The code you pasted)

PerJuhl

Revolution1210 wrote:

There is a good reason for this... ..it prevents users from accidently or purposely affecting the integrity of the database by hacking away at the ledgers. Entries to ledgers should be done via the normal posting methods provided by the system.

If you have a situation where you really need to allow a user to edit ledger entries, you can create a form in a number range they have access to, base the form on the ledger you're interested in, give it (the form) permissions to the table as required, make all fields non-editable apart from the one(s) you want them to be able to manipulate

Again though, this is not a normal solution. If you have situations where users say they need to edit ledger entries directly then you need to take a look at the underlying causes.

Absolutly right, don't ever insert Customer Ledger Entry directly !!!!
BR Per

gulamdastagir

PerJuhl wrote:

It's not done from the form, the form (field) call the codeunit that do
the modify. (The code you pasted)

My problem is at the moment to execute this code from a codeunit

CODEUNIT.RUN(CODEUNIT::"Cust. Entry-Edit",Rec);

and the definition of the ONRUN Trigger of codunit 103 is

OnRun(VAR Rec : Record "Cust. Ledger Entry")

My question is how can pass the VAR Rec paramter to this codeunit

diptish.naskar

PerJuhl wrote:

diptish.naskar wrote:

The NAV Client liecense generally doesnot have direct rights to modify the Ledgers present in NAV. and there is no way that you can direcly modify the ledgers with the client license.

Sorry, but his is NOT right. As you write, no direct rights.

But the customer licens have indirect rights, to Ledger tables.

Eg. modify due data, date compression and post a ledger entry.

BR Per

Did I say something worng ?:-k if you open the client license with license viewer you will notice a difference RIMD and Rimd. Hope this gives you some idea on the rights to insert/Modify and Delete...leaving the 'R' read.

gulamdastagir

solved \:D/