x Want to participate? Join the group to interact

  • Creating a Parameter and Filter to Only return last 5 years out of 20 years of data in the report - This is a Consolidation Financial Report and has a Standard Report named Fiscal Year

    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…

  • Days to pay report or query?

    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.

  • Report of Inactive Items ONLY

    Good morning, I need to produce an inventory report of ONLY the inactive items/SKU's. In the Inventory Item Listing report there is an option to include Inactive items, but I don't see a mechanism to report ONLY inactive items without ALSO including…

  • Exporting from Crystal with 'text' formatting

    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…

  • Sage Intelligence duplicating data single table

    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…

  • Inventory Valuation report Sort question

    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…

  • convert single company GL reports to consolidated company reports

    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?

  • Calculate aging over time

    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…

  • Report Writer - Searching for Consultant

    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…

  • SIR consolidated report recommendations

    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…

  • Print SO Line Number on Packing Slip & Invoices on crystarl report

    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…

  • PRINTING A RANGE OF SALES ORDERS

    Is there a location that we can go to in order to print multiple pick sheets at once without having to open each one individually?

  • Sage 100 2019 Sage Intelligence Bank Account Number

    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…

  • sage time format / Crystal Report

    Hello, i am trying to create a report, and want to supply the TimeUpdated String(8) field from the IM_PriceCode table. can i create a formula field to convert that Field to a 12 hour time field? if so.. how? Thanks for reading. Peter

  • Silent ODBC on terminal server

    Hi All, I am struggling with this issue. Everything I read says it should work this way but it does not. Client is on Sage 2017 Standard. I created a report that uses a silent connection. It is 64bit and I have set it up as a System DSN. Works fine…

  • Profit Report by Customer

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

  • Sage Intelligence Data Limit Reached in Excel

    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…

  • Error 462 while attempting to run Sage Intelligence Reports (in Sage 100c 2016)

    I have a client experiencing some errors I have never seen... They are heavy Sage Intelligence users. We just upgraded to Sage 100c 2016 a few weeks ago and since then their Sage Intelligence has been more error prone than I would like... Here is…

  • Business Insights Reporter Wizard Payroll Hang

    I am trying to create a new report through the reporter. When I give the report a name and choose where it will be in the reports it puts me to the next screen where I should select a template (Landscape, Portrait, Shipping Label.) At this point no matter…

*Community Hub is the new name for Sage City