By using this website, you agree to our Terms of Use (click here)
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.
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
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).
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.