Enable Auto Select Equipment for EM Work Order When Equipment is Shown in Portal

If you are showing Equipment on a Mechanic Work Order line, the following will make the Equipment field populate automatically after WO item Selection in the portal.

To complete this configuration, you will need access to User Database and PR Timecard Entry in Vista, and be a System Admin in the portal.
  1. In Vista, open the UD User Defined Lookups form and copy the existing EMEM lookup. Modify the new lookup as shown below:
    • From
      • EMEM with (nolock)
    • Where
      • EMEM.EMCo = ISNULL(?,1) and 1 = case when ISNULL(?,-1) = -1 then 1 when EMWI.WorkOrder = ? and EMWI.WOItem = ? then 1 Else 0 END
    • Join
      • LEFT OUTER JOIN EMWI on EMEM.EMCo = EMWI.EMCo and EMEM.Equipment=EMWI.Equipment
    • Group By
      • EMEM.EMCo, EMEM.Equipment, EMEM.Description
  2. On the Details tab, add the following:
    • Sequence: 0, ColumnName: 'EMEM.Equipment', ColumnHeading: 'Equipment', InputType: 0-String, InputLength: 10
    • Sequence: 1, ColumnName: 'EMEM.Description', ColumnHeading: 'Equipment Description', InputType: 0-String, InputLength: 50
  3. Configure the lookup in Vista by following the steps below:
    1. Open PR Timecard Entry and select the Field Properties on 'Equipment' (sequence 34).
    2. Select the Lookups tab in the Field Properties window and add the custom lookup created above.
    3. Enter the Parameters with a comma between each entry, as shown in the sample below (29,31,31,32).
    4. Change the Load Sequence # to 0. Ensure that it is the only 0.
    5. Select Apply.
  4. In the portal, go to Employee Tools > Grid Timecard Settings (for Standard Timecard, go to Employee Tools > Timecard Settings). Select the appropriate Company and PR Group.
  5. On the Equipment line, select Advanced, then select Auto Select 1st.
    Make sure the appropriate dependencies are entered in Advanced Settings under Dependent Fields:
    • For EMCo, WO, and WOItem, add Equipment as a dependency.
    • For Equipment and WOItem, add CostCode as a dependency.
    Note: For Auto Select fields, do not use a large dataset. (Large dataset is an option in the Visibility field on the Grid Timecard Settings page.)
  6. Go to Admin > Portal Settings and select Refresh Synonyms.