Fixed Assets Custom Query Fixed Assets Custom Query is designed to provide an

Fixed assets custom query fixed assets custom query

This preview shows page 26 - 28 out of 38 pages.

Fixed Assets Custom Query Fixed Assets Custom Query is designed to provide an easy, intuitive method to select data elements to include in an extract, enter various search criteria, extract the data in a format that is compatible with Microsoft EXCEL, and download the extract to your PC. Users of this function will need to perform three steps prior to generating a data extract. Selecting Fixed Assets Custom Query Criteria: 1. From the page, "Please select the columns you want to appear in the spreadsheet" the user selects the data elements to include in the extract for presentation. The choice " DEFAULT COLUMNS " will already be highlighted. Default columns are those data element names preceded by an asterisk. Additional or different data elements may be selected. To select data elements in addition to the defaults, while holding the CTRL key on the keypad down, point to a data element name with the mouse pointer and click the left mouse button. This will highlight the selected field and leave " DEFAULT COLUMNS " selected. Additional data elements may be selected by continuing this same process. To select data elements other than all of the " DEFAULT COLUMNS ", point to a data element name with the mouse pointer and click the left mouse button. This will highlight the selected Last Updated: 11/02/2006 Page 26 of 38
Image of page 26
Financial Data Warehouse Training Guide data element and will de-select the " DEFAULT COLUMNS " option. To select additional data elements, while holding the CTRL key on the keypad down, point to a data element name with the mouse pointer and click the left mouse button. This will highlight the selected field and leave all previously selected fields highlighted. 2. From the page, "Please select the columns you want in the selection criteria" the user selects those data elements that are to be used to limit those data records selected for the extract. At least one selection must be made from the list. To select data elements, while holding the CTRL key on the keypad down, point to a data element name with the mouse pointer and click the left mouse button. This will highlight the selected field. Additional data elements may be selected by continuing this same process. 3. From the page, " Selection Criteria for the . . . " the user will enter in data entry fields or select from a list of values the criteria used in the extract to limit the records selected. An option is available that allows the user to search all fixed assets with no responsible person or department assigned. Even if a data element has been selected in the prior step, an entry does not have to be made for that item on this page. If a data entry field is left blank, the field will not be used in the record selection logic extract. If the "ALL" option is left highlighted in a list of values box, the extract will select records regardless of the value of the specific data element for a record.
Image of page 27
Image of page 28

You've reached the end of your free preview.

Want to read all 38 pages?

  • Spring '18
  • Dr. Moez
  • Fiscal Year, Purchase order

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture