• Anyone using Time Track for Job Costing, but exporting the time track entries for outside payroll service to process payroll

    Anyone using Time Track for Job Costing, but exporting the time track entries for outside payroll service to process payroll?
  • Visual Integrator job to import employee rate changes.

    I have a CSV file with new employee pay rates for a couple hundred hourly employees. Is it possible/advisable to import the new rates with a visual integrator job, and have the change appear on the "Pay Rate Change Report". Thanks!
  • Visual Integrator adding an extra delimeter

    I'm working on some VI export jobs in Sage 100 v2019. I'm noticing that when I run the jobs, v2019 is adding an extra delimiter to the end of each row. v2017 doesn't do this. Is there a way to prevent this?
  • Visual integrator and date fields

    I am converting some payroll export jobs from v2017 to v2019. In v2017, fields such as PR.PER_CHK are shown in VI as type DATE. In v2019, the replacement field PR_PayrollHistoryHeader.CheckDate is of type STRING. My converted job fails to export data…
  • Issue importing time using VI into Timecard

    Currently using Sage 100 Advanced 2017 Ver 5.40.3.0. When I run the Visual Integrator it will show that the records came across with no errors. If I look at one of the records in the log it will show the correct Punch In time and Punch Out time there…
  • Invoice with multiple lineitems with different dates in AP import (via VI module)

    Questions: 1) Please suggest how can we create AP invoice with different dates for details within and success import their via VI module? 2) Please suggest how can we add lines (details) to existing AP invoice via VI module? Description: Our…
  • Check status of VI Job (Sage MAS 100)

    Questions: 1. How to check status completion of VI Job? (see picture 1) 1. What Sage MAS 100 table and field should we use to determine VI Job status using ODBC? 2. Is there other way to run VI Job without using PVXWIN32.EXE? The problem description…
  • Payroll Visual Integrator Job

    I have a job that imports hours and earnings codes from our time clock system. In general it works fine. The only time I have a problem is when employees work a holiday and get double time. For some reason, deduction code 4P (401k percentage) does not…