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!

  • Job Cost Detail History tied to General Ledger Detail

    I have a client who is migrating from Sage 100 4.5 to Sage Intacct. I'm trying to take Job Cost lines posted to the GL and break out (tag) the summary lines by job number and cost code (dimensions). But when I look at the JC tables such as JC Transaction…

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

  • PPP Loan Forgiveness Application Data

    Sage 100 - P/R 2.20 After reviewing the Loan Forgiveness Application and Instructions, I am finding I need data which should be in P/R but am unable to locate. It appears all of the Reports are for quarter summaries and I need to access data from…

  • Employee Master File

    We just updated our Sage 100 to the 2019 Advanced version. We also use Sage payroll and downloaded the latest version. In previous versions, there was an ODBC database file named PR1_EmployeeMaster. I don't see that file is available in the 2019 version…

  • Rounding OT for salaried person during Import

    Having an issue when importing for a person with a salary that goes out to two decimals and then their OT is also 2 decimals. System apparently rounds differently during import than manual entry, but does not tell the client it's out of balance until…

  • Import conversions 2018

    Have upgraded a client who uses a spreadsheet to import payroll. They have about 10 columns, so have about 10 linked payroll imports. In the prior version, the Deductions were Yes'd on the last import (Regular pay), because it assumed everyone would have…

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

  • Importing hours from SAGE 100 into ADP Workforce Now

    FormerMember
    FormerMember
    Recently began working with a client that is using Sage 100 (ERP version) and looking for a best practice to import their ADP hours from Workforce Now into Sage. ADP has provided a template but we need ideas on the best way to bring that in via .CSV

  • ACA covered individual count

    Imported employee information for the 1095 B/C, using the format in the Sage-provided spreadsheet. Entry number starts with "00001" for each individual. Aatrix increments this count by adding 1, which creates errors. Has anyone else experienced this…

*Community Hub is the new name for Sage City