Scenario 1- your query did not return any results
In this scenario, we need to check the query criteria to ensure that we will return results
  1. Click Queries
  2. Click Manage Queries
  3. Click the category where you stored the query
  4. Click the query name
  5. Adjust the criteria to return the expected results (for example, we'll update the dates or Journal Entry Types included in the criteria)
  6. Click Save and Preview
Once you have ensured that your query results in the correct transactions, we can process the Mass Update
  1. Click Management
  2. Click Mass Update
  3. Click Update Existing Transactions
  4. Select your query category from the first drop down menu
  5. Select your query name from the second drop down menu
  6. Select the fields and values you'd like to assign to each of the transactions
  7. Click Next
  8. Preview the results
  9. Click Next to run the update

Scenario 2- your query returned only finalized journal entries
Once an entry is finalized, we cannot edit it. We'll first need to remove the finalization from the entries and then we can process the Mass Update.
  1. Click Management
  2. Click Mass Update
  3. Click Finalize Journal Entries
  4. Select your query category from the first drop down menu
  5. Select your query name from the second drop down menu
  6. Select Remove Finalization
  7. Click Next
  8. Preview the results
  9. Click Next to run the update
Once the entries are unfinalized, we can run the Mass Update again.
  1. Click Management
  2. Click Mass Update
  3. Click Update Existing Transactions
  4. Select your query category from the first drop down menu
  5. Select your query name from the second drop down menu
  6. Select the fields and values you'd like to assign to each of the transactions
  7. Click Next
  8. Preview the results
  9. Click Next to run the update
Then, we can run a final Mass Update to finalize all of the entries
  1. Click Management
  2. Click Mass Update
  3. Click Finalize Journal Entries
  4. Select your query category from the first drop down menu
  5. Select your query name from the second drop down menu
  6. Select Finalize
  7. Click Next
  8. Preview the results
  9. Click Next to run the update