Open the UD User Defined Lookups form in Vista and copy the existing EMCC lookup. Modify the new lookup as shown below.
- EMCC with (nolock)
- EMCC.EMGroup = 1 and 1 = CASE WHEN ISNULL(?,-1) = -1 Then 1 WHEN EMWI.WorkOrder = ? and EMWI.WOItem = ? Then 1 Else 0 END
- Join Clause
- LEFT OUTER JOIN EMWI on EMCC.EMGroup = EMWI.EMGroup and EMCC.CostCode = EMWI.CostCode
- Group by Clause
- EMCC.CostCode, EMCC.Description
Configure the lookup in Viewpoint by following the steps below.
- Open PR Timecard Entry and click the Field properties on Cost Code
- Click the Lookups tab in the field properties window and add the custom lookup created above
- Enter in the parameters as shown in the screen shot below (31,31,32)
- Change the load Sequence to 0 and ensure that it is the only 0