• 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…
  • Use indexes or server for speed

    I have been finding recently that on certain computers, Crystal Reports will give an error message if I don't uncheck the box “Use indexes or server for speed” in the Report Options. Unchecking this makes the report run much slower. At one client I…
  • Cannot open Sage - I did not run Year End Wizard / close year AND I clicked on last open period in Change period window

    Did I lock down the data set? Was trying to trigger launch of End of Year Wizard, it did not launch and I closed program because each time I open program it would prompt to run End of Year Wizard. This is only site I use Peachtree at - all other sites…