Import service data validation basics

These tools are used after you have loaded information into the Sage Intacct import service. The workspace provides different ways to work with data in a sheet.

Common actions

Workspace worksheets provide an Excel-like experience for interacting with your data.

• Double-click on a cell to edit or delete the data.

• Select multiple cells at a time. Select the first cell, and then hold down Shift while you select the last cell in the range.

  The import service does not support CTRL-select in sheets. Only cells next to each other can be selected.

• Common keyboard shortcuts are accepted on the worksheet. These include, but are not limited to:

  • Select all

  • Copy, Paste, Cut

  • Undo

Header number column

The header number column automatically assigns a non-editable number to lines in your import. This column is intended to help identify and keep sets of information together, such as lines in a journal entry. Header numbers are not imported into Intacct, but rather serve as a way to keep groups of information together, indicate line errors, and troubleshoot issues.

1. The header number column assigns numbers to information that should stay grouped together, such as lines in a journal entry.

2. Header number H000001is assigned to all the lines in the first journal entry.

3. Header number H000002 is assigned to all the lines in the second journal entry.

Delete a record or group of records

Use the Actions menu to delete either a single record or an entire group of records.

If you select a single record and select Actions > Delete group, the record and all related records in its group is deleted.

If you select a single record and select Actions > Delete record, only that record will be deleted.

1. Delete group: If you select one line from a journal entry grouped under H000002 (which includes one credit line and two debit lines), the entire journal entry will be deleted.

2. Delete record: If you select one line from a journal entry grouped under H000002, the remaining lines remain. However, you’ll need to adjust the journal entry to ensure that debits and credits still balance.

Column tools

Each header row of a column in a workspace sheet has tools to help you work with your data. Hover over the column head to see the more menu.

See column tools in action: Sort and Find and replace; Clear Column and Replace empty values.

When selected, the following options are available for use:

• Sort A-Z: Sorts the column alphabetically from A-Z.

• Sort Z-A: Sorts the column alphabetically from Z-A.

• Remove sort...: Removes the selected sort and returns the row order to the original uploaded order. This option is available after a column has been sorted.

• Pin column: When selected, the current column is pinned to the left side of the table for easier reference. You can pin more than one column.

  Pin the columns in the order that you want to see them at the left.

• Search in field: Searches in the selected column for a specific value and filters the displayed rows by this value.

• Find and replace: Search the selected column for a specific value and replace that value with the one you provide.

• Replace empty cells: Filters the selected column for empty fields and allows you to provide the value for those fields.

• Filter by value: Hover over the menu to view the values in the column as options for filtering. Select as many values to filter by as needed. Rows are displayed based on this filter selection.

• Clear Column: Clears the data in the column.

  You cannot undo Clear Column. After a column is cleared, you must manually add the information back to the column.