Sage 100

Receive “data is not selected for report printing” when using any single tax group as criteria in Payroll Tax History Report Brought to my attention by a client, and I have now duplicated in both my 2024 and 2023 systems with no modifications. In…

Hello, Im new to pulling reports in SAGE and am looking for any help of suggestions please. Would anyone know how to pull a report of customers that are currently set up as NONTAX? TIA

When attempting to save the template I get an error message. This is Sage 100 ver 2023 using Office 365 This happens on any financial report I select. I have been running this report and updating regularly for several years. I have re-installed…

When I run the report for Source Journal SO and with a date, the report seems to query all the data for SO and doesn't pass the date filter to SQL. Is this the normal way that the reports are setup? Retrieve all data and then apply a filter in Crystal…

I am trying to find a report that shows our Budget vs revised Budget as well as our cost codes broken out into cost types (Labor vs Material) any advise is appreciated.

Where are Prior Year Item Warehouse History by period quantities and sales located? I want to compare current year to prior year for multiple years. Sage 100.

Hi, Does anyone know if there is a way to convert a SI financial report to Power BI? Thank you!

I have created a Sales History report with both the Main and Subreports pulling from SO Sales History. The main report generates PTD sales by item The subreport generates YTD sales by item I have created a shared variable in the subreport to pass…

Hey group, Anyone seen this issue when trying to create / add / upgrade custom crystal reports for Sage 100 Advanced 2023? I have tried recreating the report and just pulling data from AP_CheckHistoryHeader I'm getting "Database Connector Error: "S0000…

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…

Is there a Report I can run that shows all my customer discounts?

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?

I'm looking for which tables to use for creating a report or query to calculate the average days to pay per client. Any feedback is appreciated.

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…

I have a client that is getting the following error when they try and send a sage intelligence report via email. Has anyone encountered this issue and been able to resolve? Thanks

A client of mine is trying to understand how much of each vendors products their salesmen sold in the previous year. I've been attempting to connect reports in PBI & Excel to garner the information, but haven't had any luck. Any suggestions on reports…

Is there anywhere in Sage 100 - where I can print out all of our A/R credit memos for 2023. It is year-end and our auditors are requesting and it is way to many to scan and email. Any help would be much appreciated

I am trying to build a report that will show me what companies a particular vendor is set up in. We have 53 companies. I am not sure how to join the company code with the vendor table to show on one consolidation report. Nothing seems to link well, any…

We have several individual companies in SAGE. I would like to export the general ledger detail from each company, at once, into one large excel file. Currently, I go into each company and export the data manually and it is very time consuming. Is…

Hello, I am trying to find the parent table for the AP Trial Balance report. Does anyone know which one this might be? Also, does anyone know of a document that may list the parent tables for reports, or a function in BOI that I might use to get this…

My support provider is telling me that my Sage 100 comes with one user for Sage Intelligence Reporting but does not allow modifications to existing reports. I need to upgrade to 'with Reporting' to get that. I am looking for confirmation of that. As…

Looking to see quantities and part numbers and value of transactions to tell how many pieces we are selling vs allocating into work tickets. We stock part numbers that could be sold directly to customers or allocated into larger bill of materials/work…

Can you print the balance or income statement with the sub account information?

Is there a way to see usage of inventory for both YTD and MTD? Thanks

When attempting to run a Sage Intelligence report (Sage 100) via the Windows Task Manager, the scheduled task fails with the message: Native Error Number: [-1147121340] Source Library: [] Error Text: [Sage 100 ERP Intelligence Reporting cannot create…