Use GET data from Statutory Reporting

To get data from the system to add to Excel:

In Excel, go to Workpapers
and then Field Browser
.

Select:

Get data

ONESOURCE Statutory Reporting

Select the template your entity table's based out of

Locate your table in the Fields
section.

Select the table and drag your table data to the Excel spreadsheet in the cell you want your data placed.

At this time, the

Function Wizard

window opens.

Enter Reporting Entity Code
.

Enter the Financial Period Start Date
in the format of mm/dd/yyyy.

Select Next
.

Enter the Target Range
.

Select the Target Range
icon, then select the cell you want your table data placed.

Select OK
, and then Done
.

This article applies to: