Users utilize Transaction Details Report to check chronology of transactions entered in a specific time and check its General Ledger association.
Did you know that you can also identify the currency used and the foreign amount in the transaction without viewing the transaction record? Here’s how you can add a column so you can easily see these data:
1.) Go to the Transaction Detail page.
- NetSuite: Navigate to Reports > Financial > Transaction Detail.
- NetSuite Next: Click Explore (Ask Oracle icon in the bottom right corner), and in the menu go to Reports > Financial > Transaction Detail.
NetSuite
NetSuite Next
2.) Click Customize
3.) Go to Edit Columns
4.) Add Columns:
A.) Transaction Currency:
1.) Add Fields > Transaction folder > Currency > Name
2.) Rename the Column Label from Currency: Name to Transaction Currency
B.) Amount in Foreign Currency
1.) Add Fields > Transaction folder > Currency > Name
2.) Set Display Negative Numbers to Parentheses example: (123) – (optional)
5.) Save and run the report
Important things to remember:
- The Amount column in the Transaction Detail report is the converted amount based on the subsidiary currency. For example, if your subsidiary filter is your Parent Company and its base currency is in USD, then the Amount Column is in USD
- The Amount (Foreign Currency) will be the same with the Amount column if there are no foreign amounts in the transaction
Hope this helps!
Have you tried this one? Feel free to share your thoughts 🙂