x Want to participate? Join the group to interact

  • Sage 100: Dropping in Employee Maintenance Data using a CSV or Excel file

    Anyone have any experience with using an excel or csv data base spreadsheet to import employee maintenance info into Sage 100? Looking to save some time for a large client. Name, Address, SSN.. Thanks!

  • 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 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…

  • Excel Query for Payroll Information and History

    Hello. We are attempting to get two years of pay history out of Sage 100 as well as other employee information. I have attempted to use an Excel Query, but I really have no idea what I am doing. Where do I go to find an expert that knows how to retrieve…

*Community Hub is the new name for Sage City