Hi,
I am hoping someone can help me.
I am working on the ER FTI template and trying to get the format to display bank account depending on the currency being used on the invoice journal.
For example my LE Default bank is set to HKD:
my invoice journal currency is USD, i was hoping the template would pick up the bank account where i had the currency set to USD, but it pick up nothing:
it picked up the labels and display this, but no values.
Can someone advise if i am missing something or advise where the information for Currency Bank Account is stored so i can pick this up.
Thanks
Hetal
Hi Hetal,
If you have one bank account per currency in the legal entity, you can follow suggestion ny Arcadi.
If not, you can evaluate to get bank account info from payment method that is associated to customer card (In a case that you have different payment method per bank account).
There is a table called BankAccountTable with a field called CurrencyCode.
In your mapping, or directly on the format you are extending (Mapping tab) you can "add root" and insert a "Table records" using that table. If you don't see it, click "Show details" on top left (It's a bug that's been there for years).
Now inside the record you are using, the one that has the currency (Model.InvoiceBase) add a calculated field with the formula
FirstOrNull(Filter(BankAccountTable , BankAccountTable.CurrencyCode = @.CurrencyCode))
Now you connect witch ever field you want from that record that has been created. But...What if you have multiple Banks for a currency?
André Arnaud de Cal...
291,971
Super User 2025 Season 1
Martin Dráb
230,846
Most Valuable Professional
nmaenpaa
101,156