Here I have a starnge problem that I ever came across. In my clients database, there is a super user. When the user login into Nav with Database login using remote desktop, he could able to edit a record in CLE (Cheque ledger Entry) table, but when the user logs into Navision through his local machine,and tries to midify a CLE record, he gets an error saying ‘You dont have permissions to modify the CLE table’. Even after running synchronise all logins, same error we are getting…
my client is cutting checks from payment journal and sends it for approval. later on once the check is approved by the management, they will post the payment Journal Line. But if they generate check say on 10th March, a CLE will be created with a check date of 10/03/2011. If they post the payment line on 20th march, Bank Ledgers will have a posting date as 20/03/2011(Modified the table 81 to allow edit only the Posting date even after the check is printed), which creates a confusion. So, we wrote code to modify the corresponding CLE’s check date once the payment line is updated.
User is getting the error when he moves on to the next line by changing the posting date of the Payment Line.
When he tried the same thing with same license on remote desktop, he could do that.