//------------------------------------------------------------ // v10.2.1 - released 18 Nov 2016 //------------------------------------------------------------ ConnectIt.exe v10.2.1 ConnectIt Configuration.exe v10.2.1 ADDED: ConnectIt Configuration | Documents tab | Purchase Documents tab | Main tab - 'Use QuoteWerks address for Sage Purchase Order Delivery Address' option with associated dropdown to select SoldTo, ShipTo or BillTo. UPDATED: Document Transfer - if the new ConnectIt Configuration | Documents tab | Purchase Documents tab | Main tab | 'Use QuoteWerks address for Sage Purchase Order Delivery Address' option is ticked, then apply the appropriate address details to the Purchase Order in Sage. //------------------------------------------------------------ // v10.2.0 - released 26 Oct 2016 //------------------------------------------------------------ ConnectIt.exe v10.2.0 ConnectIt Configuration.exe v10.2.0 ADDED: ConnectIt Configuration | Documents tab | Sales Documents tab | Main tab - 'Prompt and ask if ok for Customer On Hold' option. ADDED: ConnectIt Configuration | Documents tab | Sales Documents tab | Main tab - 'Prompt and ask if ok for duplicate Customer PO' option. UPDATED: Document Transfer - if the new ConnectIt Configuration | Documents tab | Sales Documents tab | Main tab | 'Prompt and ask if ok for Customer On Hold' option is ticked, then as part of the Customer Account checks if the Customer if flagged as being 'On Hold' in Sage 200 and this option is ticked in the Configuration prompt the User with a message to confirm that they wish to proceed. UPDATED: Document Transfer - if the new ConnectIt Configuration | Documents tab | Sales Documents tab | Main tab | 'Prompt and ask if ok for duplicate Customer PO' option is ticked, then if the QuoteWerks Document Customer PO reference is blank or has already been used on a document in Sage 200 prompt the User with a message to confirm that they wish to proceed. FIXED: Document Transfer - "Fatal Error adding a Free Text Item Line... to save this line you must enter a quantity greater than zero" message when creating a Sales Order Document in Sage 200. This would occur if there was a Discount Line Type on the QuoteWerks Document because the Quantity is zero on these Line Types. Now hard code Document Transfer to quantity of 1 for Discount Line Types. NOTE: not able to replicate the above fix for Pro Forma Invoices as negative unit selling prices are not supported so creating the Free Text Item Line fails. This is an issue which has been found in development and internal testing only; tackle this if/when it becomes an issue in a Users Live environment and see how they would like to address it. //------------------------------------------------------------ // v10.1.2 - released 11th April 2016 //------------------------------------------------------------ ConnectIt.exe v10.1.2 ConnectIt Configuration.exe v10.1.2 ADDED: Configuration | Documents tab | Sales Documents tab | Main tab 'Line Type' option with the existing “Transfer Shipping Cost…” options. this allows the User to select whether the Shipping Cost is created in Sage as a Charge Line Type (default) or Product Line Type. UPDATED: Document Transfer - if the new Configuration | Documents tab | Sales Documents tab | Main tab 'Line Type' option is set as "Product" then create the Shipping Cost as a Product Line Type, otherwise create it as a Charge Line Type. UPDATED: Installer - removed .net framework 2.0 pre-requisite from launch conditions. FIXED: Document Transfer - if just a Proforma Invoice is being created, then the Carriage Cost would not be added to the Sage 200 Document. This issue has now been corrected - a Charge or Product line will be added, as appropriate for the Configuration. //------------------------------------------------------------ // v10.1.1 - released 6th January 2016 //------------------------------------------------------------ ConnectIt.exe v10.1.1 FIXED: ConnectIt Document Transfer - &QWDI_ macro fields not working on Sales or Purchase Document Item Overrides. This was because Document Item macros were not being processed by ConnectIt; only Document Header macros were being processed for Document Item values. This issue has now been corrected - &QWDI_ macros are now processed for both Sales and Purchase Document Item Override values. //------------------------------------------------------------ // v10.1.0 - released 4th January 2016 //------------------------------------------------------------ ConnectIt.exe v10.1.0 ConnectIt Configuration.exe v10.1.0 ADDED: Configuration | Documents | Sales Documents | Document Header Overrides and Document Item Overrides tabs with fields for the User to enter Sage Field Names and Values plus whether to write to the field if the value to be written is blank. Note that Field Names, Values and Blanks should be separated by a pipe character ("|"). ADDED: Configuration | Documents | Purchase Documents | Document Header Overrides and Document Item Overrides tabs with fields for the User to enter Sage Field Names and Values plus whether to write to the field if the value to be written is blank. Note that Field Names, Values and Blanks should be separated by a pipe character ("|"). ADDED: ConnectIt Document Transfer - support for the new Document Header and Item Override fields. //------------------------------------------------------------ // v10.0.3 - released 9th October 2015 //------------------------------------------------------------ ConnectIt.exe v10.0.3 ConnectIt Configuration.exe v10.0.3 ADDED: Configuration | Advanced tab | Document Transfer tab | Sage 200 (Sales) tab - "Place Sales Document 'On Hold' in Sage 200 if Customer 'On Hold'" option to work alongside the existing "Transfer Sales Document even if the Customer is 'On Hold' in Sage 200" option. If the new "Place Sales Document 'On Hold' in Sage 200 if Customer 'On Hold'" is ticked, then the Sales Document is Sage 200 is placed 'On Hold'; previously it was left as 'Live'. ADDED: Configuration | Advanced tab | Document Transfer tab | Sage 200 (Sales) tab - "Do not Allocate Stock in Sage 200 even though option set in Sage 200" option so that ConnectIt will never allocate Stock on a Sales Order Document. ADDED: Configuration | Advanced tab | Document Transfer tab | Sage 200 (Purchase) tab - "Transfer Sales Document even if the Supplier is over their Credit Limit" option to suppress Sage "Supplier account balance has exceeded" error messages and create the Purchase Order document anyway. ADDED: Configuration | Advanced tab | Document Transfer tab | Sage 200 (Purchase) tab - "Place Purchase Document 'On Hold' in Sage 200 if Supplier is over Limit" option to work alongside the new "Transfer Purchase Document even if the Supplier is over their Credit Limit" option. If the new "Place Purchase Document 'On Hold' in Sage 200 if Supplier is over Limit" is ticked, then the Purchase Document is Sage 200 is placed 'On Hold' otherwise it is left as 'Live'. FIXED: ConnectIt Document Transfer: "Fatal Error creating Product Purchase Order... Unable to update the object... as the object has been deleted" error. This was when the Supplier had exceeded their Credit Limit. A more relevant error message is now displayed and we have added the 2 new Configuration | Advanced tab | Document Transfer tab | Sage 200 (Purchase) tab options (details above) to provide the User with options as to how ConnectIt should behave. //------------------------------------------------------------ // v10.0.2 - released 18th September 2015 //------------------------------------------------------------ ConnectIt.exe v10.0.2 FIXED: Additional Charge line not created when there is a Shipping Cost on the QuoteWerks Document. This was when creating a combination Sales Order & Purchase Order or Pro Forma Invoice & Purchase Order Documents in Sage. this issue has now been resolved. //------------------------------------------------------------ // v10.0.1 - released 11th August 2015 //------------------------------------------------------------ ConnectIt.exe v10.0.1 ConnectIt Configuration.exe v10.0.1 ConnectIt Create Supplier Wizard.exe v10.0.1 UPDATED: Configuration | Sage tab | Version - changed dropdown selection to 2015 instead of 2013. FIXED: ConnectIt | Document Transfer - "Object reference not set to an instance of an object" error when retrieving Suppier details from Sage during Purchase Order creation. This was due to the incorrect Supplier Account Reference being used when retrieving the details and has now been resolved. FIXED: ConnectIt Create Supplier Wizard - when starting up, ConnectIt could not 'see' QuoteWerks running. This was due to the Supplier Wizard compile options being set to 'Any CPU' instead of 'x86' and so would affect Users with a 64-bit operating system. This issue has now been resolved. //------------------------------------------------------------ // v10.0.0 - released 2nd June 2015 //------------------------------------------------------------ ConnectIt.exe v10.0.0 ConnectIt Configuration.exe v10.0.0 ConnectIt Create Customer Wizard.exe v10.0.0 ConnectIt Create Product Wizard.exe v10.0.0 ConnectIt Create Supplier Wizard.exe v10.0.0 ConnectIt Registration.exe v10.0.0 ConnectIt Registration Manager.exe v10.0.0 ADDED: support for Sage 200 2015 (v10.0) //------------------------------------------------------------ // v9.2.3 - released 18th May 2015 //------------------------------------------------------------ ConnectIt.exe v9.2.3 ConnectIt Configuration.exe v9.2.3 ConnectIt Create Customer Wizard.exe v9.2.3 ConnectIt Create Product Wizard.exe v9.2.3 ADDED: Configuration | Advanced tab | Wizards tab | Customer tab | 'Auto-generate a Customer Account Reference when using the Create SoldTo / ShipTo / BillTo features' and Account Ref. Prefix, Format and Seed values - these settings are used for auto-generating a new Customer Code when using the Create Customer Wizard. ADDED: Customer Wizard - an option to retrieve the next available Customer Account Reference value based on the required Prefix, Format and Seed in the Configuration. ADDED: Configuration | Advanced tab | Wizards tab | Product tab | Tax Code (Y/N) options - these settings define the Tax Code which would be used in Sage 200 if the Product is Taxable = "Y" and Taxable = "N". UPDATED: Customer Wizard - if the 'Auto-generate a Customer Account Reference when using the Create SoldTo / ShipTo / BillTo features' is ticked in the Configuration, then calculate the next available Account Reference based on the required Prefix, Format and Seed. UPDATED: Product Wizard - added support for using the QuoteWerks Document Items Taxable Y/N field as a different value depending on whether it is set to Y or N. UPDATED: Product Wizard - added support for using the QuoteWerks Document Items CustomMemo01 field (&QWDH_CustomMemo01) as an Override field for Sage 200 Stock Item Description field (Description). //------------------------------------------------------------ // v9.2.2 - released 8th April 2015 //------------------------------------------------------------ ConnectIt Create Product Wizard.exe v9.2.2 FIXED: Product Wizard - when using the 'Create All' feature a "conversion from string to type integer" error occurred. This could happen if either 1) the specified Vendor does not exist in the QuoteWerks database, or 2) the Vendor was left blank on the QuoteWerks Document. This issue is now resolved - if the Vendor is blank or not in the QuoteWerks Vendor database, then the ConnectIt Product Wizard carries on without retrieving Vendor details. //------------------------------------------------------------ // v9.2.1 - released 23rd March 2015 //------------------------------------------------------------ ConnectIt Configuration.exe v9.2.1 ConnectIt Create Product Wizard.exe v9.2.1 ADDED: Configuration | Advanced | Wizards | Products tab - options to enter the Warehouse Code and Bin values. UPDATED: Product Wizard - Warehouse dropdown now just displays the Warehouse Code and not the Warehouse Code and Name. UPDATED: Product Wizard - when using the 'Create All' feature, use the Warehouse Code and Bin values set in the Configuration to apply these values for the Product. //------------------------------------------------------------ // v9.2.0 - released 27th February 2015 //------------------------------------------------------------ ConnectIt.exe v9.2.0 ConnectIt Configuration.exe v9.2.0 ConnectIt Create Customer Wizard.exe v9.2.0 ConnectIt Create Product Wizard.exe v9.2.0 ConnectIt Create Supplier Wizard.exe v9.2.0 ConnectIt Registration.exe v9.2.0 ConnectIt Registration Manager.exe v9.2.0 ADDED: support for Sage 200 2013 R2 (v9.2) //------------------------------------------------------------ // v1.11.0 - released 16th February 2015 //------------------------------------------------------------ ConnectIt.exe v1.11.0 ConnectIt Configuration.exe v1.11.0 ConnectIt Create Customer Wizard.exe v1.11.0 ConnectIt Create Product Wizard.exe v1.11.0 ConnectIt Create Supplier Wizard.exe v1.11.0 ConnectIt Registration.exe v1.11.0 ConnectIt Registration Manager.exe v1.11.0 ADDED: Configuration | Advanced | Wizards tab - Override options for Customer, Supplier and Product Wizards ADDED: ConnectIt | Customer Wizard - support for Override fields from any Document Header field. ADDED: ConnectIt | Supplier and Product Wizards - support for Override fields from any Document Header, Document Item or Vendors table field. FIXED: ConnectIt was looking to the online Registration Server every time that it ran. This was because the Registration details were not being read out of the local store correctly making ConnectIt think that it was in demo mode. This issue has now been resolved. //------------------------------------------------------------ // v1.10.2 - released 5th December 2014 //------------------------------------------------------------ ConnectIt.exe v1.10.2 FIXED: fatal Windows error message if the Document Transfer fails. This was due to the way that ConnectIt was disconnecting from Sage 200 and has now been resolved. //------------------------------------------------------------ // v1.10.1 - released 13th November 2014 //------------------------------------------------------------ ConnectIt Configuration.exe v1.10.1 ADDED: Configuration | Advanced tab | Tools tab - two utilities to delete SOP Sales Order and POP Purchase Order Documents. These utilities were developed primarily to provide a solution to an error where if a ConnectIt User cancelled the document transfer using Windows Task Manager 'End Task' feature as ConnectIt was creating the Document rather than waiting for a ConnectIt dialog to cancel the transfer process, then legacy ID-less records could be left in the database tables. For more information on this error, please refer to the ConnectIt Knowledgebase article here - http://www.connectit-software.co.uk/support/article.aspx?ID=312 //------------------------------------------------------------ // v1.10.0 - released 4th April 2014 //------------------------------------------------------------ ConnectIt.exe v1.10.0 ConnectIt Configuration.exe v1.10.0 ConnectIt Create Customer Wizard.exe v1.10.0 ConnectIt Create Product Wizard.exe v1.10.0 ConnectIt Create Supplier Wizard.exe v1.10.0 ConnectIt Registration.exe v1.10.0 ConnectIt Registration Manager.exe v1.10.0 ADDED: support for Sage 200 2013 //------------------------------------------------------------ // v1.9.0 - released 25th November 2013 //------------------------------------------------------------ ConnectIt.exe v1.9.0 ConnectIt Configuration.exe v1.9.0 ADDED: ConnectIt Configuration | Documents tab | Transfer Details tab | Sage Document Type column - options for Invoice, Credit Note and Invoice & Purchase Order Document Types ADDED: ConnectIt - support for Invoice, Credit Note and Invoice & Purchase Order Sage Document Types FIXED: ConnectIt - if creating a Sales Document along with Purchase Document(s) but no Suppliers were selected in the list, then ConnectIt would not create any Documents. //------------------------------------------------------------ // v1.8.5 - released 8th November 2013 //------------------------------------------------------------ ConnectIt.exe v1.8.5 UPDATED: Document Transfer - the Quantity transferred for Product / Service Line Items in Groups is now multiplied by the Group Quantity //------------------------------------------------------------ // v1.8.4 - released 8th November 2013 //------------------------------------------------------------ ConnectIt.exe v1.8.4 ADDED: Document Transfer - support for QuoteWerks Header Line Types //------------------------------------------------------------ // v1.8.3 - released 18th October 2012 //------------------------------------------------------------ ConnectIt.exe v1.8.3 ConnectIt Configuration.exe v1.8.3 ConnectIt Create Customer Wizard.exe v1.8.3 ADDED: Document Transfer - support for QuoteWerks for the Shipping Amount Cost. This is automatically added to the Sage 200 Document with the Shipping Amount Price introduced in ConnectIt-Sage200 v1.8.2. Note that this field is only available in QuoteWerks v4.7 (and above) UPDATED: Document Transfer - from v1.8.2 Shipping Amount feature: since we are unable to read the Shipping Amount Taxable / Non-Taxable value from the QuoteWerks Document and putting the option in the Configuration gives the user less easy control over the option, instead we use whether the QuoteWerks Document has a Tax Rate to indicate whether the Shipping Charge Line Item is taxable or not. FIXED: Document Transfer - when using the QuoteWerks address details for the Delivery Address in Sage and when the 'Use segmented addesses' is ticked in Sage 200, the City would get duplicated in the Sage Document Address Line 4 field and the City field. This issue has now been corrected - the City is only entered into one of the fields. FIXED: Customer Wizard - when creating a Customer from the address details on the QuoteWerks Document and when the 'Use segmented addesses' is ticked in Sage 200, the Address Line 3 field would not transfer. This issue has now been corrected - the Address Line 3 is now transferred. FIXED: Customer Wizard - when creating a Customer and when the 'Use segmented addesses' is ticked in Sage 200, the Country would not transfer, it would always default to 'GB - Great Britain. This issue has now been corrected - the correct Country is now transferred. //------------------------------------------------------------ // v1.8.2 - released 4th October 2012 //------------------------------------------------------------ ConnectIt.exe v1.8.2 ConnectIt Configuration.exe v1.8.2 ConnectIt Create Customer Wizard.exe v1.8.2 ADDED: Document Transfer - include the Shipping Amount on Sales Documents in Sage 200. This is added to the Document as an Additional Charge Item Line. There are options in the Configuration to set the Code, Desciption and Taxable Y/N for the Additional Charge Item Line. FIXED: Customer Wizard - issue where when creating a Customer in Sage 200 from information on the QuoteWerks Document, the County would be the Postal Code and the Postal Code would be blank. This issue has now been resolved. FIXED: Customer Wizard - issue where when creating a Customer in Sage 200 from information on the QuoteWerks Document, the Contact Name would be the Email Address and the Email Address would be blank. This issue has now been resolved. //------------------------------------------------------------ // v1.8.1 - released 28th August 2012 //------------------------------------------------------------ ConnectIt.exe v1.8.1 ConnectIt Create Customer Wizard.exe v1.8.1 ConnectIt Create Product Wizard.exe v1.8.1 ConnectIt Create Supplier Wizard.exe v1.8.1 ConnectIt Registration.exe v1.8.1 ConnectIt Registration Manager.exe v1.8.1 FIXED: "Invalid license..." error - ConnectIt-Sage200 license module was incorrectly configured to check the registration against the total number of licenses instead of the individual user licenses. This issue has now been resolved. //------------------------------------------------------------ // v1.8.0 - released 24th August 2012 //------------------------------------------------------------ ConnectIt.exe v1.8.0 ConnectIt Configuration.exe v1.8.0 ConnectIt Create Customer Wizard.exe v1.8.0 ConnectIt Create Product Wizard.exe v1.8.0 ConnectIt Create Supplier Wizard.exe v1.8.0 ConnectIt Registration.exe v1.8.0 ConnectIt Registration Manager.exe v1.8.0 ADDED: support for Sage 200 2011 UPDATED: modified to run using .net 4.0 //------------------------------------------------------------ // v1.7.2 - released 30th June 2012 //------------------------------------------------------------ ConnectIt.exe v1.7.2 UPDATED: only allocate Stock on Sales Order entry if the Stock Allocation Type is set to 'Manual'. //------------------------------------------------------------ // v1.7.1 - released 30th June 2012 //------------------------------------------------------------ ConnectIt.exe v1.7.1 ConnectIt Configuration.exe v1.7.1 ADDED: configuration option to prompt the user if by transferring the Document it would put the Customer over their Credit Limit set in Sage (see Configuration | Documents tab | Sales Documents tab | 'Prompt if document transfer would exceed Credit Limit' option) UPDATED: allow the SOP Ledger 'Allocate stock on order entry' setting to dictate whether stock is automatically allocated to an Order (ConnectIt previously forced the allocation). UPDATED: use the QuoteWerks Document Date for the Sage Pro Forma Invoice Date (ConnectIt previously used the current system date). UPDATED: simplified error messages that are generated when ConnectIt fails using the Sage API. FIXED: Resolved a "Delivery date that is in the past" error which occurs even if the Configuration option to suppress it is ticked - this occurred when setting the Document level Requested and/or Promised Delivery Dates, just the Line level values have been allowed before. //------------------------------------------------------------ // v1.7.0 - released 11th May 2012 //------------------------------------------------------------ ConnectIt.exe v1.7.0 ConnectIt Configuration.exe v1.7.0 ConnectIt Create Customer Wizard.exe v1.7.0 ConnectIt Create Product Wizard.exe v1.7.0 ConnectIt Create Supplier Wizard.exe v1.7.0 ConnectIt Registration.exe v1.7.0 ConnectIt Registration Manager.exe v1.7.0 ADDED: options to repeat the Requested and Promised Delivery Dates on a Sales Document onto the individual Line Items (see Documents tab | Sage Defaults tab | 'Transfer to Line Items also' options. Note that by activating these options, it will disable and override the Requested and Promised Delivery Date settings configured on the Product tab | Sales Documents tab | Main tab. ADDED: option to select the Warehouse that Line Items Stock is supplied from when creating Sales Order Documents in Sage. Note that if there is insufficient Quantity of the Product in Stock or if the Product is not available from the Warehouse, then the options on the Configuration | Advanced tab | Document Transer tab | Sage 200 tab are used to determine whether the Document should be created in Sage 200 or not. ADDED: an option to suppress errors that the specified Requested and/or Promised Delivery Dates specified in the Configuration or QuoteWerks Document are in the past (see Configuration | Advanced tab | Sage 200 tab | 'Suppress prompts that Delivery Dates are in the past' option). ADDED: support for new QuoteWerks Document Header table fields: ContractStartDate and ContractEndDate UPDATED: the macro for Line Item Requested and Promised Delivery Dates now includes the QuoteWerks Document Header fields (see Configuration | Products tab | Sales Documents tab | Main tab | 'Requested Delivery Date' and 'Promised Delivery Date' options) FIXED: "Sage.Accounting.Exceptions.Ex20235Exception: there is an order value discount available for this order" error if the Orders being created fell into the Sage Customer's automatic Discount band. The issue has now been resolved, the error is ignored and the Discount is automatically applied to the Order as it is transferred. FIXED: "Sage.Accounting.Exceptions.NoSuchWarehouseDUPEException: you must select a warehouse" error if the Stock Item Quantity in Sage of a Product on the QuoteWerks Document was negative. The Sage Warehouse was not getting allocated, resulting this error. The issue has now been resolved. //------------------------------------------------------------ // v1.6.0 - released 5th September 2011 //------------------------------------------------------------ ConnectIt.exe v1.6.0 ConnectIt Configuration.exe v1.6.0 ConnectIt Create Customer Wizard.exe v1.6.0 ConnectIt Create Product Wizard.exe v1.6.0 ConnectIt Create Supplier Wizard.exe v1.6.0 ConnectIt Registration.exe v1.6.0 ConnectIt Registration Manager.exe v1.6.0 ADDED: option to select the default Warehouse where Sales Order Items should be supplied from, this is used when creating Sales Order module Sales Order or Pro Forma Invoice document types - see Configuration | Documents | Sales Documents | 'By Default Supply From' option ADDED: option to override the error message if the is not available from the default warehouse - see Configuration | Advanced | Sage 200 | 'Suppress prompts that an Item is not available from the default Warehouse' option ADDED: option to use a QuoteWerks field to set the Order Priority for Sales Documents created in Sage (instead of using the Sage default) - see Configuration | Documents | Sales Documents | 'Order Priority from QuoteWerks' option ADDED: options to Warn the user of Fail the Document Transfer if the Requested and/or Promised Delivery Date field identified in QuoteWerks are blank or have an otherwise invalid value entered - see Configuration | Products | Sales Documents | Main | 'Requested Delivery Date If Blank Then' and 'Promised Delivery Date If Blank Then' options ADDED: CustomText17-24 fields to relevant dropdowns in Configuration UPDATED: splash screen style changes for new website //------------------------------------------------------------ // v1.5.1 - released 9th August 2011 //------------------------------------------------------------ Internal test release only. //------------------------------------------------------------ // v1.5.0 - released 25th July 2011 //------------------------------------------------------------ ConnectIt.exe v1.5.0 ConnectIt Configuration.exe v1.5.0 ConnectIt Create Customer Wizard.exe v1.5.0 ConnectIt Create Product Wizard.exe v1.5.0 ConnectIt Create Supplier Wizard.exe v1.5.0 ConnectIt Registration.exe v1.5.0 ConnectIt Registration Manager.exe v1.5.0 ADDED: option for 'Allowed Tax Rates' (see Configuration | Documents | Main) UPDATED: ConnectIt now ignores Stock Locations (Warehouses) that do not permit sales so that if you do have Stock Locations like this (such as to manage Sales Reps allocation for demo / sample purposes) then ConnectIt will not attempt to allocate Stock from these. UPDATED: Tax Code mappings as per below matrix: QuoteWerks ShipTo Country VAT Reference Tax Code (with Override*) Tax Code (no Override*) Blank (represents UK) Present Sage Customer Default From QuoteWerks Tax Rate Blank (represents UK) Blank Sage Customer Default From QuoteWerks Tax Rate EC countries Present Sage Customer Default Config Euro Tax Code EC countries Blank Sage Customer Default From QuoteWerks Tax Rate Rest of World Present Sage Customer Default Config Zero Rated Tax Code Rest of World Blank Sage Customer Default Config Zero Rated Tax Code * Override is the Sales Order Tax Rate from Customer option on the Documents | Sales Documents tab of the Configuration Utility FIXED: "Conversion from string to type Date is not valid" error if the Requested Date and/or Promised Date options were enabled and there is no value set in the specified Line Item field, or if the Requested Date and/or Promised Date option was set incorrectly - ConnectIt now simply leaves the value blank when transferring into Sage. //------------------------------------------------------------ // v1.4.7 - released 25th March 2011 //------------------------------------------------------------ ConnectIt.exe v1.4.7 FIXED: Issue transfering Country Code for sales documents when the QuoteWerks country is blank. //------------------------------------------------------------ // v1.4.6 - released 16th February 2011 //------------------------------------------------------------ ConnectIt.exe v1.4.6 ConnectIt Configuration.exe v1.4.6 ADDED: Transfer of QuoteWerks VAT number (from the QuoteWerks field specified in the configuration) to Sage 200 Sales Document Tax Number field. ADDED: Transfer of Country Code (Tax Details) for Sales Documents. ADDED: Customer Tax code/Tax Rate calculation for document transfers, you now have the option to let ConnectIt calculate the tax code and tax rate using the VAT number and delivery address country. UPDATED: Layout of the Customers' tab in the ConnectIt Configuration Utility. FIXED: QuoteWerks Address City field being transfered to Sage 200 Address 4 field, this is now transfered to the City field. //------------------------------------------------------------ // v1.4.5 - released 25th January 2011 //------------------------------------------------------------ ConnectIt.exe v1.4.5 ConnectIt Configuration.exe v1.4.5 Documentation v1.4.5 ADDED: Filtering functionality for Additional Charge items (filter Product/Service lines for specified Manufacturer Part Number(s) enabling them to be transferred as Additional Charge items in Sage). ADDED: Filtering configuration options for Additional Charge items. UPDATED: When transferring documents from QuoteWerks to Sage using QuoteWerks' Alternate Price fields, the Sage Exchange Rate was set to 1.000000. The appropriate Global Exchange Rate in Sage is now used instead. UPDATED: Updated the HilltopsIT Copyright message. //------------------------------------------------------------ // v1.4.4 - released 13th January 2011 //------------------------------------------------------------ ConnectIt.exe v1.4.4 ConnectIt Configuration.exe v1.4.4 Documentation v1.4.4 UPDATED: Renamed configuration option "Suppress prompt that the customer is on hold in Sage 200" to "Transfer document even if the customer is on hold in Sage 200" UPDATED: Renamed configuration option "Suppress prompt that no free stock is available in Sage 200" to "Transfer document even if no free stock is available in Sage 200" UPDATED: Documentation Updates. FIXED: Analysis Codes not being transferred for Document Items (products). //------------------------------------------------------------ // v1.4.3 - released 20th December 2010 //------------------------------------------------------------ ConnectIt.exe v1.4.3 FIXED: Analysis Codes not being transferred to the correct field. //------------------------------------------------------------ // v1.4.2 - released 16th November 2010 //------------------------------------------------------------ ConnectIt.exe v1.4.2 ConnectIt Configuration.exe v1.4.2 ADDED: Option to suppress "customer on hold" error messages and create sales orders anyway. The sales order is also put on hold in Sage. ADDED: Option to suppress "no free stock" error messages and create Sage document anyway. ADDED: Option to select which delivery address is used during document transfer. UPDATED: Updated the functionality for alternate pricing fields to be used as the product pricing, now only used if the QuoteWerks Alternate Currency is not the base currency. FIXED: the normal address field was also being used for the delivery address, delivery address now comes from the correct configuration setting. //------------------------------------------------------------ // v1.4.1 - beta released 8th November 2010 //------------------------------------------------------------ ConnectIt.exe v1.4.1.0 ConnectIt Configuration.exe v1.4.1.0 ADDED: Ability to write QuoteWerks field value to Sage Date Requested and Date Promised fields ADDED: FOB to Customer Account field drop down menu in configuration ADDED: Support for the alternate pricing fields to be used as the product pricing. ADDED: Ability to create Pro Forma Invoice document in Sage ADDED: Configuration options for Pro Forma Invoice creation ADDED: Ability to write QuoteWerks field value to Analysis Codes 1 - 6 for sales and purchase documents. ADDED: Configuration options for Analysis codes macros FIXED: Issue with n character search for Customer and suppliers. //------------------------------------------------------------ // v1.4.0 - released 25th October 2010 //------------------------------------------------------------ ConnectIt.exe v1.4 UPDATED: ConnectIt now uses Sage 200 2010 dll's FIXED: Company select Screen allowing multiple Company files to be selected //------------------------------------------------------------ // v1.3.1 - released 1st September 2010 //------------------------------------------------------------ ConnectIt.exe v1.3.1.0 ConnectIt Configuration.exe v1.3.1.0 ADDED: when creating documents, there is now an option for the user to select which Sage 200 Company to create the document in at run-time, rather than it being fixed. FIXED: resolved run-time error if no Suppliers were selected when creating Purchase Orders FIXED: Error adding new lines to Document Transfer Details grid //------------------------------------------------------------ // v1.3.0 - released 17th August 2010 //------------------------------------------------------------ ConnectIt.exe v1.3.0.0 ConnectIt Configuration.exe v1.3.0.0 ConnectIt Create Customer Wizard.exe v1.3.0.0 ConnectIt Create Product Wizard.exe v1.3.0.0 ConnectIt Create Supplier Wizard.exe v1.3.0.0 ConnectIt Registration.exe v1.3.0.0 ConnectIt Registration Manager.exe v1.3.0.0 ADDED: support for foreign currency - creating Sales Orders in the Customers own currency and Purchase Orders in the Suppliers currency ADDED: support for various Tax Codes, depending on the Customer's locality and whether a tax reference is available (i.e. European taxable or non-taxable codes) ADDED: when creating Purchase Order documents, the user can select which Suppliers to create a document for in Sage 200 //------------------------------------------------------------ // v1.2.0 - released 28th July 2010 //------------------------------------------------------------ ConnectIt.exe v1.2.0.0 ConnectIt Configuration.exe v1.2.0.0 ConnectIt Create Customer Wizard.exe v1.2.0.0 ConnectIt Create Product Wizard.exe v1.2.0.0 ConnectIt Create Supplier Wizard.exe v1.2.0.0 ConnectIt Registration.exe v1.2.0.0 ConnectIt Registration Manager.exe v1.2.0.0 ADDED: options to create Purchase Order documents //------------------------------------------------------------ // v1.1.0 - released 19th July 2010 //------------------------------------------------------------ ConnectIt.exe v1.1.0.0 ConnectIt Configuration.exe v1.1.0.0 ConnectIt Create Customer Wizard.exe v1.1.0.0 ConnectIt Create Product Wizard.exe v1.1.0.0 ConnectIt Create Supplier Wizard.exe v1.1.0.0 ConnectIt Registration.exe v1.1.0.0 ConnectIt Registration Manager.exe v1.1.0.0 ADDED: Product, Customer and Supplier wizards //------------------------------------------------------------ // v1.0.0 - released 29th June 2010 //------------------------------------------------------------ ConnectIt.exe v1.0.0.0 ConnectIt Configuration.exe v1.0.0.0 ConnectIt Registration.exe v1.0.0.0 ConnectIt Registration Manager.exe v1.0.0.0 Allows the users to create Sales Order documents in Sage 200 from the information on a QuoteWerks document