Ian Barbour
  • Male
  • Perth WA
  • Australia
Share

Ian Barbour's Friends

  • Stephen Coull

Ian Barbour's Groups

Ian Barbour's Discussions

Running Union Consolidation reports with different companies in Sub-Reports
6 Replies

Hi Everyone,I have only just noticed that when running union consolidation reports, if you have different companies selected in your sub reports, the union report will only return data for the…Continue

Started this discussion. Last reply by Mariano Catalano Apr 14.

Permission Denied error - Sage 300
1 Reply

Hi All,We have a client that has recently started getting the Permission Denied error that has been resolved in the following KB:…Continue

Started this discussion. Last reply by NATE May 24, 2017.

#NAME? error
1 Reply

Hi,I have a Union report that is using FormulaToDataColumn using a simple Vlookup formula to reference a separate rawdata…Continue

Started this discussion. Last reply by Ian Barbour Mar 13, 2015.

 

Ian Barbour's Page

Latest Activity

Ian Barbour replied to Craig Juta's discussion What License is used when Scheduling a Report?
"Hi Stephen, We have a Sage 300 site running a couple of scheduled reports, but notice that if all the Report Manager licenses are used then the report will not run.   Is there a way of locking a license to a user or having a scheduled…"
May 16
Mariano Catalano replied to Ian Barbour's discussion Running Union Consolidation reports with different companies in Sub-Reports
"Hi, if you are looking for consolidation and currency conversion of Sage 300 companies, we have several clients doing it. You can email me to mcatalano@adssglobal.net"
Apr 14
Paula Park replied to Ian Barbour's discussion Running Union Consolidation reports with different companies in Sub-Reports
"Thank you Ian.  Yes, i believe the setup is the same.  I have Auto Connect selected for my Consolidated Connector.  Then my container was created with the one sales table.  But when I create a Union report, with 10 archived…"
Mar 6
Ian Barbour replied to Ian Barbour's discussion Running Union Consolidation reports with different companies in Sub-Reports
"Hi Paula, I'm not sure how your connectors work in Sage 100, but with Sage 300, when you set up a Connector you can select the Auto Connect option or, if you want a specific database, enter the database details in the setup. This allows me to…"
Mar 6
Paula Park replied to Ian Barbour's discussion Running Union Consolidation reports with different companies in Sub-Reports
"Hi Ian, I have a Consolidated container and have created a report with one table that is consistent to all companies.  My 10 sub union reports are 10 data different Sage 100 companies, version 5.20.   I am finding out that it does…"
Mar 5
Ian Barbour replied to Carol Lord Openhym's discussion Report Utility - GL Transactions Incl OpenBalance S300SQL(C166-0-1) - Errors
"Hi Carol, Did you ever get a resolution for this? Cheers, Ian"
Aug 23, 2018
Ian Barbour replied to Carol Lord Openhym's discussion Report Utility - GL Transactions Incl OpenBalance S300SQL(C166-0-1) - Errors
"Hi Jax, I have the same issue but have found the report does work with SAMINC and SAMLTD data but not with any other customer data.   I cannot spot anything in the container that would affect this. Thanks, Ian"
Aug 23, 2018
Ian Barbour replied to Ian Barbour's discussion Running Union Consolidation reports with different companies in Sub-Reports
"Hi Carmen, The problem is more to do with the way the databases are selected when using Consolidated containers.   When you have a Union report, each Sub report has databases selected in the "Database Consolidation List". …"
May 17, 2018
Carmen Griessel replied to Ian Barbour's discussion Running Union Consolidation reports with different companies in Sub-Reports
"Hi Ian  If I understand the above correctly you may want to apply Pass Through variables to your report so you could then pass the company name into the report and filter the sub report further.  Check out this webcast on pass through…"
May 15, 2018
Ian Barbour posted a discussion

Running Union Consolidation reports with different companies in Sub-Reports

Hi Everyone,I have only just noticed that when running union consolidation reports, if you have different companies selected in your sub reports, the union report will only return data for the companies selected in the first report that is run.I can think of a number of ways around this, but is it not possible to run the report based on the companies selected at the sub-report level?Many thanks,Ian BarbourSee More
May 11, 2018

Profile Information

Sage Intelligence powers the following Accounting/ERP/Payroll solutions, pick yours
Sage Accpac Intelligence
Website
http://www.cpmoore.com

Comment Wall

You need to be a member of The Sage Intelligence Community to add comments!

Join The Sage Intelligence Community

  • No comments yet!
 
 
 

The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2019   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service