Page 64 - Unanet AE: Administering the System
P. 64

5.  Select the Input tab.
                   6.  Select the Parameter check box for Project Facts ChargeTypename.
                   7.  Select = from the Filter Operator drop-down list for Project Facts
                       ChargeTypename.
                   8.  Type 1 in the Filter 1 field for Project Facts ChargeTypename.
                   9.  Select the Output tab.
                   10. Use the information in the table to create the outputs:
                        Table            Column           Show      Column Order  Sort Order  Ascending
                        Firms            FirmName         Select    3                1            Select
                        Projects         ProjectPath      Select    1

                        Projects         ProjectName      Select    2
                   11. Select the Save button.
                   12. Select Active Project by Client in the Project Queries list.
                   13. Select = from the Operator drop-down list in the Parameters section for the
                       ChargeTypename option.
                   14. Type Billable in the Value 1 field.
                   15. Select the Run button.

               Part 4: Create an Employee Query
                   1.  Navigate to Human Resources > Employee Queries. The Employee Queries
                       applet opens.
                   2.  Select the New button. The Query Designer window opens.
                   3.  Type Employee Time and Expense Approvers in the Name field.
                   4.  Select Personal in the Type field.
                   5.  Select the Input tab.
                   6.  Select the Parameters check box for Employees IsActive.
                   7.  Select the Output tab.
                   8.  Use the information in the table to create the outputs:
                        Table             Column                           Show             Column Order

                        Employees         EmpCode                          Select           1
                        Employees         Empname                          Select           2
                        Employees         TimeExpApproverEmpname           Select           3
                        Employees         AltTimeExpApproverEmpname  Select                 4
                   9.  Select the Save button.
                   10. Select Employee Time and Expense Approvers in the Employee Queries list.
                   11. Select = from the Operator drop-down list in the Parameters section.
                   12. Select the Value 1 check box in the Parameters section.
                   13. Select the Run button.
                   14. Close the Client Queries applet.







               Lesson 7: Creating Reports                                   ©2022 Unanet. All rights reserved.  64
   59   60   61   62   63   64   65   66   67   68   69