Hello,
We setup a new subsidiary for Costa Rica. We placed it our tree as so:
US Consolidated Subsidiary (USD) —> US Subsidiary (USD) —> Costa Rica Subsidiary (CRC).
So it's a child of a US parent.
We've setup plenty of foreign subsidiaries before with no issues. However, we noticed that after creating Journals (normal and Advanced Intercompany) with the Costa Rica subsidiary - the Amounts in a Saved Search were not displaying like the other subsidiaries.
Expected Behaviour:
When running a Saved Search, we have two columns (1) Amount - this always shows the Consolidate Base currency of USD as all our subs are children of this one. (2) Amount (Foreign Currency) - this shows the foreign currency of the subsidiary.
Actual Behaviour:
When we ran the search on the Costa Rica JEs we created, the (1) Amount column was not USD. It was showing in the CRC amount.
Troubleshooting:
I tried to find this behaviour in other subs, but I could not duplicate the result. It is also the case for both types of journals.
-I thought this may have to do with the parent subsidiary structure, but read that subsidiary hierarchy only affects Consolidated Exchange rates.
-Then I read that the reason it isn't showing USD is because it never posted anywhere in USD. Apparently, our other foreign subs have a USD posted "somewhere" which is why it can pull the amount.
-The Costa Rica subsidiary was created before creating the Journals. And the base currency of the sub was always CRC.
My questions are:
Why is it displaying in the search like this?
How can we get it to display just like the other subs so our reporting is consistent?
Thank you for your help!