Ledger Currency ID - Display on ARM Report - Acumatica Analytical Report Manager (Financial Report Writer)

RE: Ledger Currency ID - Display on ARM Report

Bettie Heyns — Wed, 13 Sep 2023 13:58:55 +0000

Cheaters route that I would suggest is to use the @organization field. and an If formula. So Iif(@organization = 'CompanyA', 'USD','EUR'). CompanyA is the companyID as per the Companies (CS101500) screen. This is the way that I do it on my customers. Most running in 2 base currencies for companies so if is easy.

RE: Ledger Currency ID - Display on ARM Report

C_H — Mon, 16 Dec 2019 15:17:05 +0000

Thank you for the response Tim.

It may be something for Velixo, but in the short term I took the "cheaters" route and simply created two reports and coded them for set currencies.

I would still ultimately like to have a formula to pick up on the currency being utilized, but in the short term this is working (albeit not as elegantly).

RE: Ledger Currency ID - Display on ARM Report

Tim Rodman — Sat, 14 Dec 2019 23:16:30 +0000

Something might be possible with those Application functions, but I just made an attempt and wasn't able to get anything to work.

Maybe @gabriel-michaud could add a function for this in Velixo Reports. Something that could accept either a Ledger or a Company as a parameter. Might as well include Project as a parameter too since Projects can now have their own Base Currency:

https://twitter.com/TimRodman/status/1090260510082134021

Ledger Currency ID - Display on ARM Report

C_H — Wed, 20 Nov 2019 20:53:51 +0000

Does anyone have a good way to showing what currency an ARM report is being run in?

I am trying to write a formula in the Column set to display the Currency ID of the ledger being selected for the report?

I have tried a couple different Report.Get variations but cant find one that works.