Vendor Ledger Entry Keys.

rj5570

Ok, what i am trying to do is use a different check report that was modified by a vendor from another sister company of mine. We are using NAV3.6 and they are using NAV2.X

I kept getting this error:

The Vendor Ledger Entry table does not have an active key that starts with the following field(s):Document type,Document No.,Vendor No.

after ](*,) for a few hours, i went in and compared keys on the Vendor Ledger Entry table

Mine had a key setting of:
Document No.,Document Type,Vendor No.

where as theirs was set as:
Document Type,Document No.,Vendor No.

the doc no and doc type are switched. When i switched mine to:

Document Type,Document No.,Vendor No.

I didnt get the error anylonger, but now i was getting errors when i tried to navigate thru the vendor ledger.

my question is why would this difference matter, and where should i look on the check report so i can change it to fit my keys.

any help would be appreciated!!

RJ

Savatage

It matters because there is code behind the forms & navigating & etc.

For Example it might have code like:
VendLedgEntry2.SETCURRENTKEY("External Document No.","Document Type");

Now say you change the key. the code doesn't change.

if the you really need the key in another order - then add it.
Changing key's is not recommended unless you like errors & headaches

rj5570

thank you.... i will do that...i have enough headaches from my users!

thanks!!