Browse By Tags

  • Can we get the ODBC Connection info for Firebird for 2019?

    FormerMember
    FormerMember
    Hi, We're trying to re-write a series of reports that we had in the Paradox version, that delivers info via Excel. We were planning on using a ODBC connection (unless someone can suggest something better). We're looking for the database account…
  • 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…
  • 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…