The Work programintegration with InForum Gold Payroll module allows you to import timesheet activity from your work orders; thus, determining employee payroll and tracking labor charges.
There are two major components of this integration:
Employee # Lookup - The employee # lookup is responsible for importing an employee's time (as recorded in a work order) into the InForum Gold Payroll module. For this integration to work, all employees must be entered through Eden and marked as Lucity resources. Then, the Lucity Employee table is auto-populated with data from the InForum Gold Employee table. This is done is one of two ways:
A scheduled DTS Job is created to auto update the Lucity Employee table with data from the InForum Gold Employee table on a nightly basis. This allows the systems to stay in synch automatically with no user intervention.
A manual update procedure is created within the InForum Gold Employee table. This manual process consists of a button and menu option that updates the Lucity Employee table when initiated. This allows you to update the system on an as-needed basis.
Timesheet Activity Interface - The timesheet activity interface will import the labor portion of the work order activity from Lucity into the InForum Gold Payroll module. By importing this data, the Payroll module is able to process employee activity and the subsequent labor distribution to the InForum Gold General Ledger and project charges to the InForum Gold Project Accounting module for the work order. The interface will be initiated by a new menu option and button found on the InForum Gold Activity Entry and Activity Quick Entry Forms.
Each entry that is made into the Work Order module contains an employee ID, hour code, number of hours, resource end date, InForum Gold GL Account number, and possibly an InForum Gold Project Account number. This data will be imported into the InForum Gold Payroll module; thus, creating valid timesheet activity records that can be used to run your payroll.
When the process is initiated, the import pulls all data into the selected pay period of the Activity Entry or Activity Quick Entry form. The import will only pull rows that have a resource end date < or = to the currently selected pay period date.
Once an employee resource record in a work order is imported, the Processed by Financials checkbox (in the resource record) is auto-marked (circled in red below).
Then if a record is changed within the Work Orders module after the import, you will receive the following prompt:
Note: The Eden Cost Type needs to be set up with valid time cost codes in the Time Cost module. Users need to put the Eden Cost code value in the Financial Hour Type field in that module. Eden uses the WKUEMPTIME.TC_HOURTY for the hourtype.
