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…
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…
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?
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…
A client has 15 Sage 100 companies & 9 Excel spreadsheets. Each spreadsheet has 20 tabs - one for each company plus several for combining different companies. SIR will take about 5 minutes to load. I'm looking for a recommendation as how to structure…
Hello Everyone,
Looking for a little help on how to print the sales order line number on Packing Slips & Invoices.
We are finding every time a partial order is shipped the line numbers are renumbered starting at one based on the remaining lines…
Wrote a Positive Pay report using the Intelligence a couple of years ago for a client.
The report contains the Bank Account Number from the GL_Bank file.
They just upgraded to Sage 100 2019 ran the report and the Bank Account Number is blank.
Searched…
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…
I am having an issue where the Consolidated Designer report is not showing any amounts for one account in a particular company even though it has activity. I can only get it to return an amount if I type the actual company code into the formula dialog…
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…
Hi,
i get this error when open BI Report Manager
I'm on Sage 2014 PU3
"The function GetDataValue can only service SQL calls that result in a single return value. Please modify the SQL statment accordingly. The SQL statment supplied was : -
SELECT…