Costpoint Online Help

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

Contents of the Print Autocreation Transactions Edit Report Screen

Use the fields and options to configure the Print Autocreation Transactions Edit Report 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

Asset Accounts

Use the following fields to print a report for one asset account, a range of asset accounts, or all asset accounts. The asset account is required in the G/L Book Info tab of the Manage Asset Master Information screen and on the Manage Asset Account Information screen for all property records, and denotes the "ownership" account, such as company-owned balance sheet, project, and so on. Asset account and organization "ownership" data are always required; project and reference number "ownership" data is usually optional.

Field Description
Option

Select a range option from the drop-down list for the asset accounts you want to include in the report. Range options are:

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

Enter, or click to select, the beginning asset account in this field. Because this is a standard lookup to the ACCT (Account) table, you may find that you have selected an account from the lookup for which autocreation transactions do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve from the AUTOCR_ASSET_EDIT (Edit Autocreation Transactions) 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 asset account in this field. Because this is a standard lookup to the ACCT table, you may find that you have selected an account from the lookup for which autocreation transactions do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve from the AUTOCR_ASSET_EDIT table may not be selected.

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

Asset Organizations

Use the following fields to print a report for one asset organization, a range of asset organizations, or all asset organizations. The asset organization is a required field in the G/L Book Info tab of the Manage Asset Master Information screen and on the Manage Asset Account Information screen for all property records, and denotes the "ownership" organization, such as company-owned balance sheet, project, and so on.) Asset account and organization "ownership" data are always required; project and reference number "ownership" data is usually optional.

Field Description
Option

Select the range option from the drop-down list for the asset organizations you want to include in the report. The default option for this field is All. Range options are:

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

Enter, or click to select, the beginning asset organization in this field. Because this is a standard lookup to the ORG_ACCT (Organization Account) table, you may find that you have selected an organization from the lookup for which autocreation transactions do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve from the AUTOCR_ASSET_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 asset organization in this field. Because this is a standard lookup to the ORG_ACCT table, you may find that you have selected an organization from the lookup for which autocreation transactions do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve from the AUTOCR_ASSET_EDIT table may not be selected.

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

Asset Projects

Use the following fields to print a report for one asset project, a range of asset projects, or all asset projects. The asset account and organization data are required in the G/L Book Info tab of the Manage Asset Master Information screen and on the Manage Asset Account Information screen for all property records, and denote "ownership," such as company-owned balance sheet, project, and so on.) Asset account and organization "ownership" data are always required; project and reference number "ownership" data is usually optional.

Field Description
Option

Select the range option from the drop-down list for the asset projects you want to include in the report. Range options are:

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

Enter, or click to select, the beginning asset project in this field. Because this is a standard lookup to the PROJ (Project) table, you may find that you have selected a project from the lookup for which autocreation transactions do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve from the AUTOCR_ASSET_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 asset project in this field. Because this is a standard lookup to the PROJ table, you may find that you have selected a project from the lookup for which autocreation transactions do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve from the AUTOCR_ASSET_EDIT table may not be selected.

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

Autocreation Dates

Use the following fields to print a report for one autocreation date, a range of autocreation dates, or all autocreation dates. The Autocreation Date/Time column on the Manage Autocreation Transactions screen automatically displays the date the row was created; it cannot be edited.

Field Description
Option

Select the range option from the drop-down list to specify the autocreation dates you want to include in the report. Range options are:

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

    The system does not validate the dates entered in these fields. Be careful with your entry, because you may find that you have entered selection criteria for which data does not exist in the AUTOCR_ASSET_EDIT table or does not meet your other selection criteria.

Start

Enter, or click to select, the beginning autocreation date in this field.

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

End

Enter, or click to select, the ending autocreation date in this field.

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

Asset/Item Number

In the following fields, you can select the asset/item numbers that you want to include in the report. If you enter a specific asset number, you must also enter a corresponding item number before you can run the report.

You will need to choose from either the "temporary" or the "user" asset/item numbers displayed on the Manage Autocreation Transactions screen for this report.

Note: The system automatically assigns a "temporary" asset number and item number for each row in this table based on the numbering preference you previously selected. You can override the system-assigned numbers with "user" designated asset/item numbers of your choice (provided they are unique).

Asset/item numbers will print on the report in overall numerical order, regardless of whether they were assigned as "Temporary" or "User" Asset/Item numbers on the Manage Autocreation Transactions screen.

Lookup at these fields displays data from the Temporary Asset No, Temporary Item No, User Asset No, and User Item No fields on the Manage Autocreation Transactions screen. (This is not a standard lookup to the ASSET table.)

Field Description
Option

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

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

Enter, or click to select, the beginning asset/item number for the range.

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

End

Enter, or click to select, the ending asset/item number for the range.

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

Options

Print

Use the options in this group box to select whether you want to print a summary or a detail report. The Summary option is the default.

Field Description
Summary

Select this option to print the summary report, which prints data from selected columns on the Manage Autocreation Transactions screen in a list format. The asset account, organization, project, autocreation status, timing source, asset/item number, tag number, short description, template/revision number, and total cost are included in the report. In addition, cost subtotals print by account/ organization/project along with a grand total.

Detail

Select this option to print the detail report, which prints data from all columns on the Manage Autocreation Transactions screen on a single page. Because there are so many columns on the screen, this report provides an easy way to review all the data for a single row.

Select Timing Source

Use the options in this group box to select the timing code of the transactions you want to include in the report. You must select at least one check box. The Receipt check box is the default.

Note: If you select only the Receipt check box and you are not licensed for Costpoint Purchasing/Receiving, there can be no match based on the selection criteria and no records will be found.
Field Description
Receipt

Select this check box to include records with Receipts as timing source. This check box is the default.

If you activate only the Receipt check box and you are not licensed for Costpoint Purchasing/Receiving, there can be no match based on the selection criteria and no records will be found.

Posting

Select this check box to include records with Posting as timing source.

User

Select this check box to include records with User as timing source. The system automatically assigns a User code to a new row on the Manage Autocreation Transactions screen if you use the Duplicate Row function to copy an existing row, regardless of the timing source of the row from which the data was copied.

Include Autocreation Status

Use this group box to select the autocreation status of the transactions you want to include in the report. You can select from two check boxes that allow you to choose Selected transactions and/or On Hold transactions. You must select at least one check box. The Selected Transactions check box is the default.

Field Description
Selected Transactions

Select this check box to include records with Selected as autocreation status. This check box is the default.

Transactions On Hold

Select this check box to include records with an On Hold autocreation status.

Sort By

Use the options in this group box to select how the report data is organized. Note that the report is always printed in the same format, regardless of the sort option you select. The sort option determines how the data is ordered within the format. If you select the Summary option in the Print group box, data will be further sorted by autocreation status, timing source, and asset/item number, respectively.

Field Description
1st Sort

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

  • Asset Account — This option is the default.
  • Asset Organization — This sorts the report by asset organization.
  • Asset Project — This sorts the project by asset project.
  • Autocreation Status — This sorts the report by autocreation status.
  • Autocreation Timing Source — This sorts the report by autocreation timing source.
  • Autocreation Date — This sorts the report by autocreation date.
  • Asset/Item Number — This sorts the report by asset/item number.
Note: This sort option prints all data sorted first by user asset/item number and then sorted by temporary asset/item number order. It does not merge temporary asset/item numbers with user asset/item numbers in the sorted list.
Page Break

Select this check box if you want a page break inserted each time the selected sort parameter changes.

Note: You can save your sort options and selection criteria for this report with or without printing. Select the Save button on the toolbar or Save in the File menu. Enter an alphanumeric identifying code and a short description to help you recognize the report parameters. Later, you can run Query from this screen to access the print parameters you created and run the same report without entering the screen information again. Stored report parameters are especially useful if you plan to run reports using the Process Manager.

If you want to keep your selection parameters but want to run a slightly different report, you can use Copy Record to copy the parameters and make minor changes to them without changing the saved parameters. Click Copy Record in the Line menu or press (CTRL+E).