Adjust grid columns and sort records

Adjust grid columns and sort records

1. Click the Form drop-down arrow.
2. Click the Items list item. The Items (Filter in Place) form opens.
3. Click the Filter in Place icon.
4. Click the View drop-down arrow.
5. Click the Hide/Show 2nd Splitter Pane list item. The form is now in Grid view.
6. Click and hold the left mouse button on the U/M column header.
7. Drag the column to the left and position it after the Description column.
8. Position the mouse cursor over the right border of the Description column heading until the 
cursor changes to a double-sided arrow.
9. Click and hold the left mouse button on the Description column.
10. Drag the column to the left to make it narrower.
11. Double-click the Description column border. This will resize the column to its contents.
12. Double-click the U/M column border.
13. Double-click the Buyer column border.
14. Right-click anywhere on the column header. A drop-down list displays.
15. Click the Edit Grid Columns… list item. The Edit Grid Column Visibility and Order dialog box 
opens. 
16. Click to clear the Visible check box for the Revision caption.
17. Click to clear the Visible check box for the Revision Track caption.
18. Click to clear the Visible check box for the ECN caption.
19. Click the OK button. The Revision, Revision Track and ECN grid columns no longer display.
20. Double-click the Description column header. The data should now be sorted alphabetically in 
ascending order by the description.
21. Double-click the Description column header. The data should now be sorted alphabetically in 
descending order by the description.
22. Click the Close (X) button on the Items form. A dialog box opens with the message, “You have 
made grid-attribute changes to form Items. Do you want to save your changes for the next time 
you login?”
This message will display when you have Basic editing permissions.
23. Click the No button. 
You do not want to save changes that may affect other courses using this form.
24. Click the Close (X) button on the Items form

    • Related Articles

    • Add and save records

      Part 1: Recall a previously used form and add a new record 1. Click the Form drop-down arrow on the Menu bar. 2. Click the Items list item. This will be found in the recent forms list below Sign Out. The Items (Filter in Place) form opens. 3. Click ...

    • Create, post, and adjust a voucher

      Part 1: Create a voucher 1. Click the Open icon. 2. Type a/p v in the Filter field. 3. Click the web.APVouchersandAdjustments list item. 4. Click the OK button. The A/P Vouchers and Adjustments form opens. 5. Click the New icon. 6. Type [your ...

    • Modify payroll records after processing

      1. Open the Payroll Details form. 2. Type 3 in the Employee field. 3. Type 100 in the Payroll Id field. 4. Click the Status drop-down arrow. 5. Click the Exported list item. 6. Click Filter In Place. 7. Click the Reopen Payroll icon on the Menu bar. ...

    • Using Filter in Place

      1. Click the Form drop-down arrow. 2. Click the Items list item. This will be found in the recent forms list below Sign Out. The Items (Filter in Place) form opens. 3. Click the Source drop-down arrow. 4. Click the Purchased list item. 5. Click the ...

    • Use search operators and special values

      1. Click the Open icon. 2. Type purchase order lines in the Filter field. 3. Click the Purchase Order Lines list item. 4. Click the OK button. The Purchase Order Lines (Filter in Place) form opens. 5. Type *cycle* in the Name field. 6. Click the ...