Item Ledger Entry table does not have an active key

Business Central/NAV Developers Forum
1

Hi Everybody,

When upgrade report form NAV 5 to NAV 2013 then error “Then Item Ledger Entry table does not have an active key that starts with the following field or field: Item Category Code, Location Code, Item Code., Posting Date”

I call function on report SETCURRENTKEY

Item Ledger Entry - OnAfterGetRecord()

SETCURRENTKEY(“Item Category Code”, “Location Code”, “Item Code.”, “Posting Date”);

But not fix error.

Please share the solution. Thank very much

Best Regards,
dinhson
2

Go to Item Ledger Entry table and View–>Keys

Here check whether you have all keys which are available in NAV 5 are existing or not.

the above key is not existing here. please add the key in table

3

Thanks Mohana

4
  • but first check whether you can use an existing key in the new standard NAV 2013.
5

Thanks Anfinnur.