Sage 100

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!

Does anyone else have trouble with the Sage Time clock not matching the atomic time clock in the cloud? Is there a time clock in Sage somewhere that can be adjusted? Mine gets off a minute or two and drives the employees crazy. They cannot clock in until…

Missing Work Ticket: Work Ticket shows on WIP Reconcilliation and Work Ticket Inquiry but cannot be found on Work Ticket Entry and PO's cannot be linked to it. Where is it?

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 a way to purge old data in time tracking. Client upgraded to 2.2 and now all of the data history for past 7 years is showing when they go to make an entry.

With different frequency, but frequent enough to be a nuisance, especially when involving millions of dollars, the Original and Revised contract amounts get out of balance. Since it cannot be tracked easily, I'm wondering whether anyone has run into this…

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…

I'm very new to Sage and am slowly moving into an administrator role. I'm trying to find a way to archive payroll data so that I can remove the payroll module, as my company no longer uses Sage for payroll at all. I've searched online but I guess I'm…

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?

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…

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…

Had a Crystal report using the JTDActualCosts and JTDInvoiceBilled fields from the JC1 data file. Recently upgraded to 2018 and the JC data file no longer has these fields. Where can I find them?

How do you purge terminated employees in Sage 100 2019? https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=71732&sliceId=1&isLoadPublishedVer=&docType=kc&docTypeID=DT_Article&stateId=14738&cmd=displayKC&dialogID=538793&ViewedDocsListHelper…

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…

End user need Vendor Code on invoice need to look in JC_JobTransactionDetail. Where can if find a list of what is in that file?

Client is on 2018.8 and upgraded from prior version in Feb 2019. One employee shows on the Data Entry Audit Report for being paid in May 2019. That employee no longer shows anywhere in the PR_Employee.M4T file - at least as far as I can tell. The only…

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…

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…

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…

Hello all, I'm trying to understand, difference between the file and Table, from the help guide I got following. For non-Business Framework modules, information includes data file names and descriptions, file types, and key lengths. For Business…

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

Client is trying to update tax tables for 2018. Getting an error when trying to run payroll of error 107 in PR_TaxGroup for an Ohio tax group (they don't use Ohio). Help!

Working with a client to get vacation accruals set up and just discovered this. The screen shot below is from the ABC demo data. I checked it back to version 2015 and got the same results. Note the available hours field for vacation is showing 0.…

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…

MAS 100 - P/R Module - Level 5 I am reconciling for quarter end. When I run a Perpetual History Report, the total (for one fixed amount deduction) for one employee does not match the QTD total (for the deduction) within the "Voluntary Deduction…