Cost Codes

Keystyle Support Team -

Cost Codes

Open the UD User Defined Lookups form in Vista and copy the existing EMCC lookup.  Modify the new lookup as shown below.

  • From
    • EMCC with (nolock)
  • Where
    • 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.

  1. Open PR Timecard Entry and click the Field properties on Cost Code
  2. Click the Lookups tab in the field properties window and add the custom lookup created above
  3. Enter in the parameters as shown in the screen shot below (31,31,32)
  4. Change the load Sequence to 0 and ensure that it is the only 0


Have more questions? Submit a request


Please sign in to leave a comment.
Powered by Zendesk