Sage 100

I've looked through the payroll module overview and other sources and cannot determine whether employees' federal and state withholding elections (filing status, including exempt) from the W-4s are reportable fields. If some report, somewhere, captures…

I have a report from v2017 that utilizes the table PR4_EmployeeEarningDeduction. The documentation says that in v2019 the equivalent table name is PR_EmployeeDeduction. The problem is that the new table doesn't seem to include earning information, and…

I'm sure this is similar to the issues others are having when trying to get PII data from Sage to another application, but I'll ask anyway. Our client has an Access database. They need First Name, Last Name and Status. Anyone figured out how to do this…

Is there an AR report to show/compare the Customer Sales History by Fiscal Period and Fiscal Year for more than 2 years?

I have created a custom report in Report Manager that I want another user to be able to run in their Report Viewer. How do I share these reports?

I've run into this issue occasionally for at least the last couple of years. Say, for example, that I'm posting a batch of Invoices in Accounts Payable while my coworker is posting a batch of Cash Receipts Entries in Accounts Receivable. I post my batch…

We have 3 company codes in our system. The operational efficiency ratio data on the general ledger analysis report populates for one of our companies but not the other. Has anyone experienced this issue before?

We just updated crytal reports from 2011 to 2016 version. Do we have to convert any reports that we changed with crystal reports to work with the new version?

Is there a table to create a report that can give you info from the Time Off Register but after a payroll is updated? Looking for accrued hours and accrued hours used by posting date. (PR 2.20)

The Visual Integrator "Job Log Report" is cutting off the information on the errors that occur. For example, a recent report looked like this: You can see that the error description is being cut off and so I can't see which batch or invoice I need…

We've always wished that we could export or print the transaction detail that we see under the Transaction tab in G/L Account Maintenance and Account Inquiry. Yet that's not possible. What's most frustrating is that a Print button is staring you in the…

Hello, I'm looking to re-create a Crystal report so that it can be run by Knowledge Sync. I initially wanted to just use the report provided by SAGE, but it looks like I can't use this report as the information the SAGE report pulls is only generated…

Hello, I am creating a report for our accounting department which shows all A/P batches that either remain open, or were created today. I have the first part, where I can pull up all active batches through GL_CompanyActiveBatch. However, I am having…

Is it possible to get a report of all client emails from Sage?

Sage 100 - Payroll 2.19 I printed payroll checks and the last check printed on white paper. Before printing a check register and posting, A) I selected Payroll Check Printing B) Print Checks Already Printed C) Entered the next starting Check…

Hi, In Sage 50, I was able to pull a report showing me all the payments we made to a particular vendor quite easily, but in Sage 100 I'm not sure how to go about it. I would like for example to see what we've paid to Vendor XYZ from August 1, 2018 to…

I need BI Tools menu in Excel to export reports. It keeps disappearing from the tabs at the top. If it goes away, I have to reboot my whole computer to get it going again. Any help would be much appreciated. There are no warnings or dialogs that pop up…

Time to file your quarterly reports and one of my clients noted that the workman's comp report was underreporting hours when checks have been reversed. It was very obvious because they had reversed an entire payroll. If you reverse a paychecks the report…

Trying to convert a Job Cost report from pre-2018 to 2018. The file uses a subreport to get the employee information for a LABOR posting (not done through TimeCard/TimeTracker). The employee information is parsed from the Comment field in the JC Detail…

Is there a way to do a profit report per customer?

I have a Consolidated Financial Statement that contains up to 30 companies. It appears to be hitting the data limit. I talked to Sage Support and they said that the data can be filtered to generate the report. I wanted to pull the last 2 years of history…

Has anyone found a way to use Payroll reports written in Crystal 2011 with Personal Information and convert them to Sage 100 2018 Crystal 2016 with the new Employee PII fields? Followed article KB88325 but that is only for newly developed reports in Crystal…

Want to learn a few tips on using Excel that relate to reporting with Sage Intelligence? Check out the tips available, all relating to reporting. https://goo.gl/LHYfbe You can sign up now to receive these tips in your email or bookmark the page or both…

I had this same problem last year. My AP Aging for 12/31/13 does not match the GL Balance for AP at 12/31/13. I checked the setting in the report parameters to exclude future dated transactions but they still do not balance. Could someone help me with…

Every month, we send a "Top 100 Best Sellers of the Year" email newsletter to our customers. In Sage 50, we could create a "best sellers" list simply by creating a Stock Report, selecting to add the column for Sales Qty Year to Date, exporting to Excel…