Browse By Tags

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

  • Import Foundation Payroll to Sage 300 CRE

    How do I import payroll data from an outside 3rd party (Foundation) into Sage 300 CRE?

  • Payroll Sage 100 Contractor

    In need of a better system to do our payroll. We are currently using About Time AKA WorkMax. They are SLOW and mess up all the time. My filed guys hate this system and complain every day. There is an issue every week. Most of the time it kicks them out…

  • Sage 300 CRE- I want to be able to import a large payroll journal entry

    Are there instructions some where that will take you step by step? We have been entering our payroll manually in a journal entry. Is there a template that we can use to upload the payroll journal entry?

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

  • Is there an Import file template and instructions to import hours from 3rd party time keeping system?

    We are implementing a new time clock/ time keeping system that has the ability to create an import file of employee hours. I am looking for the required template that this file needs to match and instructions covering the creation of the needed file and…

  • Timesheet Import using CSV template

    Does anyone have any instructions on how to use this Timesheet import feature? I have been playing with the template but I can not figure out how it works. The instructions show the basic formatting but how do you enter regular and over time hours if…

  • Previous Year's Employee Hours Missing

    Hello, I've been working on a custom export where I need a list of employees that have worked over 500 hours for 2019. While testing, I run the report in my current year company and everything is great. I go back to my 2019 company file to run the custom…

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

  • Payroll Import

    I currently use BenefitMall payroll processing which has a General Ledger import file feature which I use to import the payroll. Unfortunately, BenefitMall is exiting the payroll processing business. I have a new payroll processor which I am considering…

  • Can the un-required fields in an import be left blank?

    I am trying to get a csv file to import into the payroll using Sage 50 Accounting, and I was wondering if it will still work if I leave the un-required fields--such as, Employee First Name, Check Number, etc--blank and filled in the required fields? …

  • Example .csv format for a payroll file

    Hello everyone, I am having issues with Sage 50 giving me errors anytime I go to import in a .csv, payroll file. The errors are either line 1 or line 2 date errors. I know it has to be an issue with my file formatting, and so I was hoping someone might…

  • Importing General Journal Entries - Payroll

    We use a third party payroll system. I want to import the general journal report from that provider into Sage, but when I called to inquire about it, they said that you cannot create general journal entries to accounts that are linked. They suggest that…

  • Importing Time into Payroll from a Third Party

    Hi, I'm having issues with trying to import a time entries file into Payroll. I've been reading that the file has to be a .txt and that I need to make sure there are no headers and each column needs to be made exactly how our layout is. Is there an…

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

  • Payroll import time entry format

    I need to know what order the columns need to be in for import into Payroll. I haven't been able to find it in the in program help index, or by searching. I found a third party recource that gave me the first 9 (in order): Employee, Date, Job, Extra…

  • Import Payroll Journal from non-sage company

    We are currently using a non-sage affiliate to process our payroll. I was told by Sage that we would be able to import payroll data from their journal in .csv format into Sage so that we have the information we need to do account reconciliation and reporting…

  • Import timecard information into payroll

    Is there a fairly simple straightforward way of importing timecard information into payroll data entry without using Visual Integrator? Thanks!

  • Is there a problem with having multiple employees with the same SSN in Sage when only one of them is marked active?

    I'm asking this question as a correlation to this other post (titled: "Is there a way to change employee numbers in a VI job based on SSN?"). We're running into an issue where Sage no longer deletes employees marked as "Terminated" during year end processing…

*Community Hub is the new name for Sage City