Active Key

ajmalsherif

Hi

I have recently restored a large Nav native Db v4 Sp1 onto a test server, however when i select a customer on the Sales Order or Sales Invoice i get the following message:

The Credit Card Transaction Table does not have an Active key that starts with the following fields: Document Type, Number andTransaction Type

Any suggestions would be most helpful

kapamarou

You should use debugger to see where the error occurs.
There could be code somewhere that says:
SETCURRENTKEY(...)
Or a form that you open has a tableview using that key.

In Credit Card Transaction Table do you have a key that starts with the following fields: Document Type, Number and Transaction Type?

Is that key enabled?

ajmalsherif

Many thanks \:D/

David_Singleton

I will put odds on that the debugger will not show anything.

Most likely there is a flow field created on the Customer table (18) and the Sales Header (36).
I will also bet that the issue is that the backup restore did not finish.

To find this out go to Tools Backup Restore and see if it asks if you want to complete the restore process.