• Bank Rec out of balance after Year end purge

    Good morning, Last weekend we ran the purge wizard to archive 20 years of data. It seems that we did not instruct the purge wizard to leave the unreconciled bank transactions. Now the bank recs from the purge date forward are out of balance by those…
  • 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…