Welcome to the Sage 300 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
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…
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
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…