The JC Field Ticket field can be added to standard or grid
timecards.
Time entries associated with a field ticket can be
shown on the Field Ticket PDF report. To configure this feature, first create a custom
lookup for the Field Ticket field in Vista. Then add the Field Ticket field to standard
or grid timecards, making it dependent on the job.
In Vista, select User Database > Programs > UD User Defined
Lookups.
On the Info tab, enter
udFieldTicket.
Give the lookup a Title. For example,
ud PR Field
Ticket.
In FromClause, enter JCJM with
(nolock).
For the Where Clause, enter the following:
JCFT.Status = 'O' AND JCJM.JCCo=? AND JCJM.Job=?
For the Join
Clause, enter the following:
INNER JOIN JCFT with (nolock) ON
JCFT.JCCo = JCJM.JCCo AND JCFT.Contract = JCJM.Contract
In Order by
column, enter 1.
Select the Details tab.
Add a
JCFT.FieldTicket column:
ColumnName =
JCFT.FieldTicket
ColumnHeading
= Field Ticket
InputType =
1-Numeric
InputLength =
0
Add a
JCFT.Description column:
ColumnName =
JCFT.Description
ColumnHeading
= Ticket Description
InputType =
0-String
InputLength =
60
Save your changes.
In Vista, add the custom lookup to the Field Ticket field in
PR Timecard
Entry.
Select Payroll > Programs > PR Timecard Entry.
Select an existing batch or open a new one
a batch.
On the Info tab, select the
Field
Ticket field, and press F3 to open field
properties.
In the Field Seq# drop-down,
select 70 - Field
Ticket.
On the Lookups tab, add the
udFieldTicket field, and set it as Active.
Save your changes.
In the employee portal, make the Field
Ticket field visible on timecards:
For grid timecards, add the Field Ticket field to
the Row Group
in Grid Timecard Layouts.
For standard timecards, select
Employee Tools > Timecard Settings. Locate the Field Ticket field in the list, and set the Visibility to
Editable.
In the employee portal, make the Field
Ticket field dependent on the job:
Select either Employee Tools > Timecard Settings or Employee Tools > Grid Timecard Settings.
Locate the Job field in the
list, and select the Advanced button for that field.
In the Job Advanced Settings
pop-up, add FieldTicket to the list of Dependent Fields. If
you already have dependent fields listed, be sure to separate multiple
entries with a comma and no spaces.
For example:
Phase,Cert,EquipPhase,FieldTicket.
When users enter timecard lines, field tickets linked
to the selected job display in the Field
Ticket drop-down.