• Payroll Archive

    I have completed the newest version of Sage 100 Contractor YE proceedures. I have a clean PR audit. Updated and done every item the instructions say. Yet when I try to Archive 2023 PR "Unable to remove payroll company database, the archive company has…
  • Payroll errors in previous year are messing up 2024 payroll YTD calculations

    The answer is yes! Let me explain, I followed the year-end guide. I ran the audit, I repaired the errors listed in the audit, I ran the audit again to check for errors. There was zip, zero, zilch errors reported. I proceeded to close 2023 payroll. Everything…
  • Import Foundation Payroll to Sage 300 CRE

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

    I'm getting the error that is attached when I run the Sage Payroll Archive for 2022. It seems there's a file already there, however when I checked I don't see it. Any thoughts? Thanks!
  • Sage 24.3 update question

    Hello, Mistakenly updated Sage 100 Contractor to the wrong update version without the payroll year closed. I rolled back the program on the computers which is fine. It now states the tax table for this year. Do I need to roll back on the server…
  • Possible to correct multiple sick / PTO records at once?

    We have at least a couple hundred payroll records where PTO (sick time) was used while we were running the broken version 24.2.103 of Sage. The process for fixing these, listed as the resolution to defect # 39917 is a manual process for each individual…
  • Adding the "Reprint Check Stub" Checkbox to Custom Payroll Stub

    I have created a custom paycheck stub and everything works great except I can't find the reprint check stub checkbox to add the to the report. I started with a copy of the system report and modified it, but this option seems to have disappeared and I…
  • 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…
  • Can you use Crystal Reports to change the value of fields in Sage 300 CRE...?

    If this is not possible what would the best way to accomplish this? I have the Certified Class description i want to assign to the Occupation field on the Master Employee Record, we would like them to match and currently they do not. Thanks V
  • Creating upload files for Arcoro...

    We are in the process of moving to Arcoro HR and I have been building imports for this. Two of the imports concern pre/post 2020 employee tax info, and some of the data required is Year, Additional Withholding, Filling Status for that year, Exempt or…
  • 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?
  • error, "SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM"

    In Database Admin, restoring a Client's backup, I am getting an error, "SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM" What is this? I write reports, and get client databases to work in. This is the first time…
  • How do I get information from imported HH2 hours?

    We set up SQL replication last week and it is working well. However I am having trouble finding where our HH2 imports actually end up in the SQL database. We import a HH2 payroll each week via the import tool in Payroll > Tools > Import Time... Where…
  • Any way to empty Sage 300 CRE log file?

    In log viewer it is possible to Archive & Delete but it is extremely slow, only being able to handle 200,000 records at a time and the archive only writes 10,000 per file. I don't want to archive, I just want to delete. I have tried ODBC connect and using…
  • 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…
  • PO archive and upgrade?

    Has anyone had experience with archiving the PO module? According to KB articles, moving POs and COs to history is the first step in improving performance in the PO module. Clean out all those old records. I have done this in a test environment and can…
  • Table and Field Naming mode - JDBC2Pervasive query

    I am using Dell Boomi software to retrieve data from our customers Sage Pervasive DB. In order to do that, Boomi needs class name and connection url. It uses java and jdbc to connect to db. Class name is: com.pervasive.jdbc.v2.Driver. URL is in…
  • Ts.ctl file in use during backup vs 17.1.8

    Here's a new problem after installing 17.1.8 update (not a problem with 17.1.7): Common Tasks - Tools - File Tools - Backup The "ts.ctl" file is in use when we try to use file tools to backup our data. The knowledgebase leads you to various methods…
  • Sage 300 Construction and Real Estate PRM tables Pervasive

    FormerMember
    FormerMember
    Hi, I am working with a client using Sage 300 version 9.5(?). When I open PCC I am unable to see the PRM tables. After some research I think that the reason the PRM tables (among others) do not show up is because the DDF files do not contain the schema…
  • Database Schema for Sage 300 CRE?

    FormerMember
    FormerMember
    Does anyone have any comprehensive form of databse schema or detailed data dictionary for Sage 300 CRE when trying to access using ODBC? I have been trying to find one for some time that details the table locations of data fields and have found Sage documentation…
  • 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…
  • Permissions on attachment folders changed with upgrade to version 20.2.35

    Yesterday, I decided to update to the latest version of Sage 100 Contractor (version 20.2.35.0) When I went to Upgrade the database I was denied permissions to access folders (yes, I was logged on as my system admin). After two unhelpful hours on the…
  • Earnings and Payroll Don't Match

    From 5-2-1 Employees, we have an employee whose Earnings show $875 more than their Payroll totals. (the two Buttons at the lower left) Report 5-1-9-31 (YTD Earnings) is $875 higher than Report 5-1-2-41 (Payroll Check Register Totals) How is this even…
  • Invoice Details Disappeared but Grid Total Remained in 11-2 Service Receivables module

    I have an order in 11-2 Service Receivables that originally had parts, quantities and price in the Invoice Details grid - that calculated up to a total that was emailed as a Quote to a Client. Today, the grid on the Invoice Details tab for that order…