Page 63 - Unanet AE: Administering the System

9. Use the information in the table to create the outputs:
Table Column Show Column Order
Clients FirmCode Select 2
Firms FirmName Select 3

Clients IsActive Select 1
10. Select the Save button.
11. Select Active Clients by Name in the Client Queries list.
12. Select = from the Operator drop-down list in the Parameters section.
13. Select the Value 1 check box in the Parameters section.
14. Select the Run button.

Part 2: Create a Vendor Query
1. Navigate to Accounts Payable > Vendor Queries. The Vendor Queries applet
opens.
2. Select the New button. The Query Designer window opens.
3. Type Vendor Pay-to Address in the Name field.
4. Select Personal in the Type field.
5. Select the Input tab.
6. Select the Parameter check box for Vendors Is Active.
7. Select the Output tab.
8. Use the information in the table to create the outputs:

Table Column Show Column Order
Vendors FirmCode Select 1
Firms FirmName Select 2
Pay-To Addresses Street1 Select 3
Pay-To Addresses Street2 Select 4
Pay-To Addresses City Select 5
Pay-To Addresses State Select 6
Pay-To Addresses Zip Select 7
9. Select the Save button.
10. Select Vendor Pay-to Address in the Vendor 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.

Part 3: Create a Project Query
1. Navigate to Project Management > Project Queries. The Project Queries
applet opens.
2. Select the New button. The Query Designer window opens.
3. Type Active Project by Client in the Name field.
4. Select Personal from the Type drop-down list.

Lesson 7: Creating Reports ©2022 Unanet. All rights reserved. 63