Welcome to the Sage 100 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.
Just a PSA- Had a customer who users MS Query extensively reach out today to tell me that it seemed that the MS Query function seemed to have been removed. Fortunately it's racy to add it back.
Open Excel, select "File" from the toolbar, then "Options…
Hi All,
Need object reference & table name for Item Maintenance --> More --> Item Pricing Maintenance --> Customer Price Schedule --> Pricing Method --> Price Discount Amount to pull the discounted price by running the script.
I right clicked on the…
I have an excel spreadsheet that uses the SOTAMAS90 ODBC 64 Bit System DSN to update some data from our AP tables.
When I open this spreadsheet on the server with Sage 100 advanced installed the query completes and data is updated is less than 5 seconds…
I have seen some similar threads but none of them seem to work.
Here is my situation, and bear with me I am very green with ODBC connections:
I am wanting to connect to SOTAMAS90 through PowerBI gateway to get my data on a constant refresh. This would…
Probably a long shot here but whilst trying to import Sage data tables into the Power Pivot table wizard i get the following error:
'Object reference not set to an instance of an object'
Any thoughts?
Hello. We are having a bizarre issue with Microsoft Office 2016 and an ODBC connection to Sage 100 Advanced 2018 ERP. We use a system DSN to connect to Sage from Access to run queries and reports not available in Sage and have been doing this for years…
We use ODBC to connect to MS Access for several custom reports we use. After upgrading from Sage 100 Standard ver 2015 to 2017, ODBC connects to most files. However, when we try to connect to the AR Invoice History Header file it will display data correctly…
