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…

  • Getting the below error in BW Sage 2015

    I did some searching on your site and see that KB 39468 may assist in resolving this issue but cannot locate where your KB's are stored. And, if someone has insight into this error, please advise. Is this a firewall error or possible port issue?

  • Sage 300 Construction PO's

    I use a lot of queries to grab data out of Sage. I have and use the PO/Commitments application. Can someone tell me what table or where the table is to look at data there? I can only find data in the Job after the PO has been committed and sent to Job…

  • Connecting to Audit Trail .DAT using SQL?

    I have been using SQL Server to connect to my .DATs without issue and today tried connecting to the AUDITTR.DAT but am getting the message that the object does does not exist. I am certain this isn't a typo or something simple like that, so I'm wondering…

  • 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…

  • Sage 100c 2016 Unified Login SQL Linked Server Issue

    We have a client that is having a very strange issue with ODBC drivers when we try to setup a linked server in SQL. No matter what we try we get an error that seems to suggest that the login is failing but ONLY when we try to access it from SQL. Using…

  • 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…

  • MAS 90 Data Access Problems with ODBC

    MAS 90 version = 4.30.0.23 ProvideX driver version = 4.21.1000 I am attempting to query MAS 90 data using the ProvideX ODCB driver. My queries are running, but no data is returned. 1) MAS 90 has been set up with a role that gives me read access to all…

  • ODBC connection failing

    I am trying to connect to the Sage 50 database using ODBC/My SQL connection. In MySQL Connector/ODBC, I enter Sage username and password, , I select TCP/IP Server : localhost (database is local on this computer), I leave the port to default (13540), and…

*Community Hub is the new name for Sage City