-1

I want to make a report in a payment journal that displays the data of the bank account name used by the vendor in the Vendor Bank Account table (288). Where vendors have chosen bank accounts in filed 'prefered bank accounts' on Vendor table (23)

My Code,

IF R_VendorBank.GET(AccountNo) THEN
  BankAccountVendor := R_VendorBank.Name
ELSE
  CLEAR(BankAccountVendor);

Note : R_VendorName type Record lookup to Vendor Bank Account Table, BankAccountVendor type Text.

How can I get the value of the bank name used by the vendor in the Vendor Bank Account table (288) ?

Sandy Satriya
  • 11
  • 5
  • Most probably the table has two fields in the primary key. Vendor and Bank Account. So `GET` needs two parameters. – Mak Sim Aug 08 '18 at 14:14
  • How to get table with 2 parameters sir ? Thanks for advice. – Sandy Satriya Aug 08 '18 at 14:48
  • 1
    Like this `VendorBank.GET(VendorNo, AccountNo)`. And I’d advise to stick to Cronus naming conventions. Don’t use prefixes like `R_`. – Mak Sim Aug 08 '18 at 18:44

1 Answers1

0

Here is the link for documentation where it is said that Record.GET([Value] ,...). The ,... part means that number of parameters may be more than one.

Mak Sim
  • 2,148
  • 19
  • 30