
You can use following code/job to get a bank account name of a customer either from custtransopen or custtable.
static void AXC_BankAccount(Args _args)
{
CustTransOpen custTransOpen;
CustTrans custTrans;
CustTable custTable;
CustBankAccount custBankAccount;
// From CustTable
while select custTable
where custTable.AccountNum == "XYZ" // Specify customeraccount here
join custBankAccount
where custBankAccount.CustAccount == custTable.AccountNum
{
info(strFmt("BankType: %1, Bank account Name: %1", custBankAccount.BankAccountType, custBankAccount.Name));
}
// From CustTransOpen
while select custTransOpen
join custTrans
where custTransOpen.AccountNum == custTrans.AccountNum
&& custTransOpen.RefRecId == custTrans.RecId
join custTable
where custTable.AccountNum == custTrans.AccountNum
&& custTable.AccountNum == "XYZ" // Specify customeraccount here
join custBankAccount
where custBankAccount.CustAccount == custTable.AccountNum
{
info(strFmt("BankType: %1, Bank account Name: %1", custBankAccount.BankAccountType, custBankAccount.Name));
}
}
Leave a comment