Saved Search for Journal Entries posted for Account Opening Balance

Scenario

User will be able to pull up the transactions that were created via Setup > Accounting > Enter Opening Balances

Solution

Perform the following:

1. Navigate to Lists > Search > Saved Searches > New > Transaction

2. Enter the following filters under the Criteria tab > Standard sub tab:
   Type = Journal
   Memorised = is False
   Document Number = is not empty
   Memo = is Opening Balance

3. Perform the following under the Results tab > Columns sub tab in order to view whether the accounts were entered with positive or negative values:
   · Remove the Amount field
   · Add the following fields:
   Amount (Debit)
   Amount (Credit)

4. Rename the search

5. Hit the Save and Run button
   
   
   

Notes :

The user will not be able to view the balancing account "Opening Balance" in the search result since that Journal Entry line item does not have Memo = Opening Balance.

To view all the accounts entered in the Opening Balance Journal Entry transactions:

·         User should check one of the Journal Entries from the above search result to take note of the Opening Balance account used in the transaction

·         Edit the above search

·         Enter these filters in the Criteria tab > Standard sub tab

·         Hit the Save and Run button