Contents of the Print Disposal Transactions Edit Report Screen

Use the fields and options to configure the Print Disposal Transactions Edit Report screen.

This report uses dynamic worktables. Because these tables are user-specific and will be deleted after the process is complete and data has been transferred to a permanent table, each user can only run one Print Disposal Transactions Edit Report using the same user name at one time. Multiple users, however, can run the report simultaneously, as long as they are logged in under different user names.

Before entering and posting disposals, see Related Topic, Creating and Posting Disposals. This special topic includes a detailed explanation, as well as examples, of how the disposal price affects disposal entries. It also explains how depreciation adjustments and gains and losses are posted in the General Ledger.

Note: The gain/loss amount that prints in this report is not the gain/loss amount that will be posted to the disposal's gain/loss account/organization/project combination. Book value is always posted as the gain/loss amount, regardless of disposal price. The gain/loss amount printed in this report is the same gain/loss amount calculated for display purposes on the Manage Disposal Transactions screen.

The Print Disposal Transactions Edit Report provides a current "snapshot" of existing disposal information. Print this report before posting disposals to review the information from the Manage Disposal Transactions screen.

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, if there are any, are also included in the saved parameter ID. You can change any of the associated selection defaults as necessary.

Field Description
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 on the screen, such as PERIOD or QUARTERLY.

When you save your record, all the selections made on 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 on the screen, you can override the defaults.

Description

Enter, or click to select, a parameter description of up to 30 alphanumeric characters.

Selection Ranges

Gain/Loss Accounts

Use the following fields to select records from gain/loss accounts for the report.

Note: The gain/loss account is a required field on the Manage Disposal Transactions screen for a depreciable asset (or for a non-depreciable asset for which you have selected the Post Disposal to G/L check box on the Manage Asset Master Information screen and the corresponding check box on the Manage Asset Description Information screen). The system posts the cost value with a reversed sign to this account as a gain or loss. Because the gain/loss that prints in this report is the gain/loss amount from the Manage Disposal Transactions screen, the gain/loss in this report is only the expected gain or loss based on the expected disposal price. The gain/loss amount that prints in this report is not the gain/loss amount that will be posted to the disposal's gain/loss account/organization/project combination.

The selection you make in any of the check boxes in the Include Record Type or Include Selection Status group boxes may modify which records from the selected asset account(s) are actually printed on the report.

Field Description
Option

The default option for this field is All. If you have a large number of gain/loss accounts, you may want to select a different option.

Select the range option from the drop-down list. The available options are:

  • All
  • One
  • Range
  • From Beginning
  • To End
Start

Enter, or click to select, the beginning gain/loss account number already associated with your disposals in this field. Because this is a standard Lookup to the ACCT table, you may find that you have selected an account for which disposal transactions do not exist or do not meet your other selection criteria. In either event, the data you expect to retrieve from the FA_DISP_EDIT table may not be selected.

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

End

Enter, or click to select, the ending gain/loss account number already associated with your disposals. Because this is a standard Lookup to the ACCT table, you may find that you have selected an account number for which disposal transactions do not exist or do not meet your other selection criteria. In either event, the data you expect to retrieve from the FA_DISP_EDIT table may not be selected.

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

Gain/Loss Organizations

Use the following fields to select gain/loss organizations for the report. Your selection in any of the check boxes in the Include Record Type or Include Selection Status group boxes may modify which records from the selected organization(s) are actually printed on the report.

Field Description
Option

The default option for this field is All. You can accept the displayed default range option, or select one from the drop-down list. The options available are:

  • All
  • One
  • Range
  • From Beginning
  • To End
Start

Enter, or click to select, the beginning gain/loss organization number in this field. Because this is a standard Lookup to the ORG table, you may find that you have selected an organization for which disposal transactions do not exist or do not meet your other selection criteria. In either event, the data you expect to retrieve from the FA_DISP_EDIT table may not be selected.

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

End

Enter, or click to select, the ending gain/loss organization number in this field. Because this is a standard Lookup to the ORG table, you may find that you have selected an organization for which disposal transactions do not exist or do not meet your other selection criteria. In either event, the data you expect to retrieve from the FA_DISP_EDIT table may not be selected.

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

Disposal Dates

The disposal date usually represents the date the disposal becomes effective, although any date can be used (the date is not used in system calculations). Date is a required field in the Disposal Info group box on the Manage Disposal Transactions screens, and the system date of entry is the default. Use the fields in this group box to choose disposal dates for the report. Your selection in any of the check boxes in the Include Record Type or Include Selection Status group boxes may modify which records from the selected disposal date(s) are actually printed on the report.

Field Description
Option

The default option for this field is All. You can accept the displayed default range option, or select one from the drop-down list. The options that are available are:

  • All
  • One
  • Range
  • From Beginning
  • To End
Start

Enter, or click to select, the beginning disposal date. Because the system accepts any date entry in this field, you may find that you have entered a disposal date for which data does not exist in the FA_DISP_EDIT table or does not meet your other selection criteria. In either event, the data you expect to retrieve may not be selected.

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

End

Enter, or click to select, the ending disposal date. Because the system accepts any date entry in this field, you may find that you have entered a disposal date for which data do not exist in the FA_DISP_EDIT table or does not meet your other selection criteria. In either event, the data you expect to retrieve may not be selected.

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

Asset/Item Numbers

Use the following fields to select asset/item numbers for the report. If you enter a specific asset number, you must also enter a corresponding item number before you can run the report. The selection you make in any of the check boxes in the Include Record Type or Include Selection Status group boxes may modify which records from the selected asset/item number(s) are actually included in the report.

Field Description
Option

The default option for this field is All. You can accept the displayed default range option, or select one from the drop-down list. The available options are:

  • All
  • One
  • Range
  • From Beginning
  • To End
Start

Enter, or click to select, the beginning asset/item number for the range. Because this is a standard Lookup to the ASSET table, you may find that you have selected an asset/item number for which disposal transactions do not exist or do not meet your other selection criteria. In either event, the data you expect to retrieve from the FA_DISP_EDIT table may not be selected.

If you select All or From Beginning in the Option field, these fields will be inactive.

End

Enter, or click to select, the ending asset/item number for the range. Because this is a standard Lookup to the ASSET table, you may find that you have selected an asset/item number for which disposal transactions do not exist or do not meet your other selection criteria. In either event, the data you expect to retrieve from the FA_DISP_EDIT table may not be selected.

If you select All, One, or To End in the Option field, these fields will be inactive.

Options

Include Record Type

Use this group box to include disposals of depreciable and/or non-depreciable assets in your report. Select one or both of the check boxes in this group box. You must select at least one of these check boxes before you can run the report.

If you select the Non-Depreciable check box, all non-depreciable records that meet the other selection criteria will be included, regardless of their Post Disposal to G/L status on the Manage Asset Master Information screen or the corresponding check box on the Manage Asset Description Information screen.

Field Description
Depreciable

This check box is selected by default. Leave this check box selected to include disposals for depreciable assets in your report. If you do not want your report to include disposals for depreciable assets, clear this check box.

Non-Depreciable

Select this check box to include disposals for non-depreciable assets in your report. If you clear this check box, disposals for non-depreciable assets will not be included. (All non-depreciable records that meet the other selection criteria will be included, regardless of their Post Disposal to G/L status on the Manage Asset Master Information screen or the status of the corresponding check box on the Manage Asset Description Information screen).

Include Selection Status

Use the options in this group box to include selected disposals and/or disposals that are on hold in your report. Select one or both of the check boxes in this group box. You must select at least one of these check boxes before you can run the report.

Field Description
Selected Disposals

This check box is selected by default. Leave this check box selected to include disposals which have been assigned the Selected for Posting status on the Manage Disposal Transactions screen. If you do not want your report to include selected disposals, you must clear this check box.

Disposals on Hold

Select this check box to include disposals that have been assigned a Hold status on the Manage Disposal Transactions screen. If you clear this check box, only selected disposals will be included.

Sort By

Select the sort option for the report using this group box. The default sort selection is by Asset/Item Number. If you choose a different sort option, records will be printed in ascending asset/item number order within the primary sort category you select. Asset account, organization, and project information will print on the report only if you select the Asset Account, Asset Organization, or Asset Project sort options.

Field Description
1st Sort

Select a sort option from the drop-down list. The available options are:

  • Asset/Item Number
  • Selection Status
  • Asset Account
  • Asset Organization
  • Asset Project
  • Disposal Date
  • Gain/Loss Account
Page Break

Select this check box if you want a page break each time the selected sort parameter changes. This check box is disabled if you have selected the Asset/Item Number sort option.

Note: If you want to keep these parameters but you want to run a slightly different report, you can use Copy Record to copy the parameters and make minor changes to the parameters without changing your saved parameters. To use the function Copy Record, open the record the you want to copy and then go to the Line menu and click Copy Record (or press CTRL+E).

You can save your sort options and selection criteria for this report with or without printing. After making your selections, click the Save button on the toolbar or click Save in the File menu. Enter an alphanumeric identifying code and a short description to help you recognize the report parameters. Later, you can use 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 you run the reports through Process Manager.