• SOTAMAS 90 & Power Pivot Error

    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?
  • Access 2016 ODBC / Sage Issue

    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…
  • Check status of VI Job (Sage MAS 100)

    Questions: 1. How to check status completion of VI Job? (see picture 1) 1. What Sage MAS 100 table and field should we use to determine VI Job status using ODBC? 2. Is there other way to run VI Job without using PVXWIN32.EXE? The problem description…
  • Access to data of Payroll and Job Cost tables via ODBC for Sage 100 Standard 2018

    Questions: 1. Is there any option (bypass) for access to Job Cost tables via ODBC driver? 2. Is there any option (bypass) to decrypt employee encrypted data from external app? 3. Which of tools are recommended for reading data from Sage Mas 100 in replace…