I Have a Consolidation Report with last 20 years financial data and I want to create a filter so that the report only returns last 5 years of data, I tried including system parameters to the standard report 'Fiscal Year' First but whenever I run that…
Trying to return the corresponding itemno for a given icitem.altset #.
Normally, I'd just write a SQL statement such as:
select [icitem].[itemno] from [icitem] where [icitem].[altset]
but, alset is an integer, and I can't find a column in icitem…
Sage 100 2019 Sage Intelligence. How do I add company code from the SYO_Company table to my joins? In Crystal we would use "Not Equal" as a join for company name. In SI, Connector, there is only Right Join, Inner, and Outer. How do I get the company name…
I am creating a GL Detail report (GL_DETAILPOSTING) and need to have the fiscal year and fiscal period columns added to the report. What table do I use to join?
I am developing a new Sage Intelligence Report for a client and I had to create a new container. I know how to export and import the report. How do I transfer the required container?
TIA
Sage 2019
I created a Data Container. I added a table and would like to add an alias of the same table with a left join.
When I attempt to add the table, a message informs me the table has already been added. In Crystal or Access, I am allowed…
We are working on a project where we have installed Sage 300 Intelligence Reporting module. The session date is showing correct format of regional date setting (e.g. South Korea). Also, all transaction screens show correct date format (e.g. YYYY-MM-DD…
Hi,
i get this error when open BI Report Manager
I'm on Sage 2014 PU3
"The function GetDataValue can only service SQL calls that result in a single return value. Please modify the SQL statment accordingly. The SQL statment supplied was : -
SELECT…