Sage 100

Is there a PO Return of Goods History Report? I see Inventory Sales History, Inventory Receipts History, and Inventory Issue History Reports under IM module, but I don't see an Inventory Return of Goods History Report. Nor do I find one under the PO…

I Have a Consolidation Report with last 20 years financial data and I want to create a filter so that the report only returns last 5 years of data, I tried including system parameters to the standard report 'Fiscal Year' First but whenever I run that…

Hello everyone, I have an issue that I haven't been able to find a good fix for. Users in the office access Sage that is installed on one of our servers with an RDP connection into the Information Assistant app to pull reports, particularly Job Cost…

I feel like the Not Equal join used in Crystal in order to combine the Company file in a report to be able to get the company name/code would not work in SI. Is there a way of adding the company code for NON-FINANCIAL reports?

Fresh install of Sage 100. I ran the installer as domain admin as well as the WksUpdate Standard file. I have already tried reinstalling the software over 5 times and verified all necessary files were present in the C Drive file path. Is there any other…

Hello, I'm just trying to set up auto delivery for this report but it looks like it is only available in the stock Crystal Report form. Does anyone know if it's available in Sage Intelligence or if there is a way to convert Crystal Report reports to Sage…

Hello, I ran the AP trial balance report for January and compared it to the January GL. I discovered it didn't match. I found out that someone had entered a January invoice into February. Then to correct it, they adjusted the invoice to 0 in February…

On report 5-1-8-86 How do remove old employees from the report? Some of these employees have not been employed for quite awhile, but still show, even with a zero balance.

HELP! What reports are you pulling/printing to do the Oregon Corporates activity report? We are a WA. based business, but we also do jobs in Oregon. Need to be able to separate the states or tax district. What I'm looking for is a report that will…

Hello fellow Sagers! Happy Holiday's or Merry Christmas! I need a report that shows all inventory items WITH "Inventory Cycle" and "Active/Inactive" status displayed. I have years of incorrect inventory items/status modifications that were entered and…

Hi all, We do most of our customer reports based off the GL_DetailPostings table. I have a few reports filtered to only show "SO" module transactions and I pull in some additional data from the InvoiceHistoryHeader table but now am being asked to…

Have a client that upgraded from Sage 100 2019 to Sage 100c Advanced 2023 PU1. They run several reports outside of Sage using Crystal Reports Writer version 2020. They can run these reports with no issues some of the time, but then later in the afternoon…

What are the steps to upgrade Sage Intelligence on Sage 100 standard 2015 to Sage 100 2023 Premium (SQL)?

I am creating a new report for a client and after saving and re-running, the first custom tab has been partially overwritten by four columns of CompanyCode, Rollup Type, Rollup Type Description, and Rollup Code. The standard Rollup tab is still hidden…

I'm looking for assistance on an Inventory Valuation Report. I'd like the report to sort via valuation. The highest values descending to lowest. I can't export to Excel and sort that way because of serial numbers. Does anyone have ideas on how to…

Hello, I am looking at sending an automated monthly report to a customer with a list of the items they supply us. If possible, I also wanted to provide a breakdown of any work orders, inventory adjustments, etc against each item. Is this report possible…

Can the reports "GL Transactions incl BegBalances" & "GL Transactions Incl Open Balances" be converted to Consolidation reports? Or, is there a way to set the company code and add the 8 companies as sub-reports?

Hello, We are having an issue with exporting reports to a pdf file. Random reports will not open and acrobat gives the message "Adobe Acrobat could not open 'name_of_file.pdf' because it is either not a supported file type or because the file has…

Normally I'm able to hit alt-E-K to eliminate all of the external links and replace with values within a spreadsheet, but no such luck with an Intel report. What steps am I missing? Thanks

Receive "No workbooks Open to Link" when trying to save an Excel Template

Has anyone ever created a Comparative Financial Statements for multiple years other then just Actual and Prior using Sage Intelligence? Request is to be able to print Comparative Financial Statements that cover, for example, the last five years on…

Hi, I run a fire protection company. We started a year ago and have grown to be 55 people and ~$7m of revenue. We use Sage 100. We're starting to need to get into analytics. We have an install and service part to our business and multiple services lines…

I created a Sales Report in Crystal Reports 2016 that has 20 columns of Summary and then those 20 columns have sub-reports that I have linked to provide the Details by simply clicking on the hyper-link of the Sub_Report name. I added the Sales Report…

Please forgive me if already answered somewhere, but I could not find it. Sage 100C - I need to print a list of all jobs from 2015 - present. Just need the Job Number, Job Name, Job Address. This should be so simple, but I was not able to find…

Does anyone know if in Report Manager you can create 2 types of output files (xls & pdf) run with windows scheduler from one report or do you have to create a copy of the report to be able to do a second report output and schedule it after the 1st one…