How to get data with primary key from other table in NAVISION

sandysatriyasandysatriya Member Posts: 6
edited 2018-08-08 in NAV Three Tier
I wanna get data Bank Account Name from Bank Account table (270) in my Report Payment Voucher. How I get that values ?

wki1okewe8rd.png

Picture above is the data I want to get.

I have code...
IF R_BankAccount.GET("Gen. Journal Line"."Account No.") THEN
  BankAccount := R_BankAccount.Name;

Note : R_BankAccount is Record Lookup To Bank Account table (270), And BankAccount is Text Variable.

That cannot work.

Answers

  • AluanAluan Member Posts: 158
    Hello sandysatriya,

    the above example should work.
    Where do you use this code?
  • sandysatriyasandysatriya Member Posts: 6
    Thanks Aluan for reply, This case already solved...
Sign In or Register to comment.