Skip to main content
Workpapers Add-in
Search
Search Statutory Reporting (ONESOURCE) Support Help and Support.

This article applies to:

  • Product: ONESOURCE Statutory Reporting
  • Subject: Workpapers,Add-in

Use GET data from Statutory Reporting

Learn to use GET data in Statutory Reporting.
To get data from the system to add to Excel:
  1. In Excel, go to
    Workpapers
     and then
    Field Browser
    .
  2. Select:
    1. Get data
    2. ONESOURCE Statutory Reporting
    3. Select the template your entity table's based out of
  3. Locate your table in the
    Fields
     section.
  4. Select the table and drag your table data to the Excel spreadsheet in the cell you want your data placed.
  5. At this time, the
    Function Wizard
     window opens.
  6. Enter
    Reporting Entity Code
    .
  7. Enter the
    Financial Period Start Date
     as mm/dd/yyyy in text format.
  8. Select
    Next
    .
  9. Enter the
    Target Range
    .
  10. Select the
    Target Range
     icon, then select the cell you want your table data placed.
  11. Select
    OK
    , and then
    Done
    .