x Want to participate? Join the group to interact

  • Create company parameter for Intelligence report template used across multiple databases

    We have a client that has several hundred companies in Sage 100. They have a report template that they would like to run individually on each of these companies. The customer owns the Connector module. Using the standard Autoconnect connection in…

  • is there a way to not only hide the data but lock it as well?

    I don't want the users to have access to the actual data tab. any way to lock it?

  • Sage Intelligence Connector - Adding a duplicate or alias table

    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…

  • Multiple Reporting Tree Selections

    I am trying to create a departmental report with a selection option for division. GL Structure is Main-Div-Dept Client would like a drop down to select the Division and the columns would be the departments Option 1: Have a tree with each division…

  • sql formula add business days

    What would the sql statement be to add 3 business days to the Sales Order Delivery Date? There is probably a shorter version but I got this to work. CASE WHEN DATEPART(day,SO_SalesOrderHeader.ShipExpireDate)=1 then DATEADD(day,3,SO_SalesOrderHeader…

*Community Hub is the new name for Sage City