x Want to participate? Join the group to interact

  • sql drop leading zeros in SO number

    can someone tell me a sql formula to use in a Sales Order container to drop the leading zeros. I need to match / index to files where the sales order number is entered without the leading zeros.

  • Pass through variable "Last full month"

    What is the sql statement needed to get the last full month for a pass-through variable. Scenario is: On the 10th of the month, produce a GL detail report for all activity posted in the prior month. As always thanks in advance for your assistance…

  • 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…

  • Microsoft Excel is waiting for another application to complete an OLE action

    I'm suddenly getting this error and the only thing that stops it is a reboot. Microsoft Excel is waiting for another application to complete an OLE action Running Sage 100 Advanced on Windows 2019 Server & Excel Standard 2016

  • Sage 100 2019 Sage Intelligence. Company name or code for multi-company reports.

    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…

  • 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…

  • Payroll Data Missing in Microsoft Query Sage Intelligence 100

    I am pulling from the table used in the PR_EarningsReport but not all fields are being populated in my query. For example, I can get Employee Number but not First and Last Name?

  • Is there a way to pull data from a specific source code, like AP or AR?

    We are looking for a way to separate our YE AJE's. It was suggested to us to use a source code named AJ. We'd like to create a set of financials that shows the unadjusted trial balance, then the AJE's, and then the final balances. So, my question is…

  • 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…

  • Creating a custom report incorporating Customer Maintenance and Item Maintenance info

    Hello, I am trying to create a custom report that would show customer details relating to items sold. I am looking to include: Customer Name and associated purchase history of a given item #, item description, standard cost, standard price,…

*Community Hub is the new name for Sage City