UseNetOffsheetData

The UseNetOffsheetData parameter evaluates adjustment data and net data for formulas whose sources are not part of the consolidation scope and have been adjusted. These settings are available:

Value	Description
0	(Default) Evaluates net adjusted off-sheet reference sources in formulas when at least one line is adjusted in the schedule being consolidated
1	Evaluates net adjusted off-sheet reference sources in formulas when no line in the schedule being consolidated is adjusted

Selecting the Use Net Adjusted Off-sheet Data option on the Consolidation page is equivalent to setting the parameter to 1.

If no line on the consolidated schedule is adjusted but formulas refer to other lines that have been adjusted, use setting 1. Do not use the default value of 0, as this causes consolidations to incorrectly evaluate formulas by using reported data (instead of net adjusted data) for off-sheet reference sources.

For best performance, use the default value of 0 if at least one line on the schedule is adjusted.

If IncludeOffSheetLines is set to 1 and UseNetOffsheetData is set to 1, then the consolidation does not respect the UseNetOffsheetData setting.

Type: Scripting parameter, Page option (Use Net Adjusted Off-sheet Data)

Related parameters: IncludeOffSheetLines, ProcessUnsubmittedStatements