Sage 300

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…

In a couple of days, we'll be releasing our next installment of the Sally Series, this time focusing on the Connector module and how to define your own data sets for your reports. If you haven't yet checked out the first and second series then why not…

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…

I wish to create a AP aging dashboard in the Intelligence Reporting module. The issue is the table "APAGED" is only populated when the A/P aging report is run for all vendors. Hence if the report was run for one vendor that is what you will get when…

Hi, We have an existing client actively using Sage Intelligence and they have 2 users who creates containers and reports. What happen is: User A create a Sales report using container Sales (Container number #123) using table ARCUS and OESHDT Subsequently…