"Hey David !
No problem.
We want to export the tree to Excel or see it any other way than having to navigate the tree interface...
Thx"
Craig Juta's Groups
-
SIRWA North America
11 members
-
Sage 100 Contractor Inte…
25 members
-
Sage PFW ERP Intelligence
47 members
-
Free Reports Group
550 members
-
Sage 50 - Canadian Editi…
147 members
Craig Juta's Discussions
Report Designer Tree Visibility
2 Replies
Hi AllIs there anyone or any roadmap item on the issue below?......We're consulting with a customer using the Report Designer on Sage 50 US.The challenge is easy visibility on the tree structures in…Continue
Started this discussion. Last reply by Craig Juta Apr 17.
Error 462: Remote Machine does not Exist
1 Reply
Hi, any ideas for solving the issues below on Sage 300 ?…Continue
Started this discussion. Last reply by Keeveshin Naidoo Nov 21, 2017.
Bulk Import
1 Reply
Hi AllAnyone have intel on this?I get this error when attempting a bulk import on v6.0 of Sage 300 using Sage Intelligence Free License.…Continue
Started this discussion. Last reply by NATE May 3, 2017.
No Need to Redesign your Financial Reports when you upgrade to Evo v7
2 Replies
We have heard from some of the companies that we talk to that they want to upgrade to Evolution v7 but fear the loss of their existing financial reporting templates..We have a way for you to keep…Continue
Started this discussion. Last reply by Craig Juta Feb 2, 2016.
Craig Juta's Page
Latest Activity
David Bryant replied to Craig Juta's discussion Report Designer Tree Visibility
"Hello Craig
What are the symptoms?
Is the designer cutting off?"
Keeveshin Naidoo replied to Craig Juta's discussion Error 462: Remote Machine does not Exist
"Hi Craig,
Kindly have a look at the below link related to the issue you're experiencing:
http://kb.sageintelligence.com/index.php?title=Error:_%22462_The_remote_server_machine_does_not_exist_or_is_not_available%22
Hope this helps!
Kind…"
Craig Juta posted a discussion
Error 462: Remote Machine does not Exist
Hi, any ideas for solving the issues below on Sage 300 ?See More
NATE replied to Craig Juta's discussion Bulk Import
"Good day
Kindly advise when trying to license if you had logged into Sage300 and logged into a company? If not are you able to try that and let me know the outcome"
Craig Juta posted a discussion
Bulk Import
Hi AllAnyone have intel on this?I get this error when attempting a bulk import on v6.0 of Sage 300 using Sage Intelligence Free License.See More
Craig Juta replied to ktroestler@blytheco.com's discussion Dynamic Date Filter
"Convert to a SQL join first, then apply"
Craig Juta replied to ktroestler@blytheco.com's discussion Dynamic Date Filter
"Yeah, just add a WHERE clause to your container.
Rough example: WHERE table.docdate >= GetDate()-365"
Craig Juta replied to Wynn Davis's discussion report run date
"We can engage with you at this email: success@getfreshbi.com
Or you can reach out to any other professionals here: https://www.sageintelligence.com/consultants/"
Craig Juta replied to Gary Vilinsky's discussion Sage 300 - Sales Master report
"Gary
From my cursory review of this, the results you are getting are expected because you are bringing in a Detail table essentially linked to a another Detail table.
The way to remedy would be to aggregate OESHID].[SHIUNIQ] before bringing it…"
Craig Juta added a discussion to the group SIRWA North America
Ideas on Visualizing Profitability
Here is an idea for visualizing Profitability. We brainstormed on the simplest way to show the most meaningful information on Profitability:See More
Craig Juta replied to E Shin's discussion How do I create a report that lists revenues by GL, then breaks it down by department, and then by inventory item?
"Hi
Another way to achieve this.... you start with the standard Sales Analysis Report, add the GL Account from the line detail to this report and then your dataset will have all the dimensions you need -> GL Account, Department and Inventory Item…"
Craig Juta replied to Wynn Davis's discussion report run date
"Wynn, one of these 2 methods will work:
1) Use the Expected Ship Date on the SO
OR
2) Add 7 days to the base date in your SQL code in the container -> ....[DocDate] + 7"
Craig Juta replied to Mechelle's discussion 'Item Description' for GL Detail reporting
"Hi Mechelle
That is an uncommon request generally speaking and is also not possible to achieve in Sage 50 because that level of detail does not propagate to the GL.
If you could describe the business need you have then I may be able to…"
Craig Juta added a discussion to the group SIRWA North America
Charge Sage Intelligence for Sage Evolution with Mobility
You invested in Sage Evolution Intelligence Reporting and a tailor-made suite of reports for your business and now you wish to Go Mobile, incorporate Cloud Data Sources or Scale your reporting suite to match the evolving needs of your business.We have kept the glory of Sage Intelligence and layered Power BI atop of it to take you fully mobile....See More
Profile Information
- About Me:
- Just celebrating another day of innovation and tirelessly creating happy customers...
- How long have you been using the above solution?
- 10 years
- Where did you hear about us?
- Sage Intelligence website
Comment Wall (7 comments)
- At 6:19pm on February 23, 2016,
Elizabeth Leveques said… Good day,
How is everything with you, I picked interest on you after going through your short profile and deemed it necessary to write you immediately. I have something very important to disclose with you, but I found it difficult to express myself here, since it's a public site. Could you please get back to me on my private email(elizabethlevequees@gmail.com) for the full details?
Have a nice day and God bless you,
Elizabeth
- At 5:57pm on January 29, 2016,
Annie Lok said… Hi Criag, Due to the complexity of our payroll environment, union and pension... Would you be able to create a spreadsheet that draws on the posted payroll entry and from there the spreadsheet determines the individual union and pension contribution? I am on Sage 50 Canadian 2016
- At 8:46pm on March 25, 2015,
Roberta Millar said… Hi, Craig - thanks for the invite. I just started (trying) to learn Intelligence a couple of weeks ago, so I'm thoroughly in awe of someone who's mastered it!
Roberta
- At 3:19pm on March 5, 2014, Nicole Despatie said…
Hi Craig,
would you have the data dictionary for PFW ?
Thanks
Nicole
- At 10:06pm on March 4, 2014, Nicole Despatie said…
Hi Craig,
Would you have a Job Cost report, already done for PFW ?
Thanks
Nicole
- At 7:58pm on September 22, 2011, Jeff M said…
Hi Craig,
I was given your name form Ruth Gray. I hoping you can help me with a Peachtree BI report. I will try to explain this if I can. WE have company credit cards that sometimes carra a balance, I cant see what GL account ID the charges are for in a report until they are paid, so I have spent houra trying to get this report, I have the connector which is what I was told I needed to allow me to create a report that has Vender ID,Name transaction type and the accout ID with paid & unpaid balances broken up by the Gl account ID.. Can you help me with this.
Thank you,
Jeffrey C Morgan
- At 2:16pm on September 23, 2009,
Stephen Coull said… - Welcome to the community Alan - please make sure you join the Sage Accpac Intelligence (SAI) group so stay in touch with news, events, FAQs and did you know around SAI
This Weeks Top Content
The Sage Intelligence Blog
Like Sage Intelligence?
Follow @SageSupport
© 2018 Created by Sage Alchemex.
Powered by
