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

RE: Bank Account name of a customer

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

RE: Bank Account name of a customer

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

RE: Bank Account name of a customer

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

RE: Bank Account name of a customer

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
RE: Bank Account name of a customer

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