Skip to main content

LCP Tracker Integration

A
Written by Andy Temple
Updated over 3 weeks ago

Overview

Many Coins ERP+ clients participate as contractors in government-funded work. As a contractor on these projects, you may be required to submit Certified Payroll Reports to support the payment of wages and benefits earned by employees performing work on these projects. Federal government agencies use the Certified WH-347 Form. However, non-Federal government agencies may have their own version of the Federal Form WH-347 and its accompanying Statement of Compliance, and they may use LCP Tracker software for it.

Coins ERP+ Payroll for the US region helps to facilitate the integration of LCP Tracker software with the Coins ERP+ Certified WH-347 LCP Export function.

It is highly recommended that you contact Coins ERP+ to get assistance from a Consultant when you are ready to implement this interface with LCP Tracker.

Employee Maintenance

Two fields, State Electrician ID and State Apprentice ID Code, are available in the Work Information area of Payroll > Frequency > Employee Maintenance, as shown in Employee Maintenance Fields. They are not required and can only be used by the LCP Export.

Employee Maintenance Fields

Job Summary

The External Project Number field is found on the Job Summary screen in Payroll > Global Setup > US Specifics > Jobs, as shown in Job Summary Field. It can be used to record the Project Number that the Job is associated with in the LCP Export.

Job Summary Field

Calculations

The information for the fields and screens discussed below is generated based on information in the LCP Tracker.

Job Calculations

A LCP Sort Group field is found on the Job Calculations tab in Payroll > Global Setup > US Specifics > Jobs, as shown in Job Calculations Tab. The options listed for this field are generated based on information in the LCP Tracker.

Also, a Payment in Lieu of Fringes field is found on the Main tab of the Job Calculation Summary screen, as shown in Job Calculation Summary Screen. It can be used to indicate the preference for cash in lieu of fringes.

Job Calculations Tab

Job Calculation Summary Screen

Pay Calculations

A LCP Sort Group field is found on the Pay Calculations screen in Payroll > Global Setup > US Specifics, as shown in Pay Calculations Screen. The options listed for this field are generated based on information in the LCP Tracker.

Pay Calculations Screen

Union Calculations

A LCP Sort Group field is found on the Union Summary screen in Payroll > Global Setup > Unions, as shown in Union Summary Screen. The options listed for this field are generated based on information in the LCP Tracker.

Union Summary Screen

Prevailing Wage Calculations

A LCP Sort Group field is found on the Prevailing Wage Calculations screen in Payroll > Company Setup > Prevailing Wage Schedules, as shown in Prevailing Wage Calculations Screen. The options listed for this field are generated based on information in the LCP Tracker.

Also, a Payment in Lieu of Fringes field is found on the Prevailing Wage Calculations Summary screen, as shown in Prevailing Wage Calculations Screen. It can be used to indicate the preference for cash in lieu of fringes.

Prevailing Wage Calculations Screen

Prevailing Wage Calculations Summary Screen

Certified WH-347 LCP Export

The Certified WH-347 LCP Export function can be found in Payroll > Company Reports > Certified WH-347 Report. This function allows you to export a file from Coins ERP+ and import it into LCP Tracker.

Selection Screen

The selection screen that appears when you select the Certified WH-347 LCP Export function from the Payroll menu is shown in Selection Screen. This function allows you to export a file from Coins ERP+ and import it into LCP Tracker.

Selection Screen

Export Process

The process for exporting a file from Coins ERP+ and importing it into LCP Tracker is outlined below.

  1. On the LCP Export selection screen (Selection Screen above), enter the information you would like to export into a CSV file. Note that the Path and Filename are automatically filled in for you on this screen, as shown in Path and Filename.

Path and Filename

  1. Click Next at the bottom of the screen.

  2. Go to System > My Files and search for the Filename that was automatically generated for the file. The screen in My Files List shows an example of Filename exp20171221.csv (see Path and Filename above) as it appears on the My Files list.

My Files List

  1. Click the CSV file to download it, then open it in Microsoft Excel.

  2. In order to preserve the Employee Number and Social Security Number (SSN), the following formatting steps must be performed in Excel prior to saving the CSV file as an .xlsx file.

    1. In the Social Security field, right click on the column and select Format Cells. Select Social Security Number in the format options, as shown in SSN Formatting - Screen 1.

    2. Click OK.

SSN Formatting - Screen 1

    1. The format should change the SSN to use the correct formatting, as shown in SSN Formatting - Screen 2.

SSN Formatting - Screen 2

    1. In the Employee ID field, right click on the column and select Format Cells. Enter a custom number format, as shown in Employee ID Formatting - Screen 1.

Employee ID Formatting - Screen 1

    1. Click OK.

    2. The Employee Number should now display using the entered formatting and no longer remove leading zeros, as shown in Employee ID Formatting - Screen 2.

Employee ID Formatting - Screen 2

  1. In Excel, click File > Save As and select Excel Workbook (*.xlsx), as shown in Excel Workbook (*.xlsx) File with Format Changes. The *.xlsx spreadsheet that is created should retain all formatting entered and preserve the data.

Excel Workbook (*.xlsx) File with Format Changes

  1. The *.xlsx file that has been created can be imported into LCP Tracker.

Did this answer your question?