Report Manager Activation Doc
Hi,Could someone point me to a document guide for the activation of new Report Manager licenses for Sage Accpac Intellignce?Thanks, CraigSee More
Craig Juta's Groups
-
Sage PFW ERP Intelligence
35 members
-
Free Report Templates Gr…
116 members
-
Sage 50-U.S. Edition Bus…
90 members
-
Alchemex Certified Profe…
46 members
-
Sage ERP Accpac Intellig…
135 members
Craig Juta's Discussions
Report Manager Activation Doc
Hi,Could someone point me to a document guide for the activation of new Report Manager licenses for Sage Accpac Intellignce?Thanks, CraigContinue
Started yesterday
Using '@TENANT_CODE@' for consolidation
2 Replies
HiUsing the Consolidation connection I need to identify the company being queried at a specific point in time.I assume that '@TENANT_CODE@' should parse the current company but it does not.Extract…Continue
Started this discussion. Last reply by Craig Juta May 5.
MAS90 - SubQueries
Hi,Whenever I use a basic sub-query against MAS90 data, I get the error below. Does anybody know if the database has a restriction on using sub-queries? Sub-queries are a frequently used in…Continue
Started Jan 25
Not ‘because I have to’ but ‘because I can’
How to use Peachtree Business Intelligence to avoid the surprise impact that Commission due to Account Managers may have on Cash-Flow...…Continue
Tags: Commission, Reporting, Peachtree, Sage
Started Sep 1, 2011
Craig Juta's Page
Latest Activity
Craig Juta replied to Craig Juta's discussion Using '@TENANT_CODE@' for consolidation"Thanks Stephen, that is very helpful!
Craig"
Stephen Coull replied to Craig Juta's discussion Using '@TENANT_CODE@' for consolidation"Craig,
The tenant code stores the code of the company currently logged into, so cannot be used as you want to in this scenario.
You will need to create 2 connections to the dedicated companies as suggested."
Craig Juta posted a discussionUsing '@TENANT_CODE@' for consolidation
HiUsing the Consolidation connection I need to identify the company being queried at a specific point in time.I assume that '@TENANT_CODE@' should parse the current company but it does not.Extract from the query to match the company code:LEFT JOIN "SY_Company" ON "SY_Company"."CompanyCode" = '@TENANT_CODE@'When I run a report against the consolidated connection for 2 companies and request the company name, only one company name is displayed, not…See More
Craig Juta replied to Doug Walker's discussion Help creating a SQL Join"Hi Nigel
I also tried to use the query that you built and it returned the same error as Doug received. I even reduced the query to a very simple query and received the same error. This is the query I used:
select * from(select '0000014-IN'…"
Craig Juta commented on Ruth Gray's group Sage Peachtree Business Intelligence"With Peachtree Business Intelligence offering so much versatility, it is often hard to envision the presentation of a solid set of Consolidated Financial Statements.......
"
Craig Juta commented on Stephen Coull's group Sage ERP Accpac Intelligence"With Sage Business Intelligence offering so much versatility, it is often hard to envision the presentation of a solid set of Consolidated Financial Statements.......
"
Craig Juta posted a discussionMAS90 - SubQueries
Hi,Whenever I use a basic sub-query against MAS90 data, I get the error below. Does anybody know if the database has a restriction on using sub-queries? Sub-queries are a frequently used in reporting, so it is not possible that this can be a restriction, no?This sub-query returns the error below....SELECT * FROM(SELECT * FROM IM_ItemTransactionHistory) AS ITEMTRAN…See More
Bev Michelle Allen replied to Craig Juta's discussion Sage Pastel Partner - Sales Invoices & Orders in the group Free Report Templates Group"Thank you very much, for sharing your hard woprk with everyone. Bev Allen."
Craig Juta replied to Stephen Coull's discussion Sage Accpac Intelligence Success Story - A Partner Perspective in the group Sage ERP Accpac Intelligence"Good paper Glen!"
Craig Juta replied to Craig Juta's discussion Purchase Orders on Projects"Hi Colleen, I am glad we can help you.
The solution in the link above is an example of a custom solution and in the Intelligence Store we have a solution very similar to this one. Why not download the free version of the report to give it a test…"
Colleen Wilhelm replied to Craig Juta's discussion Purchase Orders on Projects"I am so happy to see this. I need to see detail of projects with regard to purchases and service items/hours, etc. Can you point me in the right direction to get this report started?"
Craig Juta replied to Dave Greene's discussion AccuPOS database"Howdy Partner
Not with AccuPOS specifically but it should be easy. I will ping you and we can talk about this."
Craig Juta replied to Johann Joubert's discussion Simply Accounting 2011 Report - Commission Due on Sales in the group Free Report Templates Group"Hi Ann
The Store has the solutions that you request, ready for action:
For Customer Rebates: http://theintelligencestore.com/products/customer-rebate-report-simply-accounting-2011
For Commissions based on Customer…"
Profile Information
- Alchemex Powers the Following BI Solution, Pick Yours
- Pastel BIC, Sage Accpac Intelligence, Sage MAS Intelligence, Simply Accounting, Excel On Steroids, Sage Peachtree Intelligence
- About Me:
- I like watching the beauty found in nature and the satisfaction found on the faces of those using Sage Accpac Intelligence.
- How long have you been using the above solution?
- 6 years
- Where did you hear about us?
- Alchemex Site
Comment Wall (2 comments)
- 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
Follow Alchemex on twitter
Like Alchemex on facebook
© 2012 Created by Admin.
