System Parameters Reference
You can activate the following System Parameters in the application for additional functionality. The "Parameter Function" column describes the functionality.
Parameter Name | Parameter | Parameter Function |
|---|---|---|
ALLOWMULTICURRENCYREPORT | YES | YES allows sub-consolidated reports to display in Local Currency, when the unit designated currency does not agree. |
ALTCALC2_ADJ | YES | Defines where the second scenario calculation posts. |
BRIDGE_ALLOW_ALL_UNITS | Y or N | Y by default (if there is no parameter), allows all users to bridge data into all units in the system regardless of whether or not they have access rights to the units. N removes the consolidation option for the bridge. |
BRIDGE_ALLOW_SUBCON_SELECT | Y or N | Y by default (if there is no parameter), allows all users to bridge data into Sub Consolidations to which they have access rights. N, no longer displays the Sub Consolidation drop-down menu for the bridge. |
BRIDGE_ALLOW_UNIT_SELECT | Y or N | Y by default (if there is no parameter), allows all users to bridge data into Units to which they have access rights. N no longer displays. The Unit drop-down list for the bridge. |
BRIDGE_DEFAULT_TAG | Tag Letter | Creates a default Tag letter to be used when data is brought in using the bridge. |
BSOS_XXXX | Tag Letter_Tag Letter | Activates the Balance Sheet Offset Summary report. Balance Sheet Only amounts entered are included with the tags established in the system parameter. note
These amounts are rate affected and display in the appropriate column based on the tag chosen. |
CASE_INSENSITIVE_LOGIN | 0 or 1 | **0 specifies that all user logins are case-sensitive. 1 specifies that all user logins are not case-sensitive |
CC_DISABLE_STATES | 0 or 1 | 1 removes pre-defined states from the Data Entry > Jurisdiction drop-down list. |
CLIENTDISPLAYNAME | Text | **Enter the name of the client to display in report pages in the system, as well as in the header of printed reports. |
DefEndBalDefault | Tag letter and type of event | Designates where the difference is posted when Ending Balances are entered vs Activity for Book/Tax Basis Temporary Differences.Examples: O, A uses tag O and posts as Activity X, D uses tag X and posts as Deferred Only |
DEF_RF_SUMMATION_COLUMN | 1 through 26 | Selects the column in the Deferred Balances Report to display a sub-total balance for the Adjusted Beginning Balance or any other purpose. |
DEF_RF_SUMMATION_NAME | Text | Column Heading for the column created with DEF_RF_SUMMATION_COLUMN parameter. |
DISABLE_DEFERREDPROVONLY | 1 or 2 | 1 displays the Deferred Provision Only entry field. However, no entry is permitted. 2 removes the Deferred Provision Only entry field. Note: This parameter does not work for the State Details page. |
DISABLE_RDS_CONSTRAINTS | 0 or 1 | 1 removes the check when joining datasets in a sequential dataset. |
EffectRatesDiffStat_PermNet | 0 or 1 | 1 The Tax Effect of Rates Different than Statutory for permanent differences is included in the respective permanent difference line. |
EFFRATEBRKOUT | 0 or 1 | 1 enables the Unit Tax Rate view in Unit and Filing Group reports. It also enables on-page breakout, as well as the Use Blended Rate view in Sub-Consolidated and Consolidated reports. |
ENABLE_APICPOOL | 0 or 1 | 1 enables the APIC Pool functionality and report. |
Enable_GS_Scrunch | 0 or 1 | 1 enables you to select a Current GAAP, Current STAT, Non-Current GAAP, and Non-Current STAT class or tag for the scrunch functionality. |
ENABLE_TSDEBUG | 1 | Information for the support team. |
EXTENDED_USER_RESTRICTION Activate in Manage Configuration | 0 or 1 | **1 enables assignments made for a user in the Admin area under System/Administer Users to restrict Import of data and Batch Print reports to only assigned datasets, units and sub-consolidations. |
FILTER#_NAME | Text | Names the filtered Deferred Balances Report created with the FILTER#_SQL parameter. |
FILTER#_SQL | SQL query | Filters deferred balances based on a SQL query to show a subset of deferred balances. |
FISCAL_MONTHS_OFFSET | 0-11 | 0 designates a calendar year for the payable auto posting. For fiscal years, enter the fiscal month minus 12 (e.g., -1 = November; -2 = October, etc.). Ending balances roll over to create beginning balances with the code BBAL and a date of fiscal year end plus 1 day. For example: If the paramvalue is -3, CPROV posts with a date of 9/30/CY and BBAL posts with a date of 10/1/CY. |
FLOWTHROUGHFACTORS_USE_FX | 0 or 1 | 1 displays the FX fields (Use Fx Rates During Calculations, Beg Fx Rate, and Wgt Avg Fx Rate) on the Flow-Through Factor page. |
FLOWTHROUGHFACTORS_AUTOCALC | 0 or 1 | 1 automatically calculates flow-through factors in reports. |
FLOWTHROUGHFACTORS_MANUALCALC | 0 or 1 | 1 displays the Calculate Flow-Through Factor Results menu item in the Provision and Estimated Payments datasets. |
FORMAT_FOR_EXCEL | 0 or 1 | 1 configures the Excel output to treat Leading Zeros or Scientific Notation as text, not numbers. |
GLOBAL_XSL | 0 or 1 | **1 activates the Global Attachments page in the Administration area. This page allow the JE style sheet to be uploaded. |
GLOBAL_XSL_BROWSEUPDATE | 0 or 1 | **1 displays the Browse and Update Attachment button on the Global Attachments Page. |
GLOBAL_XSL_SAVEAS | 0 or 1 | **1 displays the Attachment Save As button on the Global Attachments page. |
GlobalRegion | US or EUROPE or CANADA | **Select US, EUROPE, or CANADA to determine presentation of certain terminology in the user interface and reports. |
gstags# | Tag Letter | Tag Letter isolates GAAP to STAT entries on the Tax Provision report. This parameter works in conjunction with the SHOW_GAAPTOSTAT. |
JE_AUTOCREATE_OUTPUTJE | 0 or 1 | 1 Configurable Journal Entry |
itstagpermsgaap-yeprovgs-1 | G:Manual | Define GAAP-to-Stat and Stat-to-Tax Tags for data entry pages by adding the following parameters in manage restricted features. |
itstagpermsstat-yeprovgs-1 | S:Manual | Define GAAP-to-Stat and Stat-to-Tax Tags for data entry pages by adding the following parameters in manage restricted features. |
itstagtempsgaap-yeprovgs-1 | G:Manual | Define GAAP-to-Stat and Stat-to-Tax Tags for data entry pages by adding the following parameters in manage restricted features. |
itstagtempsstat-yeprovgs-1 | S:Manual | Define GAAP-to-Stat and Stat-to-Tax Tags for data entry pages by adding the following parameters in manage restricted features. |
JE_AUTOREGEN_TAXCALCS | 0 or 1 | 1 Configurable Journal Entry |
JE_COMPONENT_FILTER_FEDERAL_XXX | Component ID | **Filters the Federal Component list for detail JE configurations. |
JE_COMPONENT_FILTER_STATE_XXX | Component ID | **Filters the State Component list for detail JE configurations. |
JE_COMPONENT_ROLLUP_SET_CODE | Alphanumeric | **The component rollup set code of the rollup group. Example: R99. (Use the Manage Rollups page to create rollup sets and groups.) Rollup groups add items to the Tax Calculation drop-down list on the Journal Entries page. |
JE_DATASET_DELETE_ALL | 0 or 1 | 1 displays the Delete all Journal Entries menu option in the Provision dataset under Data Review > Dataset > Administration. |
JE_FILTER# | Text | **A Temporary Difference Code. # can be any number from 1-9. Filters add items to the Tax Calculation drop-down list on the Journal Entries page. |
JE_FILTER_NAME# | Text | **The name of the filter group, such as Depreciation. # can be any number from 1-9. Filters add items to the Tax Calculation drop-down list on the Journal Entries page. |
JE_ROUNDING_DECIMAL_PLACES | Any integer from -6 to 6. | Number of places to which calculated journal entries are rounded. The default value in the calculation procedure is 2 (no rounding). |
JE_SHOW_ZERO_BOOKCALCS | 0 or 1 | 1 indicates that zero dollar Book calculations display on Output Journal Entries reports. |
JE_SHOW_ZERO_TAXCALCS | 0 or 1 | 1 indicates that zero dollar Tax calculations display on Output Journal Entries reports. |
JE_STATE_GROUP_NAME_# | Text | The state group name. # can be any number from 1-9. State groups add items to the Tax Calculation drop-down list on the Journal Entries page. |
JE_STATE_GROUP_%_STATE## | Text | A state code. % can be any number from 1-9 and ## can be any number form 00 - 99. State groups add items to the Tax Calculation drop-down list on the Journal Entries page. |
JE_Supplemental_Label# | Text | The header text for Output Journal Entries reports. |
JE_TAG_GROUP_#_NAME | Text | The tag group name. # can be any number from 1-9. Tag groups add items to the Tax Calculation drop-down list on the Journal Entries page. |
JE_TAG_GROUP_#_TAGS | Text | A group of tags separated by commas. Example: F, M, Q # can be any number from 1-9. Tag groups add items to the Tax Calculation drop-down list on the Journal Entries page. |
JE_TYPE_LOCKED | 0 or 1 | 1 prevents the JE Type field on the Journal Entries page from being editable after a journal entry configuration is saved. |
JE_UNIT_DELETE_ALL | 0 or 1 | **1 activates the Delete All button on the Journal Entries page. |
LIMIT_PAYABLE_DATES | Y or N | Y allows only dates within the dataset to be used when making entries in the payable. N lifts the restriction and allows any date to be entered. |
LockoutMinutes | Numeral | Number of minutes a user should be locked out of the system once they have exceeded the specified number of login attempts. |
MaxFailLogins | Numeral | Number of login attempts before a user is locked out of the system. |
PassHistNum | Numeral | Number of unique passwords that must be used before a user's password can be repeated. |
POST_AMORTIZED | 0, 1 or 2 | 1 posts Deferred Only adjustments to Book/Tax Basis. lines. 2 adjustments with deferred only amounts will post the RTP to the respective Tax Basis and Book/Tax Basis lines.
|
POST_DO | 0 or 1 | 1 enables the calculation of Deferred Only Return to Provision (RTP) true-ups. |
POST_BSO | 0 or 1 | 1 enables the calculation of Balance Sheet Only Return to Provision (RTP) true-ups. Your adjustments with balance sheet only amounts will post the RTP to the respective Tax Basis and Book/Tax Basis lines. |
POST_GAAP | 0 or 1 | 1 enables the GAAP to STAT RTP posting |
POST_STATE | 0 or 1 | 1 enables the calculation of State Return to Provision (RTP) true-ups. |
PRINTFORMAT_PAGESWIDE | Numeral | Number of pages reports should print to override the default of shrink to fit 1 page. |
PROVISION_HIDE_STATES | 0 or 1 | 1 adjusts the Stored Procedure Tax Provision report, so that the detailed view does not display state-by-state detail. |
PROVSCBRKOUT | 0 or 1 | 1 displays the CSC Tax Provision Report under sub-consolidation. |
REPORT_FOOTER | Text | Text entered displays as a page footer on reports when printed. |
REPORT_HEADER | Text | Text entered displays as a page header on reports when printed. |
ReportingCurrencySymbol | Text | By adding this parameter, you can change the default three-letter reporting currency symbol (USD) that appears in the header of reports when viewed in Reporting Currency. |
SEPARATESTATE# | State Code | Enter the State code to configure how the State Tax Prov Rpt Breakout displays works with the STATE_BREAKOUT_UNIT parameter. Activate in Manage Configuration |
SHOW_ADVANCEDLIABILITY | 0 or 1 | 1 allows Payable functionality and allows it to work properly. SHOW_SIMPLELIABILITY and SHOW_LIABILITY should be 0. SHOW_LIABILITY |
SHOW_ALTPROVCALC | 0 or 1 | 1 Alternative Provision Calculations |
SHOW_BRIDGEUNITMAP | 0 or 1 | 1 Define Where 1st Scenario Calculation Posts |
N/A | N/A | ***1 activates the Unit Mapping page in the Manage Bridge section. |
SHOW_CASHPYMTS | 0 or 1 | **1 activates the Cash Payments report, which displays the Return Basis Provision (formerly known as the Cash Provision) and subtracts the payments. |
SHOW_CTA | 0 or 1 | 1 enables you to manually enter Currency Translation Adjustment (CTA) calculations for all temporary differences via the Additional CTA option. The entry is in the Reporting Currency and After Tax Rate format. Depending on which fields are populated, amounts could impact both Current and Deferred Tax Expense, Deferred Only Tax Expense, or Equity. Amounts are tracked and shown on reports with a system-defined After Tax Temporary Difference. |
SHOW_DATABASEANALYZER | 0 or 1 | **1 activates the TS Database Analyzer, which allows Administrators to run SQL queries on database data. |
SHOW_DEFBALCSCBRKOUT | 0 or 1 | 1 displays the CSC Deferred Balances Report under sub-consolidation. |
SHOW_EFFRATECONSOLPTBIPCT | 0 or 1 | 1 displays an additional line in the effective tax rates that further analyzes the components in the CSC ETR Report under sub-consolidation. |
SHOW_EFFRATECSCBRKOUT | 0 or 1 | 1 displays the CSC Effective Tax Rate Report under sub-consolidation. |
SHOW_EXPECTEDDEFERRED | 0 or 1 | 1 displays the Expected Deferred Report. |
SHOW_GAAPTOSTAT | 0 or 1 | 1 allows GAAP to STAT functionality. This parameter works in conjunction with the GAAPTOSTAT and gstags parameters. |
SHOW_JE | 0 or 1 | 1 allows the Journal Entry functionality. |
SHOW_LIABILITY | 0 or 1 | 1 enables the Liability tab, if using. SHOW_ADVANCEDLIABILITY should be set to 0. |
SHOW_OUTPUTJE | 0 or 1 | 1 activates the configurable journal entry |
SHOW_PAYABLERECLASS | 0 or 1 | 1 activates the reclass functionality to allow unit-to-unit reclass of the payable liability. |
SHOW_PLUGINDEV | 0 or 1 | ***1 to display the plug-in report settings page. |
SHOW_SIMPLELIABILITY | 0 or 1 | 1 enables Simple Liability if using. SHOW_ADVACEDLIABILITY should be set to 0. |
SHOW_WORKPAPER | 0 or 1 | 1 displays the Workpaper Report. |
STATE_BREAKOUT_UNIT | Unit Code | 1 Enter the Unit code to configure how the State Tax Prov Rpt Breakout display works with the SEPARATESTATE# parameter. |
TBIS_ADJ | 0 or 1 | 1 Define where BBC Calculation Posts |
TSPasswordExpireDays | Numeral | 1 The number determines how many days a password can be active. |
TSPasswordMinDigits | Numeral | The number determines the minimum number of digits that must be in a user's password. |
TSPasswordMinLength | Numeral | The number determines the minimum amount of keystrokes that must be in a user's password. |
USE_OLD_AMTESTIMATOR_Default | 0 or 1 | **0 uses the Reporting Currency Alternative Minimum Tax (AMT) calculation method for any new dataset that is created. 1 creates new datasets with the Local Currency AMT methodology. |
USE_SPDEFBALREPORTS | 0 or 1 | 1 allows additional view options on the Deferred Balances report and the expanded views display on page vs. exporting to Excel. |
USE_SPPROVISIONREPORTS | 0 or 1 | 1 allows additional view options on the Tax Provision report and the expanded views display on page vs. exporting to Excel. |
USE_SPPROVSUMMARYREPORTS | 0 or 1 | 1 allows additional view options on the State Provision Summary report. The expanded views display on page vs. exporting to Excel. |
UserExtended | 0 or 1 | 1 adds more information fields about a user (email, phone, number, etc.) in the Administer User section under the Administration area under System. |