• Object Reference & Table name for Customer Price Schedule --> Pricing Method --> Price Discount Amount

    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…
  • Job Cost Detail History tied to General Ledger Detail

    I have a client who is migrating from Sage 100 4.5 to Sage Intacct. I'm trying to take Job Cost lines posted to the GL and break out (tag) the summary lines by job number and cost code (dimensions). But when I look at the JC tables such as JC Transaction…
  • 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…
  • 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…