Value Entry table - Change Entry ID

sabzam

Hi

We created a new record manually in the Value Entry table to test something. Unfortunately other users were in the meantime creating transactions and Navision posted records in the Value Entry table using our manual Entry ID created + 1...and continued from there onwards.

Now we want to put back all the transactions created (quite a few now)from this point onwards to their actual sequential sequence. We wrote a codeunit but when we run it, it's taking quite a long time (about half an hour for each record). This is a NAV database not SQL.

Wonder whether there is a simpler and faster way of doing this.

Thanks

Malajlo

If that entry does not interfere with postings, then you can a) delete it or b) leave it as it is

sabzam

thanks for your reply.....but the problem is that it is not only 1 entry....but several entries...(thousands)

we could leave them like that but then there will be a huge gap in the Entry IDs numeric sequence. I don't think this will look nice if someone had to audit the system.

Thanks again