Create Saved Search that Lists Source Transactions of Intercompany Elimination Journal Entries

Scenario

For some Intercompany Accounts particularly Balance Sheet Accounts, other than Accounts Receivable and Accounts Payable, there is no Source link available on intercompany elimination journal entries created. Here are steps on how to create a search that shows the source transactions of an intercompany Elimination Journal Entry for these accounts.

Solution

1. Navigate to List > Search > Saved Searches > New
2. Click Transactions
3. In the Title field, enter a Search Title
4. Click Criteria tab and add the following fields:
   1. Account = Intercompany Account
   2. To Subsidiary = None of -None-
5. Click Results tab, set the following filters:
   1. Sort By Field: Select Account
   2. Then By field: Select Date
   3. Then By Field: Select Subsidiary
6. Click Remove All Button, and add the following fields:
   1. Account
   2. Date
   3. Period
   4. Tax Period
   5. Type
   6. Number
   7. Name
   8. Subsidiary
   9. Subsidiary Fields... > Currency [Type Base Currency of Subsidiary in the Custom Label Field]
   10. Amount (Foreign Currency) [Type Transaction Amount in the Custom Label Field
   11. Exchange Rate
   12. Currency
   13. Formula (Currency) > Formula: Enter {fxamount}*{exchangerate} [Type Foreign Currency Amount in the Custom Label Field]
7. Click Save & Run