Browse By Tags

  • 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…
  • Sage 300 - sql query for recalculating AP Balances - reconciling to GL

    Hi, I am trying to determine why my GL and AP control accounts dont balance. Yes, I know I can isolate GL only transactions from my control account, but I would like to build a more robust answer. To this end, I would like to build a query in sql…
  • Accessing Sage 100 Contractor 2016 Database with Microsoft Access 2010

    How can the Sage 100 Contractor 2016 (version 20.4.51.0 or greater) databases be accessed using Microsoft Access 2010? I would like to link to the data source by creating a linked table. To do this I have created a Machine Data Source using ODBC in…
  • Sample ODBC/SQL queries for getting Sales Order information, Customer Information, and inventory information?

    Can anyone offer any sample SQL scripts for getting information, such as Customer Information (given a customer ID), sales order information (given a sales order number or customer ID), and/or inventory information (given an Item ID) out of the database…