PRINT COMPARATIVE BOOK DATA (CONTINUED)

Select Asset Accounts

Use the fields in this optional group box to select asset accounts for the report. Asset account data specifies "ownership" and is required for all Asset Master records.

Range Option

Use this drop-down box to select a range option. Options are "All," "One," "Range," "From Beginning," and "To End." The default option for this field is "All."

If you save the print parameters for this report, the selected range option, as applicable, will be identified in the Query table in the Asset Account Range Option column.

From

Enter the beginning asset "ownership" account for the range option or use Lookup to select one.

Because this is a standard Lookup to the ACCT table, you may find that you have selected data for which asset records do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve from the ASSET table or the ASSET_OTH_BK_DEPR table, as applicable, may not be selected.

If you select "All" or "From Beginning" in the Range Option field, this field will be inactive.

If you save the print parameters for this report, the selected From value, as applicable, will be identified in the Query table in the From Asset Account column.

To

Enter the ending asset "ownership" account for the range option or use Lookup to select one.

Because this is a standard Lookup to the ACCT table, you may find that you have selected data for which asset records do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve from the ASSET table or the ASSET_OTH_BK_DEPR table, as applicable, may not be selected.

If you select "All," "One," or "To End" in the Range Option field, this field will be inactive.

If you save the print parameters for this report, the selected To value, as applicable, will be identified in the Query table in the To Asset Account column.

Select Asset Organizations

Use the fields in this optional group box to select asset organizations for the report. Asset organization data specifies "ownership" and is required for all Asset Master records.

Range Option

Use this drop-down box to select a range option. Options are "All," "One," "Range," "From Beginning," and "To End." The default option for this field is "All."

If you save the print parameters for this report, the selected range option, as applicable, will be identified in the Query table in the Asset Organization Range Option column.

From

Enter the beginning asset "ownership" organization for the Range Option or use Lookup to select one.

Because this is a standard Lookup to the ORG_ACCT table, you may find that you have selected data for which asset records do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve from the ASSET table or the ASSET_OTH_BK_DEPR table, as applicable, may not be selected.

If you select "All" or "From Beginning" in the Range Option field, this field will be inactive.

If you save the print parameters for this report, the selected From value, as applicable, will be identified in the Query table in the From Asset Organization column.

To

Enter the ending asset "ownership" organization for the Range Option or use Lookup to select one.

Because this is a standard Lookup to the ORG_ACCT table, you may find that you have selected data for which asset records do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve from the ASSET table or the ASSET_OTH_BK_DEPR table, as applicable, may not be selected.

If you select "All," "One," or "To End" in the Range Option field, this field will be inactive.

If you save the print parameters for this report, the selected To value, as applicable, will be identified in the Query table in the To Asset Organization column.

Select Asset Projects

Use the fields in this optional group box to select asset projects for the report. Asset project data specifies "ownership" and is optional for all Asset Master records.

Range Option

Use this drop-down box to select a range option. Options are "All," "One," "Range," "From Beginning," and "To End." The default option for this field is "All."

If you save the print parameters for this report, the selected range option, as applicable, will be identified in the Query table in the Asset Project Range Option column.

From

Enter the beginning asset "ownership" project for the range option or use Lookup to select one.

Because this is a standard Lookup to the PROJ table, you may find that you have selected data for which asset records do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve from the ASSET table or the ASSET_OTH_BK_DEPR table, as applicable, may not be selected.

If you select "All" or "From Beginning" in the Range Option field, this field will be inactive.

If you save the print parameters for this report, the selected From value, as applicable, will be identified in the Query table in the From Asset Project column.

To

Enter the ending asset "ownership" project for the range option or use Lookup to select one.

Because this is a standard Lookup to the PROJ table, you may find that you have selected data for which asset records do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve from the ASSET table or the ASSET_OTH_BK_DEPR table, as applicable, may not be selected.

If you select "All," "One," or "To End" in the Range Option field, this field will be inactive.

If you save the print parameters for this report, the selected To value, as applicable, will be identified in the Query table in the To Asset Project column.

Select Record Status

Use the checkboxes in this group box to choose the record status type(s) to include in your purge selection criteria. You can print data for active records, inactive records, and/or disposals.  You must select at least one checkbox in this group box.

Active

This checkbox is selected by default.  Select this checkbox to include active records in your print selection criteria.

If you select this checkbox and save the print parameters for this report, "Y" will be inserted into the Active Records column in the Query table.

Inactive

Select this checkbox to include inactive records in your print selection criteria.

If you select this checkbox and save the print parameters for this report, "Y" will be inserted into the Inactive Records column in the Query table.

Disposals

Select this checkbox to include disposals in your print selection criteria.

If you select this checkbox and save the print parameters for this report, "Y" will be inserted into the Disposals column in the Query table.

Previous

Select this pushbutton to return to the previous selection screen.

Cancel

Select this pushbutton to exit from the Print Comparative Book Data Report screen and return to the menu.

Hint:  You can save your sort options and selection criteria for this report with or without printing. After making your selections, select the Save button in the toolbar or go to Save in the File menu. Enter an alphanumeric identifying code and a short description to help you recognize the report parameters and select OK. Later, you can run Find or Query from this screen to access the print parameters you created, and run the same report without having to enter all the selection screen information again. Stored report parameters are especially useful if reports are to be run through Process Manager.

If you want to keep these parameters but want to run a slightly different report, you can use Clone to copy the parameters and make minor changes to the parameters without changing your saved parameters. To use Clone, go to the File menu or press [F4]. The Clone window will display on the screen. Enter the parameters ID you want to clone, or select Execute to display and select from a list of parameter IDs. When you click on the Select pushbutton, the system makes a copy of the parameters that you can edit as needed.

Table Information

For the General Ledger book, the system reads data from the ASSET (Asset)table.

For the optional other books 2-10, the system reads data from the ASSET_OTH_BK_DEPR (Asset Other Books) table.

Additional data needed for this report is retrieved from the FA_BOOK_SETTINGS (Fixed Assets Book Settings) table.

Lookups, as applicable, access the following tables: