Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Currency Bank Account Range in FTI ER format

(0) ShareShare
ReportReport
Posted on by 49

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:

pastedimage1677836051839v1.png

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:

pastedimage1677836225498v2.png

pastedimage1677836272215v3.png

it picked up the labels and display this, but no values. 

pastedimage1677836474636v4.png

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 

  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    Alireza Eshaghzadeh 13,562 Super User 2025 Season 1 on at
    RE: Currency Bank Account Range in FTI ER format

    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).

  • Suggested answer
    Arcadi  Profile Picture
    Arcadi 786 on at
    RE: Currency Bank Account Range in FTI ER format

    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?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,971 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,846 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans