Sage 100

Having trouble with a server-mounted, On-Premises Gateway communicating with my silent ODBC for Sage 100 access. On-Premises Gateway successfully installed on my server (also the Sage server), and my published Power BI semantic model recognizes it.…

Hi, I have the basic Sage cloud but on downloding the audit trail to Excel, I thought there must be some ODBC drive to pull the data into Excel, where can this be found, or is the system so simple that it does not exist?

Can you use the connector module to connect your Sage 100 ERP to an excel spreadsheet and match up the invoice number from Sage 100 to a column in the spreadsheet called invoice number for example? (sage 100 std v2018)

We have Sage 100c 2019. We use Sage Intelligence that sends reports via Windows Task Scheduler to Power BI Desktop. We use Power BI Cloud that pulls the data. This has been working successfully for a long time. I am testing a DIRECT connection between…

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?

why is the container importing my excel file with blank (NULL) values for items with alpha numeric labels? additionally the columns have switched order? Excel Output Connector Module Sample Run Original Excel FIle Import

The SO_SalesOrderDetail has just about every field I need except the customer number. What other table can I use to link them and report this field in Sage Intelligence 100? I am using Microsoft Query.

I have a client that is basically holding company, several companies, each with their own Sage server. They are wanting to do consolidated reporting in Sage Intelligence, for all companies. Can this be done? If so, how?

Hello, I am new to Sage and the usage of ODBC. I am able to run through the step in Excel (Get Data -> From Other Source -> Microsoft Query -> Pick my database -> I choose "GL_TrialBalanceWrk" -> select all with no filters) everything runs smoothly and…

Hi All, I am struggling with this issue. Everything I read says it should work this way but it does not. Client is on Sage 2017 Standard. I created a report that uses a silent connection. It is 64bit and I have set it up as a System DSN. Works fine…

We are having a problem with report totals doubling because the 'Mas90 4.0 ODBC Driver' driver keeps showing up as one of the connection types. Example - The Tenant Viewer looks similar to the following listings - TENANT, CONNECTION TYPE, DB SERVER…

I have not had any success making any graphical joins as I am getting system.outofmemoryexception Here's an example of one of my Join SQL's: ("IM_ItemCost" INNER JOIN "IM_ItemWarehouse" ON "IM_ItemCost"."WarehouseCode" = "IM_ItemWarehouse"."WarehouseCode…

I made the following graphical join to get invoice amounts by customer for certain invoice dates like 9/1/2017 to 9/30/2017. Graphical Join and Timeout Error I tried to load the report in manager and I had to cancel it at around 65 minutes...it was…

HI There, When I was at Sage Summit I was told that I could find a list of Table Connectors on Sage City, does anyone know where to find this report? I'm trying to find what connectors match up so that I can run an A/P report with some general ledger…

Basically, I am trying to pull data out of Sage 100 ERP in to Qlik Sense for reports, as well as Excel. I use the builtin 32-bit ODBC User Connection. I am able to connect to the Sage database. It prompts me for credentials - I am an Admin, it connects…

Can someone provide assistance with - accessing Sage 100 ERP tables via Excel PowerPivot? Note the error/failure from screen image above.