PRINT UNASSIGNED/DUPLICATE ACCOUNT REPORT
Use this screen to generate a report that lists general ledger accounts that are not assigned to a given financial statement or accounts that are included more than once on a given financial statement. You create and maintain financial statements on the Manage Financial Statements screen.
Use this screen when you want to check for unassigned accounts or accounts that are linked more than once.
Location
Identification
Use the fields in this block to create a new parameter ID or to retrieve
a previously saved parameter ID. A parameter ID represents a set of screen
selection parameters. After you have saved a parameter ID and its related
parameters, you can retrieve them using Query.
You can use the retrieved parameters to produce reports and run processes
more efficiently and with greater consistency. The saved parameters are
also useful and necessary when you want to run the process as part of
a batch job. Many users save a unique set of parameters for each different
way they run a report or process. When you select a previously saved parameter
ID or parameter description, the associated saved screen selection parameters
automatically display as selection defaults. The page setup and print
options are also included in the saved parameter ID if there are any.
You can change any of the associated selection defaults as necessary.
Parameter ID
Enter, or click 
to select, a parameter
ID of up to 15 alphanumeric characters. Choose characters for your parameter
ID that help identify the type of selections you made in the screen, such
as PERIOD or QUARTERLY.
When you save your record, all the selections made in the screen are
stored with the parameter ID. Later, you can retrieve the parameter using
Query.
You can use the parameter to run the process more efficiently because
you can select the parameter ID with its previously defined screen selections.
After the default selections display in the screen, you can override the
defaults.
Description
Enter, or click to select, a parameter
description of up to 30 alphanumeric characters.
Selection Ranges
Account Types
Option
Use this drop-down list to select the range of account types to include on the report. Valid options are:
-
All — Select this option to include all account types. The Start and End fields are disabled for this option. This is the default.
-
One — Select this option to include only one account type and then enter that account type in the Start field. The End field is disabled for this option.
-
Range — Select this option to include a contiguous range of account types. Enter the beginning account type for the range in the Start field and enter the ending account type of the range in the End field.
-
From Beginning — Select this option to include a range of account types that begins with the first of all the available account types and ends with the account type that you enter in the End field. The Start field is disabled for this option.
-
To End — Select this option to include a range of account types that begins with the account type that you enter in the Start field and ends with the last of all the available account types. The End field is disabled for this option.
Start/End
Enter the starting and/or ending account types for the range of account types to be included on the report. Depending on your selection in Option, one or both of these fields may be inactive.
F/S Codes
Option
Use this drop-down list to select the range of financial statement codes to include on the report. Valid options are:
-
All — Select this option to include all financial statement codes. The Start and End fields are disabled for this option. This is the default.
-
One — Select this option to include only one financial statement code and then enter that financial statement code in the Start field. The End field is disabled for this option.
-
Range — Select this option to include a contiguous range of financial statement codes. Enter the beginning financial statement code for the range in the Start field and enter the ending financial statement code of the range in the End field.
-
From Beginning — Select this option to include a range of financial statement codes that begins with the first of all the available financial statement codes and ends with the financial statement code that you enter in the End field. The Start field is disabled for this option.
-
To End — Select this option to include a range of financial statement codes that begins with the financial statement code that you enter in the Start field and ends with the last of all the available financial statement codes. The End field is disabled for this option.
Start/End
Enter the starting and/or ending financial statement codes for the range of financial statement codes to be included on the report. Depending on your selection in Option, one or both of these fields may be inactive.
Page Break
Select this check box to begin a new report page for each financial statement code.
Non-Contiguous Ranges
Select this check box if you want to select multiple separate financial statement codes or ranges of codes for your report. Use the F/S Code Non-Contiguous Ranges subtask to specify the ranges.
Options
Print
Unassigned Accounts
Select this option to generate the Unassigned Accounts Report. That report lists accounts that have not been assigned to a given Costpoint financial statement.
Duplicate Accounts
Select this option to generate the Duplicate Accounts Report. That report lists accounts that have been assigned more than once to a given Costpoint financial statement.
Include Inactive Accounts
Select this check box to include accounts for which the Active check box is not selected on the Manage Accounts screen.
Select F/S Type
Income Statement
Select this option to display accounts that either are not assigned to an income statements or are duplicated on an income statement. (The option you select in Print determines whether the report displays unassigned or duplicated accounts.)
Balance Sheet
Select this option to display accounts that either are not assigned to a balance sheet or are duplicated on a balance sheet. (The option you select in Print determines whether the report displays unassigned or duplicated accounts.)
Balance Sheet - No R/E
Select this option to display accounts that do not contribute to retained earnings and that either are not assigned to a balance sheet or are duplicated on a balance sheet. Accounts that contribute to retained earnings are excluded. (The option you select in Print determines whether the report displays unassigned or duplicated accounts.)
Balance Sheet - Only R/E
Select this option to display accounts that contribute to retained earnings and that either are not assigned to a balance sheet or are duplicated on a balance sheet. Accounts that do not contribute to retained earnings are excluded. (The option you select in Print determines whether the report displays unassigned or duplicated accounts.)
Sort By
Sort
Use this drop-down list to specify how you want to sort the report data. Valid options are:
Subtasks
|
Subtask
|
Description
|
|
F/S Code Non-Contiguous Ranges
|
Click this link to use the F/S Code Non-Contiguous Ranges subtask to select multiple separate financial statement codes or ranges of codes for your report.
|
Generate the Unassigned Accounts Report or Duplicate Accounts Report
To generate the Unassigned Accounts Report or the Duplicate Accounts Report, enter the report options you want and then click Print Default Report button on the Action menu.