Sage 100

Hello, I'm using an SQL version of Sage, and use Sage 100 Premium. I'm having an issue with a report in Sage Intelligence. I have a copy of the Sales, Customer Sales report that I had copied into another folder. When I try to click on it, it immediately…

Has anyone had success in exporting a report from Crystal to Excel - Data Only format and have Excel format columns with string values as 'TEXT' and not 'GENERAL'? I can't seem to come up with a way to do this in Crystal. Thought I would check here before…

I would like to print the Report Selections Date Range in the Report Header.

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…

On Sage 100 Advanced 2021 sp5. I created a container with only the AR_InvoiceHistoryHeader file. added 4 fields. set the filters to a single date and only Source Journal "SO" the invoices are all duplicated. I tried the same thing on a different…

What are your favorite inventory reports to measure efficiency or accuracy? Does SAGE have any good native reports that yall use or is it better to make your own reports.

How do I find the location of Sage Intelligence reports of the network?

In Sage Intelligence Reporting we frequently find that we need to clear out the Tenant cache. The error message we get back is: Problem Loading Data A row with duplicates was encountered at row number 248 for data object Accounts The Values are…

Windows 11 laptop, with Sage 100 versions 2020 Std, 2021 Adv and 2022 Prem installed and functioning fine. Sage Intelligence will not open any task in any of these versions. It's been a while since I have opened SI on my laptop, but it was working in…

Hi All, I have a report that is using the {AR_InvoiceHistoryHeader.InvoiceDate} field and I need it to return the last 18 months of data. Does anyone know the proper syntax to do this. Something along the lines of: "{AR_InvoiceHistoryHeader.InvoiceDate…

I have one workstation that is printing Invoices. Even when they enter "Invoice Number / Equal To / " and type a single Invoice No, it prints all invoices in the batch. I am going to reinstall the workstation, as it is only occurring on one workstations…

What is the best report to give a list of items sold, say for the last 12 months, from 1 particular vendor?

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 One of the options when running a detailed GL report is to select the PRINT POSTED BY DATE field. This will add two columns to the report that includes the Source Journal and the Posted Date. My question is can I create a report, either by crystal…

Hello, I was running a view in both BI and SQL for all customers who are tax exempt for company CEN.. when I run both views in BI and SQL I find that there is no data showing up in the TaxExemptno columns however when I check some of the customers…

Hello, I'm looking to create an Income Statement by a specific date range. There was a previous post of an individual stating they wanted to do the same thing and the response was that it could be done, but that you had to have Report Designer. …

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?

In upgrading office from 2010 to Office 365 reports generated in Sage Intelligence I can only see the data when the document is opened in protected mode. If the document is opened not in protected mode I get a NAME reference error on all the formulas…

Where can I find the information I need to calculate customer aging over time? Usually when I get stuck I can copy something one of my predecessors did, but no one knows of any report like this previously. I want to be able to show a sales person, for…

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

I have 2 report viewers who in excel don't have the option to drill down when right clicking on a cell. The report manager user however can drill down on the same report. I was told report viewers can drill down. Is there an excel setting that I need…

I'm new to Intelligence reporting. Is there a way to change the presentation order of accounts on the income statement without changing the account numbers? Thanks, Chris

I need some help with a form and sub report that we are using to obtain the alias part descriptions for some of our forms. My issue is that I wish to ignore all the C type (customer type) alias data and only use the G type (general) details. The sub…

Hello working with Sage 100 2019 learning the Business Insight module and discovered I dont have a Reporter folder under Business Insights. When re-running the workstation setup there is no option to install Crystal either, and I find no install files…

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