Error on Reversing a Transaction

airam

Dear All,

My client is receiving the below error when trying to click on Reverse Transaction from the G/L entries window

You do not have permission to read the Maintenance Ledger Entry table.

I added permissions but I am noticing that the issue is related to the License, because when I try it with our developer license it doesn't give the error. They are on the Advanced Management Foundation Pack.

Any ideas of what is causing the issue?

Thanks in Advance

Kishorm

You are getting this error because there are records in that table - probably done with a developer license. If this is a test database and they shouldn't be in there because the customer doesn't use it then you can just delete the entries.

airam

Thanks for your reply, it is on the live database and there are some old entries in Maintenance Ledger Entry, but the entries the user is trying to reverse has nothing to do with FAs, why do you think they were done with a Developer's license? back when the entries were posted this client was with a different partner so there is the possibility that they were posted with their developer's license.

Thanks again

Maria

Kishorm

I simply said developer license because the customer license does not have permissions to create records in the table so it must have been done with a different licence - and this would normally be the partner's developer license.

It doesn't matter that the transaction that they are trying to reverse has nothing to do with FA - the fact that there are records in the table means that the NAV client must check to see if any of those records need to be reversed and it can't check because the licence does not have access to the table.

Kishorm

The only way to stop the error (other than getting a new license with access to the table) is to delete the records, However as this is a ledger table it's not the type of thing you want to do willy-nilly. What I would do is...

A) create a dataport and export all the maintenance ledger entries to a text file (keep the dataport and textfile safe)
then delete the maintenance ledger entries

If in future you hit some problem (e.g. during an upgrade or something) then you can restore the data in the table. I don't think you will hit any problems but I always say better safe than sorry! :-)

airam

Thanks a lot for your detailed explanation!!