General Inquiries

LCP Tracker Upload from Sage 100

  • 1.  LCP Tracker Upload from Sage 100

    Posted 12-10-2018 20:21
    I know LCP Tracker has the ability to accept upload files via CSV Format from some software packages.  However, we use Sage 100 Contractor which is not one of them from my search.  One company I experienced has a file generated from a 3rd party payroll system.
    Has anyone gone through the process of developing the export from Sage 100 Contractor and conversion to CSV or acceptable form to upload to LCP Tracker?

    ------------------------------
    Kenneth MacGregor CCIFP, CMA
    Chief Financial Officer
    Gilmore Construction Corporation
    Denver CO
    (720) 224-2500
    KennethKennethKennethKenneth
    ------------------------------


  • 2.  RE: LCP Tracker Upload from Sage 100

    Posted 12-10-2018 21:50
    Kenneth,

    You could create a Excel workbook that pulls the data from Sage 100 and has a macro to export to CSV. Here is a link to an example worksheet that pulls 401k data from a database and exports it to CSV with only a couple of clicks. The file lets you test the export to CSV, but it contains sample data stored in the file so it isn't linked to a database. The same could be done for your certified payroll data. Joining multiple tables will be the tough part of creating the export. If you are on the SQL version, creating a view in SQL will make the work in excel easier. Let me know if you need assistance with this.

    Best,

    Kevin Halme
    Constructive Tech Solutions
    Omaha, NE
    www.consttech.solutions


  • 3.  RE: LCP Tracker Upload from Sage 100

    Posted 12-11-2018 01:00
    If you call LCP directly they can create a "custom import". I want to say it was $500 and you send them a report with the PW info on it and they create the OCR template on their end to read your submissions.

    ------------------------------
    Jeffrey Dorner CCIFP
    Controller
    Commercial Fire Protection
    Newport Beach CA
    (714) 686-4267
    ------------------------------