Hello,
I have a Transaction Detail saved search, very similar to what NetSuite offers in the reporting. This saved search was created to show the balance of base currency (which in this example is UK) and the balance in USD. When it comes to showing the intercompany journal entry lines, the amount in USD is NOT what is/was recorded in the JE.
How do I get that?
Details of my saved search:
Criteria:
Posting - is true
Main Line - is any
Type - is not Currency Revaluation
Results:
Type
Document Number
Account: Number
Account: Name
Formula(Currency) - nvl({debitamount},0)-nvl({creditamount},0) - This is the balance amount in USD and is showing wrong.
Formula(Currency) - case when {linefxrate} <> {exchangerate} then nvl({linefxrate}*{debitfxamount},0)-nvl({linefxrate}*{creditfxamount},0) else nvl({exchangerate}*{debitfxamount},0)-nvl({exchangerate}*{creditfxamount},0) end - This is the balance in Base currency / Subsidiary. This is showing correct.
Screencapture of Saved Search Results:
The incorrect amount shown under USD Balance:
Screencapture of the GL Impact of Intercompany JE:
Do let me know if you need anythign else. Thanks in advance!!
Preethi