Stacey Gassett
  • Male
  • Saint Ann, MO
  • United States
Share

Stacey Gassett's Discussions

Can not use "Does Not Begin With" in my filters
1 Reply

Is there a reason that many of the filter comparison operators can not be user to filter a report, such as "Does Not Begin With".  When using this comparison operator, I get the following…Continue

Started this discussion. Last reply by Doug Walker Apr 20.

Using system variables in output file naming
4 Replies

I am trying to use system variables in output file name.  However, when I run out the report, the file gets named exactly as indicated in the output file field.Meaning:  I am trying to name the file…Continue

Started this discussion. Last reply by Stacey Gassett Jan 3, 2017.

Same account number, different account group
2 Replies

I am creating a consolidated income statement.  The problem is that company ABC and XYZ have a few accounts numbers that are the same but fall in different account groups.  (Account 60100-00).  In…Continue

Started this discussion. Last reply by Stacey Gassett Sep 29, 2015.

Excluding Inactive GL Accounts - Sage 100 Designer Add-in
2 Replies

I am new to Sage Intelligence.  I am looking to answer 2 questions.1.  How do I exclude inactive gl accounts from reports2.  How am I notified of new accounts that are not on my reports.I am using…Continue

Started this discussion. Last reply by Peter Scully Sep 5, 2014.

 

Stacey Gassett's Page

Latest Activity

Stacey Gassett replied to Erin Roundy's discussion Report Execution Error for invalid SQL query when adding filter with comparison operator "Does Not Begin With"
"Ok, Thanks"
Apr 26
Stacey Gassett replied to Erin Roundy's discussion Report Execution Error for invalid SQL query when adding filter with comparison operator "Does Not Begin With"
"Yes."
Apr 26
Stacey Gassett replied to Erin Roundy's discussion Report Execution Error for invalid SQL query when adding filter with comparison operator "Does Not Begin With"
"Unfortunately not.  I am thinking that I may have to remove once the data is in excel, maybe via formulas.  Thoughts or any other ideas? Thanks for your help"
Apr 26
Stacey Gassett replied to Erin Roundy's discussion Report Execution Error for invalid SQL query when adding filter with comparison operator "Does Not Begin With"
"I want to exclude all item codes that start with "M" or in other words include all item codes that do not start with "M"."
Apr 26
Stacey Gassett replied to Erin Roundy's discussion Report Execution Error for invalid SQL query when adding filter with comparison operator "Does Not Begin With"
"Hi Doug:  I'm don't see a solution in this link.  Am I missing something. Thanks"
Apr 26
Doug Walker replied to Stacey Gassett's discussion Can not use "Does Not Begin With" in my filters
Apr 20
Stacey Gassett posted a discussion

Can not use "Does Not Begin With" in my filters

Is there a reason that many of the filter comparison operators can not be user to filter a report, such as "Does Not Begin With".  When using this comparison operator, I get the following error:However, I just noticed that although the filter say "Does not begin with", the error below says "Not Like"Description : Invalid sql query near 2017-01-01'}AND "AR_InvoiceHistoryDetail"."ProductLine" Not Like 'LBSP%' AND (AR_Customer.CountryCode = 'USA'OR AR_Customer.CountryCode = 'US' ) AND…See More
Apr 19
Stacey Gassett replied to Stacey Gassett's discussion Using system variables in output file naming
"Thank you - That worked perfectly....."
Jan 3, 2017
Doug Walker replied to Stacey Gassett's discussion Using system variables in output file naming
"Stacy - To add a System Variable to the Output File name the System Variable must be all Upper Case. No spaces in the the file name and the extension should be .xls. i.e. C:\my reports\goal-@MONTH@.xls And yes you can use multiple system…"
Jan 3, 2017
Stacey Gassett replied to Stacey Gassett's discussion Using system variables in output file naming
"Thanks"
Jan 3, 2017
Craig Juta replied to Stacey Gassett's discussion Using system variables in output file naming
"Stacey, there is no native way to do that in Sage Intelligence Reporting. You could run a macro 'On Save' that reads the appropriate cell content on 'Sheet 2' and names the file that way. In this way you could have multiple…"
Jan 3, 2017
Stacey Gassett posted a discussion

Using system variables in output file naming

I am trying to use system variables in output file name.  However, when I run out the report, the file gets named exactly as indicated in the output file field.Meaning:  I am trying to name the file as:  C:\my reports\goal @Month@.xlxsHowever, the file gets name exactly as written above.  The system variable is not replaced with the current month.Any help would be appreciated.Also, can I use multiple variables in the output name?Thank youSee More
Jan 3, 2017
Stacey Gassett replied to Stacey Gassett's discussion Same account number, different account group
"Hi.  Thanks for your help.  Problem solved.  I didn't realize that I needed to identify the company within the GL formula. Thanks again."
Sep 29, 2015
Shwu Hua Gan replied to Stacey Gassett's discussion Same account number, different account group
"Hi, Are you creating it using Report Designer Add-In or just normal Excel? Either case, you should be able to retrieve the value base on Account Group as long as the Account Group have the same name."
Sep 29, 2015
Stacey Gassett posted a discussion

Same account number, different account group

I am creating a consolidated income statement.  The problem is that company ABC and XYZ have a few accounts numbers that are the same but fall in different account groups.  (Account 60100-00).  In company ABC this account represents Sales and in XYZ this account represents Payroll Expense.Even if I have multiple columns with the Chart of accounts for each company, the company XYZ is pulling the payroll expense number for the sales account for ABC company rather than the Payroll Expense for…See More
Sep 28, 2015
Peter Scully replied to Stacey Gassett's discussion Excluding Inactive GL Accounts - Sage 100 Designer Add-in
"Hi Stacey. To add to Candace's comments: 1. I'm not sure if 100 includes this but if there is an active/inactive account field in your report data, you can add this field to your report and place a filter on that field to exclude…"
Sep 5, 2014

Profile Information

Sage Intelligence powers the following Accounting/ERP/Payroll solutions, pick yours
Sage MAS Intelligence, Excel On Steroids
Website
http://dynaflex.com
How long have you been using the above solution?
new
Where did you hear about us?
Other

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