Microsoft Dynamics AX (Archived)

Bank Account name of a customer

(0) Share

Report

Posted on by Zohan

Hi,

how to get bank account name of a customer from custtransopen or Custtable.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Zohan,

Why do you need that and how do you plan to deal with situations where a customer has multiple bank accounts? Do you already know the bank account that will be used before the customer has made the payment?

Best regards,

Ludwig

Was this reply helpful? Yes No
Zohan 2 on at

Like (0)

Report

No there's no such any case occur in which i know the customer bank account

Was this reply helpful? Yes No
Suggested answer

Mahmoud Hakim 17,887 on at

Like (0)

Report

customer bank account stored in CustBankAccount table, so if you need it you can write display method to retrieve based on your business logic.

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Zohan,

Do you want to include this info in the custtransopen table or where and why you need that info?

Best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

Chaitanya Golla 17,225 on at

Like (0)

Report
Hi,

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)); } }

Was this reply helpful? Yes No