Vendor Ledger Entry Keys.

rj5570
rj5570 Member Posts: 157
edited 2007-11-05 in NAV/Navision Classic Client
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
- So it Goes.

Comments

  • Savatage
    Savatage Member Posts: 7,142
    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 :mrgreen:
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • rj5570
    rj5570 Member Posts: 157
    thank you.... i will do that...i have enough headaches from my users!

    thanks!!
    - So it Goes.

Categories