From table C_BP_BankAccount, field/value bank_acct_no is missing in excel export

[Mousumi Bhowmick]

From table C_BP_BankAccount, field/value bank_acct_no is missing in excel  export when column sql value is given to set it as string. How to do it? export format this field is not there. Its comming as numeric for 1/2/3 started nos. but for 0 its comes with single quote. Where to change for this so that all bank acct no be treated as string only.

[Carlos Antonio Ruiz Gomez]

Hi Mousumi, not sure if you're talking about C_BP_BankAccount.AccountNo,
or are you talking about a custom column?

I was not able to reproduce what you mention in test.idempiere.org

Regards,

Carlos Ruiz

[Mousumi Bhowmick]

Field Custome bank_acct_no, type - Embedded EXP Format,  embed format -C_BP_BankAccount, reference - string in excel export format line is set. But in exported excel its coming as number like 213455533 where as it is string. is there any way to change the export code for value set in idempiere 2.1? 

[Carlos Antonio Ruiz Gomez]

Sorry I can't help, 2.1 is a very old version, and "Embedded EXP Format" is a type I don't know about.