July 21, 2006 (Service Pack 8) Corrected "Invalid variant type conversion." issue for querys with dates run in Edit Details Updated Crpe32.dll to provide Export to Adobe format from Crystal Reports run from Sales Analysis Final Build March 24, 2006 (Service Pack 7) Corrected issue with displaying wrong description for "Customer Group", "Billing Cycle" and "Tax Group" in AR Document Inquiry Customer tab Corrected issue with some controls being editable on AR Document Inquiry Problem connecting to the database using a trusted connection (SSPI - Windows Authentication vs MS-SQL authentication) November 4, 2005 (Service Pack 6) Corrected issue with Drilling to Ops Inquiry and AR Inquiry programs as opposed to Sales Analysis programs when double clicking on Document Number field in Sales Analysis Inquiry and Report Corrected error "Divide by zero error encountered" when running Sales by Salesperson query and summarizing on Customer name Corrected issue with finding Item Numbers with leading spaces in Inquiry and Report July 8, 2005 (Service Pack 5) Corrected conversion routine for UXARINVH table to add SRCEAPPL field Corrected retrieve function for AR Documents after conversion June 16, 2005 (Service Pack 4) Corrected retrieval of historical information caused by inconsistency in the field order. Reported error,"Insert Error: Column name or number of supplied values does not match table definition". Corrected error "incorrect syntax near ','" in Consolidate Detail June 3, 2005 (Service Pack 3) Removed debug timing message Corrected case sensitive issue with Document Number field in Retrieve Retrieve function - check existing records changed April 29, 2005 (Service Pack 2) Corrected issue with generating "Incorrect Syntax near )" when running Import program on an empty UXDETAIL table Corrected error message "599 Cannot open SQL server" when user tries to open any of the Crystal reports from the Inquiry and Report Engine Corrected issue with Optional Fields being editable by user March 11, 2005 (Service Pack 1) Corrected issue of getting data from OE tables (as opposed to UX tables) while displaying data in Invoice and Credit Note Inquiries