• 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…
  • Getting A Vault GUID

    FormerMember
    FormerMember
    We are using Sage50 with Sage Exchange for CC Processing. I assume Sage Exchange uses the Vault to store the CC#'s offsite. As such I assume that the Vault GUID is stored back into Sage50 somewhere. Where would that be and can I get access to it? (I suspect…
  • Pervasive PSQL v11 - Number of users connected with Sage50 and third party software

    How many users have pervasive with Sage50 ? I noticed that pervasive shows a message that reached a maximum number of users when use third party software. I have Sage50 5 users and others third party software connected via SDK and ODBC. f