Skip to content
  • There are no suggestions because the search field is empty.

Missing Data for Sage Intacct Workbooks

Follow the steps in this article if your Sage Intacct connection is successful, but the workbook is missing some data

Data Extraction can only pull books based on the permissions of the Web Services user who completes the connection. If the user doesn't have view access to user-defined books, for example, Sage Intacct excludes them from the data. In this case, the connection finishes successfully and Data Extraction does not show an error message. 

How to Fix it

  1. In Sage Intacct, go to Company > Admin > Web Services Users.

  2. Open the Web Services user you use for Data Extraction and then select Subscriptions > Permissions.

  3. Under General Ledger, confirm the top level is set to Read-only.

  4. Enable View for User-defined books.

  5. If you use multiple entities with consolidations, enable View for Manage Books under Global Consolidations.

  6. Click the Save button in the top-right corner.

  7. Start a new collection in Data Extraction and reconnect.

  8. Confirm your user-defined books now appear when you select entities and books.

🗒️ NOTE

If you use role-based permissions, make these changes to the role assigned to the Web Services user. See the permissions articles linked below for more details: