Difference between revisions of "Updates"

From Executive Jeweller
Jump to navigation Jump to search
(Created page with "Updates are traditionally done as required throughout the year, with a major release yearly. See the release notes for details on what was changed. See Front End Updates for note...")
 
 
(10 intermediate revisions by the same user not shown)
Line 7: Line 7:
 
{|style="border-collapse: collapse; border-width: 1px; border-style: solid; border-color: #000"
 
{|style="border-collapse: collapse; border-width: 1px; border-style: solid; border-color: #000"
 
|-
 
|-
−
!style="border-style: solid; border-width: 1px"|Release
+
!style="border-style: solid; border-width: 1px; background-color:#eaefff"|Release
−
!style="border-style: solid; border-width: 1px"|Date
+
!style="border-style: solid; border-width: 1px; background-color:#eaefff"|Date
−
!style="border-style: solid; border-width: 1px"|Release Notes
+
!style="border-style: solid; border-width: 1px; background-color:#eaefff"|Release Notes
 
|-
 
|-
 
|style="border-style: solid; border-width: 1px"|08.01.00
 
|style="border-style: solid; border-width: 1px"|08.01.00
Line 113: Line 113:
 
|style="border-style: solid; border-width: 1px"|ExecMaintenance
 
|style="border-style: solid; border-width: 1px"|ExecMaintenance
 
|style="border-style: solid; border-width: 1px"|Jan/06/2010
 
|style="border-style: solid; border-width: 1px"|Jan/06/2010
−
|style="border-style: solid; border-width: 1px"|Added code to ExecutiveMaintenance to clear the RecordLock table during compact, to remove JB locks automatically.
+
|style="border-style: solid; border-width: 1px"|Added code to ExecutiveMaintenance to clear the RecordLock table during compact, to remove JB locks automatically. (Download here: [[File:ExecutiveMaintenance08.exe]])
 
|-
 
|-
 
|style="border-style: solid; border-width: 1px"|08.01.29
 
|style="border-style: solid; border-width: 1px"|08.01.29
Line 121: Line 121:
 
|style="border-style: solid; border-width: 1px"|08.01.29b
 
|style="border-style: solid; border-width: 1px"|08.01.29b
 
|style="border-style: solid; border-width: 1px"|Jan/20/2011
 
|style="border-style: solid; border-width: 1px"|Jan/20/2011
−
|style="border-style: solid; border-width: 1px"|Citizen306 Custom Tag - Remove 'B' on Line 3
+
|style="border-style: solid; border-width: 1px"|Citizen306 Custom Tag - Remove 'B' on Line 3 (Download here: [[File:ExecutiveFE-080129b-X.exe]])
 
|}
 
|}
 +
 +
2008 ToLocation Files are available for download here: [[File:2008ToLocationFiles.rar]])
  
 
===Executive Reports 2008 Changelog===
 
===Executive Reports 2008 Changelog===
 
{|style="border-collapse: collapse; border-width: 1px; border-style: solid; border-color: #000"
 
{|style="border-collapse: collapse; border-width: 1px; border-style: solid; border-color: #000"
 
|-
 
|-
−
!style="border-style: solid; border-width: 1px"|Release
+
!style="border-style: solid; border-width: 1px; background-color:#eaefff"|Release
−
!style="border-style: solid; border-width: 1px"|Date
+
!style="border-style: solid; border-width: 1px; background-color:#eaefff"|Date
−
!style="border-style: solid; border-width: 1px"|Release Notes
+
!style="border-style: solid; border-width: 1px; background-color:#eaefff"|Release Notes
 +
|-
 +
|style="border-style: solid; border-width: 1px"|08.01.00
 +
|style="border-style: solid; border-width: 1px"|Feb/29/2008
 +
|style="border-style: solid; border-width: 1px"|#189 - Sales Commission Report - Splits sales correctly when same employee is repeated within sale
 
|-
 
|-
−
|style="border-style: solid; border-width: 1px"|08.01.00 Feb/29/2008 #189 - Sales Commission Report - Splits sales correctly when same employee is repeated within sale
+
|style="border-style: solid; border-width: 1px"|08.01.01
 +
|style="border-style: solid; border-width: 1px"|Mar/06/2008
 +
|style="border-style: solid; border-width: 1px"|#194 - Stone MM Detail Transfer into Appraisal - Changed to 6x6x6 fields to match SKU fields #198 - Service Report vs Sales Report - Added filters to view regular Depts, Catagories, Groups as well
 
|-
 
|-
−
|style="border-style: solid; border-width: 1px"|08.01.01 Mar/06/2008 #194 - Stone MM Detail Transfer into Appraisal - Changed to 6x6x6 fields to match SKU fields #198 - Service Report vs Sales Report - Added filters to view regular Depts, Catagories, Groups as well
+
|style="border-style: solid; border-width: 1px"|08.01.02
 +
|style="border-style: solid; border-width: 1px"|Mar/18/2008
 +
|style="border-style: solid; border-width: 1px"|#204 - Gift Card/Certificate Payment On Account - Changed Reports for the Gift Cards
 
|-
 
|-
−
|style="border-style: solid; border-width: 1px"|08.01.02 Mar/18/2008 #204 - Gift Card/Certificate Payment On Account - Changed Reports for the Gift Cards
+
|style="border-style: solid; border-width: 1px"|08.01.05
 +
|style="border-style: solid; border-width: 1px"|Mar/25/2008
 +
|style="border-style: solid; border-width: 1px"|Moved image path to C:/Executive, addressed last 08 CEIS issues.
 
|-
 
|-
−
|style="border-style: solid; border-width: 1px"|08.01.05 Mar/25/2008 Moved image path to C:/Executive, addressed last 08 CEIS issues.
+
|style="border-style: solid; border-width: 1px"|08.01.07
 +
|style="border-style: solid; border-width: 1px"|Mar/28/2008
 +
|style="border-style: solid; border-width: 1px"|#207 - Inventory filter by cost added at request of SLJ #204 - GC on Account - Statements and Interest Invoices now work.
 
|-
 
|-
−
|style="border-style: solid; border-width: 1px"|08.01.07 Mar/28/2008 #207 - Inventory filter by cost added at request of SLJ #204 - GC on Account - Statements and Interest Invoices now work.
+
|style="border-style: solid; border-width: 1px"|08.01.08
 +
|style="border-style: solid; border-width: 1px"|Apr/16/2008
 +
|style="border-style: solid; border-width: 1px"|#211 - Days to Sell - Fastest Turnover vs Days to Sell
 
|-
 
|-
−
|style="border-style: solid; border-width: 1px"|08.01.08 Apr/16/2008 #211 - Days to Sell - Fastest Turnover vs Days to Sell
+
|style="border-style: solid; border-width: 1px"|08.01.09
 +
|style="border-style: solid; border-width: 1px"|Apr/22/2008
 +
|style="border-style: solid; border-width: 1px"|#212 - Customer Export - now exports spouse and contact information like Top Customer Export #213 - Customer List Spouse Name - Used to say First, Last
 
|-
 
|-
−
|style="border-style: solid; border-width: 1px"|08.01.09 Apr/22/2008 #212 - Customer Export - now exports spouse and contact information like Top Customer Export #213 - Customer List Spouse Name - Used to say First, Last
+
|style="border-style: solid; border-width: 1px"|08.01.10
 +
|style="border-style: solid; border-width: 1px"|Jul/02/2008
 +
|style="border-style: solid; border-width: 1px"|#215 - Customer Maintenance Date Report created #224 - Inventory Aging Reports have correct time frame headings and calculations now.
 
|-
 
|-
−
|style="border-style: solid; border-width: 1px"|08.01.10 Jul/02/2008 #215 - Customer Maintenance Date Report created #224 - Inventory Aging Reports have correct time frame headings and calculations now.
+
|style="border-style: solid; border-width: 1px"|08.01.13?
 +
|style="border-style: solid; border-width: 1px"|Nov/13/2008
 +
|style="border-style: solid; border-width: 1px"|Split Sales detail report with discount ranges
 
|-
 
|-
−
|style="border-style: solid; border-width: 1px"|08.01.13? Nov/13/2008 Split Sales detail report with discount ranges
+
|style="border-style: solid; border-width: 1px"|08.01.14
 +
|style="border-style: solid; border-width: 1px"|Nov/19/2008
 +
|style="border-style: solid; border-width: 1px"|Commissions detail report with discount ranges
 
|-
 
|-
−
|style="border-style: solid; border-width: 1px"|08.01.14 Nov/19/2008 Commissions detail report with discount ranges
+
|style="border-style: solid; border-width: 1px"|08.01.15
 +
|style="border-style: solid; border-width: 1px"|Apr/28/2009
 +
|style="border-style: solid; border-width: 1px"|Actual Sales Vs Budget Chart had issues with the leap year, so updated to compensate for leap years.
 
|-
 
|-
−
|style="border-style: solid; border-width: 1px"|08.01.15 Apr/28/2009 Actual Sales Vs Budget Chart had issues with the leap year, so updated to compensate for leap years.
+
|style="border-style: solid; border-width: 1px"|08.01.16
 +
|style="border-style: solid; border-width: 1px"|Feb/26/2013
 +
|style="border-style: solid; border-width: 1px"|GMROI Reports were all miscalculating Turns/Year where ItemCount was not 1. Fixed Calculations plus 'Marign' Misspelling.  
 
|}
 
|}
  
Line 157: Line 185:
 
{|style="border-collapse: collapse; border-width: 1px; border-style: solid; border-color: #000"
 
{|style="border-collapse: collapse; border-width: 1px; border-style: solid; border-color: #000"
 
|-
 
|-
−
!style="border-style: solid; border-width: 1px"|Release
+
!style="border-style: solid; border-width: 1px; background-color:#eaefff"|Release
−
!style="border-style: solid; border-width: 1px"|Date
+
!style="border-style: solid; border-width: 1px; background-color:#eaefff"|Date
−
!style="border-style: solid; border-width: 1px"|Release Notes
+
!style="border-style: solid; border-width: 1px; background-color:#eaefff"|Release Notes
 
|-
 
|-
 
|style="border-style: solid; border-width: 1px"|1.0
 
|style="border-style: solid; border-width: 1px"|1.0
Line 184: Line 212:
 
{|style="border-collapse: collapse; border-width: 1px; border-style: solid; border-color: #000"
 
{|style="border-collapse: collapse; border-width: 1px; border-style: solid; border-color: #000"
 
|-
 
|-
−
!style="border-style: solid; border-width: 1px"|Release
+
!style="border-style: solid; border-width: 1px; background-color:#eaefff"|Release
−
!style="border-style: solid; border-width: 1px"|Date
+
!style="border-style: solid; border-width: 1px; background-color:#eaefff"|Date
−
!style="border-style: solid; border-width: 1px"|Release Notes
+
!style="border-style: solid; border-width: 1px; background-color:#eaefff"|Release Notes
 
|-
 
|-
 
|style="border-style: solid; border-width: 1px"|07.01.00
 
|style="border-style: solid; border-width: 1px"|07.01.00
Line 224: Line 252:
 
|style="border-style: solid; border-width: 1px"|Mar/14/2008
 
|style="border-style: solid; border-width: 1px"|Mar/14/2008
 
|style="border-style: solid; border-width: 1px"|Fine Tuning the Citizen 304 WIN Printer Driver - Top Right tag vertical alignment issues
 
|style="border-style: solid; border-width: 1px"|Fine Tuning the Citizen 304 WIN Printer Driver - Top Right tag vertical alignment issues
 +
|-
 +
|style="border-style: solid; border-width: 1px"|07.01.17.2
 +
|style="border-style: solid; border-width: 1px"|Feb/6/2012
 +
|style="border-style: solid; border-width: 1px"|PD - Change TLP2844 EXE darkness from D7 to D15
 
|-
 
|-
 
|style="border-style: solid; border-width: 1px"|07.01.18
 
|style="border-style: solid; border-width: 1px"|07.01.18
Line 232: Line 264:
 
|style="border-style: solid; border-width: 1px"|Dec/17/2009
 
|style="border-style: solid; border-width: 1px"|Dec/17/2009
 
|style="border-style: solid; border-width: 1px"|Job Bag Instructions now shows disclaimers and has an extra row for Item Description
 
|style="border-style: solid; border-width: 1px"|Job Bag Instructions now shows disclaimers and has an extra row for Item Description
 +
|-
 +
|style="border-style: solid; border-width: 1px"|07.01.19
 +
|style="border-style: solid; border-width: 1px"|Nov/20/2009
 +
|style="border-style: solid; border-width: 1px"|Added 08 Tag Printing Code to 07 version to fix WIN print issue.
 
|}
 
|}
  
Line 237: Line 273:
 
{|style="border-collapse: collapse; border-width: 1px; border-style: solid; border-color: #000"
 
{|style="border-collapse: collapse; border-width: 1px; border-style: solid; border-color: #000"
 
|-
 
|-
−
!style="border-style: solid; border-width: 1px"|Release
+
!style="border-style: solid; border-width: 1px; background-color:#eaefff"|Release
−
!style="border-style: solid; border-width: 1px"|Date
+
!style="border-style: solid; border-width: 1px; background-color:#eaefff"|Date
−
!style="border-style: solid; border-width: 1px"|Release Notes
+
!style="border-style: solid; border-width: 1px; background-color:#eaefff"|Release Notes
 
|-
 
|-
 
|style="border-style: solid; border-width: 1px"|07.01.00
 
|style="border-style: solid; border-width: 1px"|07.01.00
Line 265: Line 301:
 
|style="border-style: solid; border-width: 1px"|Customer Sales Summary Report is now Exportable
 
|style="border-style: solid; border-width: 1px"|Customer Sales Summary Report is now Exportable
 
|}
 
|}
 +
 +
[[Category:Versions]]

Latest revision as of 12:24, 26 February 2013

Updates are traditionally done as required throughout the year, with a major release yearly. See the release notes for details on what was changed. See Front End Updates for notes on how to perform updates.

2008 Version

2008 Release Notes has a listing of new features at the time of release, but is less complete than the changelog.

Executive 2008 Changelog

Release Date Release Notes
08.01.00 Feb/29/2008 #188 - Sale Slowness - Sped up the populating of the top left corner fields in the Sales Screen #200 - Wrong Labelling on the PO Receive Screen fixed #173 - ServiceDetailStone MM field - Changed field to 6x6x6 in the Appraisal screen, to match previous change of SKU stone field to 6x6x6 from 4x4x4
08.01.01 Mar/03/2008 Tested on 08.01.02 instead, already had next FE
08.01.02 Mar/06/2008 #190 - Email Appraisals, Invoices - attaches w/ Snapshot file, recipient must download viewer from Microsoft #193 - Auto Reconcile Clear All button is password protected, default is 'password' #199 - Special Order Reminder - Reminds if a customer has the item on a SO - Works with multiple items, finishes SO when last item is sold. #201 - Supplier Code Change Exporting - Exporting from main store now tracks their Supplier Code SKU changes, all stores are the same now
08.01.03 Mar/18/2008 #196 - Half Copy Receipts - Invoice, Account Payment, Account Payment Receipt
08.01.04 Mar/24/2008 Changes to address a few remaining issues, finished for 08.01.05
08.01.05 Mar/25/2008 Moved image path to C:/Executive, addressed last 08 CEIS issues.
08.01.08 Mar/31/2008 #204 - GC on Account - Statements and Interest Invoices now work.
08.01.09 Apr/01/2008 #208 - Retail Replacement Function of - Added word Certificate #209 - Stock Item JB - Now adds Materials + Labour into Average cost in SKU #210 - Layaways turn into sales on same day
08.01.10 Apr/16/2008 #185 - JB Lock - Finishing Locking it from all fields - works now
08.01.11 Apr/22/2008 RB Half Page Invoice - Fixed deposit used on Invoice bug
08.01.12 Apr/25/2008 Trying to fix Barcode not Scanning, adding SKU to see if that will work.
08.01.13 Apr/29/2008 Barcode for WIN tags back to regular one, this stable version was upgraded to Knar today.
08.01.14 May/20/2008 Fix Job Bag Creation Glitch discovered by JUB
08.01.15 Jul/02/2008 #217 - Appraisal Description - JB Stones Field - Auto Generator button fixed #218 - Retail Replacement - Appraiser Certification code is now properly included. #220 - JB Lock is now working on the bottom half as well as top when locked. #223 - Customer Job Bag Return Error 3075 fixed
08.01.16 Jul/22/2008 Zebra tags were not able to be shifted for alignment because of introduction of new custom tags
08.01.17 Jul/23/2008 Zebra tags alignment changed, works sometimes but not all the time. WIN Tags barcode now works and is scannable. HFJ 1/2 page horizontal tags are finished. Choosable under option HALF 2, and in Receipt Copies.
08.01.18 Aug/27/2008 HFJ 1/2 page service receipt done. Watch repair disclaimer fixed.
08.01.21 Oct/27/2008 Home phone and Cell numbers on Sales and Repair Half Page Receipts Repair Estimate on the Half Page Service Receipt
08.01.22 Nov/03/2008 Widen SKU field on Memorandum Printout. Widen Style # Field on PO Printout to at least 15 chars.
08.01.23 Dec/01/2008 Job Bag Stone tab Appraisal Description Auto Generator. Invoice Description and Confidential Notes areas of the Job Bag screen to be editable via double click when the Job Bag is finished
08.01.24 Jan/14/2008 Transfers were using ReportsLocation instead of Location in setup file.
08.01.25 Feb/11/2008 Citizen2 EXE Code for tag printing
08.01.26 Feb/20/2009 Removed TEXT83 from Gift Receipts
08.01.27 Apr/28/2009 Citizen 304 EXE and Citizen2 Tag Printing was cutting off some characters in the supplier code of the barcode, so fixed the Citizen 304 and Citizen2 EXE code.
08.01.28 Jul/02/2009 'Error #3399. Cannot perform cascading operation. It would result in a duplicate key in table' during imports, modified import process.
ExecMaintenance Jan/06/2010 Added code to ExecutiveMaintenance to clear the RecordLock table during compact, to remove JB locks automatically. (Download here: File:ExecutiveMaintenance08.exe)
08.01.29 Aug/06/2010 Special Orders checking off PST/GST even though they are inactive. Causing issues when using discount calculator.
08.01.29b Jan/20/2011 Citizen306 Custom Tag - Remove 'B' on Line 3 (Download here: File:ExecutiveFE-080129b-X.exe)

2008 ToLocation Files are available for download here: File:2008ToLocationFiles.rar)

Executive Reports 2008 Changelog

Release Date Release Notes
08.01.00 Feb/29/2008 #189 - Sales Commission Report - Splits sales correctly when same employee is repeated within sale
08.01.01 Mar/06/2008 #194 - Stone MM Detail Transfer into Appraisal - Changed to 6x6x6 fields to match SKU fields #198 - Service Report vs Sales Report - Added filters to view regular Depts, Catagories, Groups as well
08.01.02 Mar/18/2008 #204 - Gift Card/Certificate Payment On Account - Changed Reports for the Gift Cards
08.01.05 Mar/25/2008 Moved image path to C:/Executive, addressed last 08 CEIS issues.
08.01.07 Mar/28/2008 #207 - Inventory filter by cost added at request of SLJ #204 - GC on Account - Statements and Interest Invoices now work.
08.01.08 Apr/16/2008 #211 - Days to Sell - Fastest Turnover vs Days to Sell
08.01.09 Apr/22/2008 #212 - Customer Export - now exports spouse and contact information like Top Customer Export #213 - Customer List Spouse Name - Used to say First, Last
08.01.10 Jul/02/2008 #215 - Customer Maintenance Date Report created #224 - Inventory Aging Reports have correct time frame headings and calculations now.
08.01.13? Nov/13/2008 Split Sales detail report with discount ranges
08.01.14 Nov/19/2008 Commissions detail report with discount ranges
08.01.15 Apr/28/2009 Actual Sales Vs Budget Chart had issues with the leap year, so updated to compensate for leap years.
08.01.16 Feb/26/2013 GMROI Reports were all miscalculating Turns/Year where ItemCount was not 1. Fixed Calculations plus 'Marign' Misspelling.

Executive HST Update Utility Changelog

Release Date Release Notes
1.0 Jun/28/2010 HST Updater Initial Release. Updates GST to HST on Products, shows PST/GST Exemptions.
2.0 Jul/17/2010 Added Special Order Update, HST Exemptions on Report
3.0 Jul/18/2010 Separated Special Order Update from the Product Update, would have caused Products to be incorrectly updated if entered since HST activated.
4.0 Jul/19/2010 Removed option to update Products, so that only Special Orders can be done. Interface was a bit confusing so did this to avoid user errors with the Product Update Apply button.

2007 Version

2007 Release Notes has a listing of new features at the time of release, but is less complete than the changelog.

Executive 2007 Changelog

Release Date Release Notes
07.01.00 Jan/01/2007 Initial Release of 2007 Version
07.01.07 Nov/14/2007 #137&148 - Remove Errors when Deleting Inventory Used in JB #136 - Layaway Exchanges O/L levels fixed #135 - Special Order Find Filter Added #132 - Don't Allow transfers from Guelph to Guelph to be entered #123 - Margins in Retail Replacement fixed

07.01.08

Dec/04/2007 #149 - Stock Items now create Inventory Item Details properly #138 - Insurance Quote no longer Deletes when you leave
07.01.09 Dec/18/2007 #157 - Universal Product Changer - Added filters for In Stock and O/H #158 - Change misspelled word in Job Bag Error Message #153 - Service Printout in the Job Bag Section now includes Materials and Findings costs, and Supplier Price and Cost #151 - Postal Code Mask #145 - Find Inventory - Added Location Filter #143 - Made Citizen WIN 306 Font Bigger
07.01.13 Feb/07/2008 #167 - Customer Type cannot be blank #170 - Cannot receive null values on PO #173 - ServiceDetailStone MM field - Field requires data change but for time being we trap error and give the user a nicer error message. Plus it is now able to complete attaching images and stone details where as before it would stop. #176 - Autoreconcile margins are now all .5 #183 - Phone Find on Customer Find screen now searches Spouse Work and Mobile number as well. It has also been altered to allow partial phone numbers to be entered.
07.01.14 Feb/22/2008 Password Protect Product Location Field, works for multiple locations now
07.01.15 Feb/28/2008 #202 - Job Bag Finishing Error Fixed - Will not add 1 to Inventory Used when Finished/Unfinished
07.01.16 Mar/06/2008 Changed WIN Driver Printer Font from Arial to Times New Roman - to Fix 5's and 6's looking the same
07.01.17 Mar/14/2008 Fine Tuning the Citizen 304 WIN Printer Driver - Top Right tag vertical alignment issues
07.01.17.2 Feb/6/2012 PD - Change TLP2844 EXE darkness from D7 to D15
07.01.18 Apr/10/2008 EXE 306 Tag - SKU enlarged, moved up barcode. Scans properly
07.01.18 - DB Dec/17/2009 Job Bag Instructions now shows disclaimers and has an extra row for Item Description
07.01.19 Nov/20/2009 Added 08 Tag Printing Code to 07 version to fix WIN print issue.

Executive Reports 2007 Changelog

Release Date Release Notes
07.01.00 Jan/01/2007 Initial Release of 2007 Version
07.01.07 Nov/14/2007 #131 - Service Reports - added filters for Cancelled? and No Charge?
07.01.09 Dec/18/2007 #160 - Top Customer Report Export All Phone/Mail info #140 - Customer Spouse Gender added in Reports
07.01.10 Feb/07/2008 #159 - Spouse Information added to Sales Export #162 - Price Point update process improved and now mandatory when form closes as well as when AVG OH is generated #166 - Filter service reports by Finished Date #172 - GMROI - added option to display or hide items without departments #174 - Inventory used report opened too large...now opens to maximized state. #178 - Ordered the Customer Event report by LastName, FirstName
07.01.11 Feb/12/2008 #172 - GMROI - New 'display items without depts filter works properly' now. #174 - Inventory Used Report now has Header and Footer.
07.01.12 Mar/06/2008 Customer Sales Summary Report is now Exportable
Retrieved from "http://executivejeweller.info/index.php?title=Updates&oldid=474"