Question: How can I write consolidation rules to exclude parent currency adjustments? Additional detail on specific situation:
Question (cont)
We are running our CTA rules at IsForeignCurrency and limited origin in Forms, Import, and AdjInput in our filter.
•The app is CAD and now we want to post a CAD journal to a USD entity or basically to CAD consolidation member. In this case, I don’t want to run CTA rules since its a CAD entry or in HFM was a PCA adjustment.
•Any idea on how I say exclude PCA in our rules?
Answer
Suggestion #1 – change the Origin filter from AdjInput to AdjConsolidated, which resulted in the following test results:
•Posting a journal in LOCAL
•That data gets stored in C#USD and O#AdjInput…then via consolidation gets translated into C#CAD in O#AdjConsolidated (in CAD there’s nothing in AdjInput when it comes from Local)
•So…when I change the CTA calc as mentioned above, the CTA calculation DOES calculate against the results of this
•Posting a journal in CAD (or any other currency that’s not the local currency) (Item 2 and outlined in blue below):
•That data gets stored in C#CAD and O#AdjInput…it doesn’t become part of the AdjConsolidated total until C#Share (circled in green) where I don’t have the rule running anyway so it’s just a summation of the two
Follow-up from Partner:
•What I did is limited my initial CTA rule to Import and Forms and removed AdjInput.
•What was happening is I was mismatched where the translation of a Flow for example for a journal shows up in AdjConsolidated but I was calculating my CTA on my flow in AdjInput.
•So what I did is calculate my CTA separately in AdjConsolidated and transition and PCA journals are now working fine.
•The CTA calculations were causing the CAD posting to not work.
Source: Office Hours 2019-07-11