Skip to main content

Solutions

Products

Recommended products

Questions? We are here to help.
Contact us

Purchase

Questions? We are here to help.

Resources

Trapped data

Clear trapped data

Trapped data happens when you import a data value using a
Copy Number
 or
Group number
 that doesn't exist in the target group, and the required field for the group isn't in the import file.

Scenario

You've imported data but it isn't appearing in the locator and it's become trapped data.

Solution

To clear trapped data:
  1. Open your locator/return, go to the
    Organizer
     screen with trapped data.
  2. Right-click and select
    Field Info
    , and make note of the
    Area
     number.
  3. Next, go to
    Tools
    ,
    Validate and Repair
    .
  4. In the
    Records to Show
     section, select
    Bad input records
    .
  5. In the
    Problems to Find
     section, select
    Records with missing interesting
    . This should be the only option selected.
  6. Select
    Load
    .
  7. In the
    ASFL Key
     column, find your area number from step 2.
  8. Scroll to the right to the
    Missing Int Field
     column where it shows the area, screen, and field numbers. Make note of these numbers.
  9. Close the
    Validate and Repair
     window, and go back to the
    Organizer
     screen with the trapped data.
  10. Right-click a field with trapped data, select
    Field Info
    , and verify its area, screen, and field numbers match the numbers you noted from
    Validate and Repair
     in step 8.
  11. Right-click the field again and select
    Data Dictionary
     to get the form and field name used for import.
  12. Search your recently imported file(s) to see what activity number was used to import the trapped data.
  13. Create a new black import file with the
    M
     flag and use the data dictionary from the required field and activity number from the trapped data. You can now delete the entire activity from inside the locator/return by selecting the minus sign by that particular activity in the navigation sidebar on the left.

Alternative method of clearing trapped data

Another method to clear trapped data is use of an import file with the
H
 flag. Before importing, the H flag creates a list of all form names present in the import file and deletes from the locator any data from fields listed under those form names in the Organizer tab of the build report.
To delete only data from a single form:
  1. Make sure the import file only contains lines with that form name.
  2. Export the locator.
  3. Filter the export file to the lines with that form name that contain the desired activity number(s).
  4. Copy those lines to an import file.
  5. Import into the locator using an H flag to re-input the desired data while clearing the trapped data.

This article applies to:

  • PRODUCT: ONESOURCE Income Tax
  • Subject: Data Connection,Export,Import

Related Content

error-icon

Triva isn't available right now.

Check out the support page for our phone number and hours

error-close