≡ Menu

VendBankAccount and BankAccountTable address relation Dynamics Ax 2012

We can get address for VendBankAccount table and BankAccountTable by following way.

 

VendBankAccount  table has method which returns address VendBankAccount.addressing() ;

For BankAccountTable you can use following query to fetch its address, both table has similar releationship with logistic location table

BankAccountTable  _BankAccount;

LogisticsPostalAddress _postalAddress;

LogisticsLocation  _location;

while select * from _BankAccount

join * from _location

join _postalAddress

where _postalAddress.Location == _location.RecId

&& _BankAccount.Location == _location.RecId

{

info (_BankAccount.AccountID + ” address “+ _postalAddress.Address);

}

 

{ 0 comments… add one }

Leave a Comment