AX / D365FO – Get Bank Account name of a customer in X++

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