Did you ever get this sorted out? The simple answer is to change the formula from
"=GLActualEvo(J$6,$A11,$B$5,G$7)" where A11 (account number) = 100000
"=GLActualEvo(J$6,$A11,$B$5,G$7)" where A11 (account…"
Create individual reports to extract the data from each table, then create a Union Report to extract them into a single worksheet.
In the Report Manager, Properties of the union report, select Sheet1 for the first report, keep Sheet2…"
This issue is to do with Evolution, not your report. Contact Sage Evolution support and they will talk you through fixing the system tree issue. It was something I encountered at a user site at the beginning of this year."
Sage Alchemex runs weekly, topical webinars regarding the Sage Intelligence solution as well as products powered by Sage Alchemex. These webinars are recorded and you will find links to these videos in this group.See More
The organization known as S.I.R.W.A., (Sage Intelligence Report Writers Association) has two separate missions. First, SIRWA provides an organized group where like-minded, multi-talented, and qualified report writers can collaborate with and learn from each other. All SIRWA members are “qualified” based upon criteria specifically designed to admit only the highest quality report writers, developed by the association itself. The main mission of SIRWA is to provide a professional resource of…See More
As you know Sage Intelligence allows you to customize all your reports, and you can up skill on how to add fields/ reports to the Report Designer by going to our Learning Portal.
Here I would suggest you check out the below…"
sounds like you have multiple svd's linked to different companies.
check under report manager in each company and see if everything is pointing to the same location. look at the metadata repository path."
Sage Intelligence powers the following Accounting/ERP/Payroll solutions, pick yours
Sage Pastel Intelligence Reporting (Formerly BIC), Sage Intelligence – Financial Reporting for Sage ERP X3, Excel On Steroids
My passion lies in creating clear and simple, interactive, real-time Excel dashboards and reports to extract meaningful and accurate information out of accounting and operational systems "at the touch of a button", without data manipulation, on any device, anywhere, anytime.
As a certified Sage Intelligence Report Writer, I have written reports in Sage X3, Sage Evolution and Partner Accounting. I have specialist knowledge of Microsoft SQL, Microsoft Power BI, and advanced Excel techniques.
How long have you been using the above solution?
Where did you hear about us?
You need to be a member of The Sage Intelligence Community to add comments!