Sage 500

Is there a way to generate a report of the contents of our reporting trees? The contents seem to be XML like but can't figure out a way to use the data to generate a report of what's included in each tree. Thank you.

Hello, I've been in Supply Chain for many years now. I have used several ERP systems, but this is my 1st time with Sage500. I have tried to find resources on understanding the MRP Generation Report with no luck. Does anyone know where I can find some…

Are there any risk(s) associated with compacting the MetaData? Is it worthwhile? Sage 500 2017 and Sage Intelligence.

We are using Sage 500 2018 (v7.9) and we recently upgraded from Office 2016 to Office 365. Now our Accounting department is receiving errors when using Sage Intelligence i.e. Sage.BI.ExcelFunctions1.1.x11 don't match. I have tried to Add the Report Designer…

Need some eyes on a Sage Intelligence Transaction report filters and parameters. Please see attached file. Adding filters with parameters works for one set but not another. Can someone look to see if you have a suggestion as to why the filter/parameter…

On several of our Report Designer reports we are now getting #VALUE! or Object reference not set to an instance of an object errors when just the other day they were fine. I believe it is an Excel issue this time since I ran and saved the same reports…

Greetings, We are currently in Sage 500 Version. 7.4. Does Sage 500 have a user friendly On Time Ship and Current Late Units reporting ability besides exporting and filtering data in an excel spreadsheet? I am super new to Sage 500 so any advise…

What is the equivalent in SMI of the reporting tree in FRX? How do you duplicate that functionality?

Hi all. Last week Sage Intelligence released a new Learning Portal, consolidating all of our learning material and providing you with clear and concise learning path for Intelligence Reporting desktop products specific to the level you're at. It includes…

We are using Sage 500 ERP Intelligence Reporting 2015 with Sage 500 2016. From a Report Designer Add-in report, a user attempts to drill down to the transaction detail on an income statement account. But they encounter this error - The drilldown report…

I was following the instructions from this website: https://www.sageintelligence.com/tips-and-tricks/sage-intelligence-tips-tricks/2013/11/drill-values-view-deeper-level-data/ When trying to run the second drill down on the report, I get an error…

We own Sage Intelligence but no one here knows how to use it. I want to change that. Where should I start?

Get immediate access to a library of additional reports As your business evolves and grows, so too do your reporting needs. We understand that it’s not always realistic to wait for the next Sage Intelligence update to get your hands on the reports that…

I want to connect to a field in the PA resource table (tPA0007) based on a field X already in my Explorer View. Can this be done in an Explorer Calculated field new column?

None of the inventory CAN reports in Sage500 obtains all followings; item code, product code, Item Description, Item cost and vendor ID for each warehouse. Any help will be greatly appreciated. :)

Wondering if anyone is using this product and what they think. We are evaluating it and just looking for any input. Thanks, John Hanrahan