Browse By Tags

  • 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…
  • General ODBC Errors (Pass Through Queries) in Access 2016

    Hi all; I've been having some serious difficulty finding an answer to this issue, which has led me to create my first post here. I have an access database that pulls tables from all companies by use of pass through queries. Connection strings are handled…
  • 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…