Sage 100

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…

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?

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…

Hi everyone, I'm wondering if anyone knows how to generate a list of all customers that have special pricing methods set, including: Cost Markup Amount, Cost Markup %, Price Discount Amount, Price Discount % and Price Override. The one that's chiefly…

Hello, I'm looking to re-create a Crystal report so that it can be run by Knowledge Sync. I initially wanted to just use the report provided by SAGE, but it looks like I can't use this report as the information the SAGE report pulls is only generated…

Just wondering what financial report alternatives are available for Sage 100. I have seen Sage Intelligence years ago, but was not impressed, it was clunky, difficult to use and not flexible. I have worked with F9 which is user friendly and is super flexible…

Hello, I am creating a report for our accounting department which shows all A/P batches that either remain open, or were created today. I have the first part, where I can pull up all active batches through GL_CompanyActiveBatch. However, I am having…

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

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…

Want to learn a few tips on using Excel that relate to reporting with Sage Intelligence? Check out the tips available, all relating to reporting. https://goo.gl/LHYfbe You can sign up now to receive these tips in your email or bookmark the page or both…

I had this same problem last year. My AP Aging for 12/31/13 does not match the GL Balance for AP at 12/31/13. I checked the setting in the report parameters to exclude future dated transactions but they still do not balance. Could someone help me with…

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…

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…