Louay Al-Tahan
  • Male
  • Baghdad
  • Iraq
Share

Louay Al-Tahan's Discussions

Report Designer license required
2 Replies

Hello,I recently switched to excel 64 due to memory issues when running SI reports. Now I am getting "Report Designer License Required". We have Sage 300 ERP 2017.Can someone help Please?LouayContinue

Started this discussion. Last reply by Louay Al-Tahan Feb 8.

Creating Join in a new container returning error
3 Replies

HelloI am trying to create a new container using JOIN((([ICASEN] INNER JOIN [ICASCST] ON [ICASEN].[ASSMENSEQ] = [ICASCST].[ASSMENSEQ]) INNER JOIN [ICUNIT] ON [ICASEN].[ITEMNO] = [ICUNIT].[ITEMNO] AND…Continue

Tags: CONTAINERS

Started this discussion. Last reply by Louay Al-Tahan Dec 1, 2017.

Report Designer Add In
4 Replies

Hello,I need help from more experienced users. I am using the Report designer Add In for the first time and having problems:Does the Actual Formula return the actual change in a period? Or the actual…Continue

Tags: IN, Add, Designer, Report

Started this discussion. Last reply by Louay Al-Tahan Jul 13, 2015.

SQL LOGIN FAILED FOR USER XXXX
2 Replies

After upgrading to SAGE 300 ERP 2012, intelligence reporting stopped working giving me error "SQL LOGIN FAILED FOR USER XXXX". Searched the knowledge base and found an article that suggested changing…Continue

Started this discussion. Last reply by Louay Al-Tahan Apr 19, 2014.

 

Louay Al-Tahan's Page

Latest Activity

Louay Al-Tahan replied to Louay Al-Tahan's discussion Report Designer license required
"I did"
Feb 8
Jim Smith replied to Louay Al-Tahan's discussion Report Designer license required
"Have you run the BI workstation install after installing the 64 bit Excel?"
Feb 8
Louay Al-Tahan posted a discussion

Report Designer license required

Hello,I recently switched to excel 64 due to memory issues when running SI reports. Now I am getting "Report Designer License Required". We have Sage 300 ERP 2017.Can someone help Please?LouaySee More
Feb 8
Louay Al-Tahan replied to Louay Al-Tahan's discussion Creating Join in a new container returning error
"Thank you for your help. Using SQL profiler, I noticed that the Container Module is adding AND to the end of the query. I removed the outermost brackets and it worked, I appreciate your support."
Dec 1, 2017
Shwu Hua Gan replied to Louay Al-Tahan's discussion Creating Join in a new container returning error
"Hi, Try this. ((([ICASEN]INNER JOIN [ICASCST]ON [ICASEN].[ASSMENSEQ] = [ICASCST].[ASSMENSEQ])INNER JOIN [ICUNIT]ON [ICASEN].[ITEMNO] = [ICUNIT].[ITEMNO] AND [ICASEN].[UNIT] = [ICUNIT].[UNIT])INNER JOIN ICASENO as P1 on…"
Dec 1, 2017
Louay Al-Tahan replied to Louay Al-Tahan's discussion Creating Join in a new container returning error
"Hello Again, An update on above. After further investigations and trials; I found that the problem is with the WHERE statement. If I remove it the error disappears. Is there something wrong in the SYNTAX?"
Nov 29, 2017
Louay Al-Tahan posted a discussion

Creating Join in a new container returning error

HelloI am trying to create a new container using JOIN((([ICASEN] INNER JOIN [ICASCST] ON [ICASEN].[ASSMENSEQ] = [ICASCST].[ASSMENSEQ]) INNER JOIN [ICUNIT] ON [ICASEN].[ITEMNO] = [ICUNIT].[ITEMNO] AND [ICASEN].[UNIT] = [ICUNIT].[UNIT]) INNER JOIN (SELECT [ICASENO].[ASSMENSEQ], VALUE AS MACHINEID FROM ICASENO WHERE OPTFIELD = 'MACHINEID') AS P1ON P1.[ASSMENSEQ] = [ICASEN].[ASSMENSEQ])When I execute the above I get a all records as expected.After the applying the JOIN to the container. When I…See More
Nov 29, 2017

Profile Information

Sage Intelligence powers the following Accounting/ERP/Payroll solutions, pick yours
Sage 300 ERP Intelligence Reporting (Formerly Accpac)
Website
http://www.nimaform.com
How long have you been using the above solution?
4 years
Where did you hear about us?
Sage Intelligence website

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