Cumulative Translation Adjustment - Has anyone fou...
# suiteanalyticsj
Josh_SatoriReporting
02/21/2022, 7:09 PMCumulative Translation Adjustment - Has anyone found a way to pull a list of all CTA's? I know I can get to them via the report, "CTA Balance Audit" - but I'd love to see more of a list (i.e. search).
k
KevinJ of Kansas
02/21/2022, 11:56 PMCan't you just do a saved search where account = CTA?
KevinJ of Kansas
02/21/2022, 11:57 PMActually, scratch that. I know what I had to do one time
KevinJ of Kansas
02/21/2022, 11:57 PMI had to do a search for transactions where the debits didn't equal the credits
KevinJ of Kansas
02/21/2022, 11:57 PMNS had parked the difference in the CTA account.
KevinJ of Kansas
02/21/2022, 11:58 PMso something like
sum(nvl({amount debit},0)) - sum (nvl({amount credit, 0))KevinJ of Kansas
02/21/2022, 11:58 PMof course that was a really strange scenario that had triggered the need for that, and not the normal CTA process.
j
Josh_SatoriReporting
02/22/2022, 1:27 AMAppreciate the help! Strangely, you can filter/select the system generated CTA account in a search. Maybe because NetSuite doesn't treat CTA transactions as posting...So, I haven't been able to see the double sided entry just yet. I can back into it using the "consolidated exchange rate" selector on search results - but it's more work.
m
Marc Reicher
02/22/2022, 6:05 PMI could do this with SuiteQL, but it would for sure be messy and involve using consolidated exchange rates
j
Josh_SatoriReporting
02/23/2022, 12:15 AMThanks, Marc...I was thinking similarly but just wound up doing it manually in Power BI.
👍 1
3 Views