Releases

Version: 1.20.3.0
Date: 22/12/2018
Time Released: 5:00pm ADST

New Features

• RAND JSON/XML/CSV field function - Generates a random number, within a specified range, rounded to a specified number of decimals.
• LENGTH JSON/XML/CSV field function - returns the number of characters in text given to it.
• CONTROL_CHAR JSON/XML/CSV field function - places tabs, new line, and carriage return characters into text where \t \r or \n text appears within literal text or text queried from JSON/XML/CSV data.

Improvements

• ENCODE JSON/XML/CSV field function now supports "hashing" text using the SHA1 and SHA256 cryptography algorithms.
• Product Sell Units Generic adaptor data export contains 2 fields for setting the sell unit label and parent sell unit that a product is assigned to..

Bug Fixes

• 2 bug fixes

Version: 1.19.0.0
Date: 20/09/2018
Time Released: 10:00pm AEST

New Features

• Micronet Harmoniq preset for the Generic adaptor. Allows the Generic adaptor to be configured to integrate with Micronet Harmoniq' s system through its SOAP based web service.
• Generic Adaptor Documentation Generator. Allows a web page containing documentation of how a Generic adaptor has been configured to be generated, allowing data sources, data exports and data imports to be understood more easily.
• Supplier Invoice importing into Connector. The Connector now supports importing Supplier Invoices into the Connector. The Generic adaptor now supports being able to import supplier invoices into JSON/XML web services/files, ODBC databases, MS SQL Server databases, SQLite databases, and CSV files.
• ARRAY_LENGTH JSON/XML field function. Gets the length of an array within JSON/XML data.
• ARRAY_VALUE_JOIN JSON/XML field function. Joins values together that stored within an array in JSON/XML data.
• DECODE JSON/XML field function. Decodes text data back into plain text form.
• ENCODE JSON/XML field function. Encodes text data into a form that is safe to use with XML, JSON, URL, BASE64, SQL data.
• PAGE_NUMBER JSON/XML field function. Obtains the number of the page of records that are being processed within a data export request.
• PARENT_ARRAY_INDEX JSON/XML field function. Gets the position/index number of a record being processed within its position of a parent index in JSON/XML data.
• RECORD_SET_INDEX JSON/XML field function. Gets the position/index number of the record set currently processing JSON/XML data.
• RECORD_INDEX JSON/XML field function. Gets the position/index number of the record currently being processed from XML/JSON data.
• TRIM JSON/XML field function. Removes white space on the left, right, or both sides of text found in JSON/XML data.

Improvements

• MYOB Retail Manager adaptor now supports placing the organisation name in the delivery address of a sales order into the address field of a MYOB Retail Manager sales order.
• New setting in Generic adaptor's JSON/XML data export/import settings to set the HTTP request headers for each data export/import.
• Data fields for Generic adaptor customer account record data exports to allow filtering and data hooks to be placed within JSON/XML data export/import setting fields.
• Connector email setting to specifiy if emails should be sent securely over a network or not.

Bug Fixes

• No bug fixes

Version: 1.18.0.0
Date: 19/06/2018
Time Released: 10:15pm AEST

New Features

• Sales Order, Purchase Order, Customer Account Payments Data imports for JSON/XML Web Service/File Generic Adaptor data source. This allows sales orders, purchase orders, and customer account payments to be imported into systems via generating JSON or XML data, and saving that data to a file or passed to a web service via HTTP that accepts importing this data.
• Customer Account Enquiry Invoices and Customer Account Enquiry Invoice Lines data exports for MYOB Retail Manager adaptor. This allows invoices to be queried from connected MYOB Retail Manager installations.
• Additional data exports for JSON/XML Web Service/File Generic Adaptor data sources allowing contracts, attributes, product combinations, customer account records (invoices, sales orders, payments, credits, transactions, invoice line reports), to be retrieved when stored in JSON and XML files, or returned from web services via HTTP.

Improvements

• Setting to control the field used to match customers to sales orders when importing sales orders with the MYOB AccountRight Premier adaptor
• Output CustomerReference record field data for Customer Account Record Backorders/Credits/Payments/Quotes data exports for Generic adaptor, Micronet Distribution adaptor, MYOB AccountRight Premier/Enterprise adaptor, and MYOB AccountRight Cloud/2013+ adaptor.
• Datapel WMS Adaptor's Product Account Pricing data export supports calculating pricing for accounts that are assigned to many price groups based on multiple account indentifiers assigned to each account.

Bug Fixes

• Bug fixed to ensure data can be copied and pasted from one field to another under Category Product tab within Data Set window.
• Supplier Account Enquiry Purchase Order data export from the Generic adaptor now able to export data when line type field is not active.

Version: 1.17.0.0
Date: 18/05/2018
Time Released: 11:00pm AEST

New Features

• Adaptor Presets for the Generic adaptor. Save cofigurations of the Generic adaptor as preset files that can be exported, transferred between Connectors, and loaded back into Generic adaptors.

Improvements

• Datapel WMS adaptor setting to control if kit components are displayed in sales orders when imported into the Datapel WMS system.

Bug Fixes

• Locations data export within Generic adaptor now correctly sets the data fields attribute with the exported document, ensure location data can be imported into other systems.
• Product Combination records in Data Sets now ensure keyComboProfileIDs, keyComboProfileIDs, keyComboProfileFieldValueIDs get updated across all Data Set tables, ensuring combination data stays linked.

Version: 1.16.0.0
Date: 23/04/2018
Time Released: 9:00pm AEST

Version: 1.15.0.0
Date: 19/03/2018
Time Released: 9:00pm AEST

New Features

• Ability to manage and import Product Image data into Data Sets.
• Ability to manage and import Product Attachment data into Data Sets.
• Ability to manage and import Item Relations data into Data Sets.

Improvements

• Ability to import and export data from MYOB AccountRight company files stored in the MYOB Cloud.
• Datapel WMS adaptor now sets the product name in the WMS system's order line description field.
• Generic adaptor's Categories Data Export no longer requires the Category Products data export to be configured to be able to export out category data.

Bug Fixes

• When setting data within Data Sets you can now correctly set single quote characters within record fields.
• Datapel WMS adaptor correctly now exports price-level quantity break prices for quantities set to 1 in its Product Quantity Pricing data export.

Version: 1.14.0.0
Date: 12/02/2018
Time Released: 10:00pm ADST

Improvements

• Ability to group category discount pricing when running Account Product Pricing data export within Micronet Distribution adaptor, reducing pricing records exported.
• MYOB Exo adaptor now can set external location data when sales orders are imported into MYOB Exo.
• Generic adaptor can now to set external location data with sales order data when imported into configured data source.
• New "keyCategoryTreeID" record field in Categories data exports for adaptors and Data Sets to set the category tree that each category record can be assigned to.
• Data Exports timeout periods extended up to 200 seconds when exporting data to Ecommerce platforms. Maker/Models data export timeout increased to 10 minutes. Maker/Model Mappings data export timeout increased to 35 minutes.

Bug Fixes

• Fix to allow data exports for product Iiages and attachments from the Datapel WMS adaptor to work again.

Version: 1.13.0.0
Date: 08/12/2017
Time Released: 9:30pm ADST

New Features

• Ability to view and manage product combination data within Data Sets.

Improvements

• Ability to see Product Name column within Category Products, Product Sell Units and Product Attribute Values data types within the Data Sets window.

Bug Fixes

• Bug fix for the Product Account Pricing data export within the Micronet Distribution adaptor to correctly export data when a category contract discount pricing rule is set up within the Micronet Distribution system
• Bug within Product Attribute Values tab of the Data Sets window to correct display product rows after the sorting of a column has changed an the column pagination button has been clicked on.

Version: 1.11.0.0
Date: 26/10/2017
Time Released: 8:30pm ADST

New Features

• Ability to view and manage product attribute data within Data Sets.
• Ability to import and export attribute data from data sets as well. See Data Sets documentation below for more details.

Improvements

• A new "Ordering" field has been added to Product data exports for all adaptors. This may be used to control the sorting of product data in connected systems.
• Ability to import text lines with sales order and purchase order data coming into the Connector. Sales order text lines are also supported in being inserted into orders by the MYOB AccountRight Premier, MYOB AccountRIght 2013+, Datapel WMS, Generic, and Micronet adaptors.
• New "Ordering" field has been added to Product data exports for all adaptors. This may be used to control the sorting of product data in connected systems.

Bug Fixes

• Bug fix in Data Sets when clearing keyCategoryID value in Category Products records now correctly deletes the category_product record from the dataset's database.

Version: 1.10.0.0
Date: 15/09/2017
Time Released: 8:30pm AEST

New Features

• Data Sets. Store, manage and merge data within the Connector itself.
• SQLite Database Query Browser. Test and query data from SQLite databases (version 3).
• "SQLite Database"  data source type within the Generic adaptor. Configure the Generic adaptor to read and write data to SQLite databases (version 3).
• The Generic adaptor's "JSON/XML Web Service/File" data source type now supports Product Customer Account Pricing data exports.

Improvements

• Setting in Generic adaptor to allow supplier account enquiry purchase order text lines to be placed within comments field.
• Field "supplierItemCode" added  to store item code of supplier within purchase order line records and supplier account enquiry purchase order record line data exports of Generic adaptor, Attache adaptor, and MYOB AccountRight 2013+ adaptor.

Version: 1.14.0.0
Date: 14/12/2017
Time Released: 10:00pm ADST

New Features

• Ability to export Make/Model data from the Connector. 5 new data exports can be configured to export Makers, Maker Models, Maker Model Attributes, Maker Model Mappings, Maker Model Mapping Attributes.
• Ability to export Customer Account Quote records from the Connector. 2 new data exports can be configured to export Customer Account Record Quotes, and Customer Account Record Quote Lines. Micronet Distribution adaptor also has a new data export for exporting the details of a quote record from its system.

Improvements

• In Data Sets you can find now records for all types by using the record matching operators "equals", "not equal to", "starting with", "ending with". This provides more ways to search and find records across a large sets of records.
• In Data Sets there's now a setting in the Product Attribute Values table to lock product columns. This allows the product columns to stay visible when you scroll horizontally across attribute columns, helping to easily see the products that attribute values are assigned against.
• For adaptor data exports you can now paste multiple values into Custom Field Definition column cells. This allows multiple cell values to be copied and pasted from spreadsheet applications or other columns in the data exports table, making it quicker and easier to configure data exports.

Version: 1.9.0.0
Date: 25/08/2017
Time Released: 8:30pm AEST

New Features

• Supplier Account Enquiry added within the Connector application to search and view purchase orders from systems and data sources linked to any adaptors.
• Ability to upload and send purchsae orders to supplier organisations on SQUIZZ.com to have orders procured and converted into supplier sales orders.
• Witin the Generic adaptor the "JSON/XML Web Service/File" data source type now supports Supplier Account Enquiry Purchase Orders and Purchase Order Record data exports. This allows purchase orders to be queried and retrieved from XML or JSON files and webservices that support the data types.

Improvements

• Ability to set to delivered and back orders quantities for customer account enquiry back order record data exports in Micronet Distribution adaptor.
• Increased timeout of Customer Accounts data exports to 10 minutes.
• Ability to now customise invoice, back order, sales order and credit records within Customer Account Enquiry Record data exports within the Micronet Distribution adaptor.
• Ability to read through and retrieve records from multiple JSON or XML files for data exports when using the JSON/XML Web Service/File data source in the Generic Adaptor.
• Modified Connector database upgrader to provide more technical error message if it fails.
• When running an scheduled data export once off from the Connector application the Timeout error log is now raised as a warning log

Bug Fixes

• Fixed bug that was stopping Product Images and Attachment files from being uploaded when using Micronet Distribution adaptor.
• Fixed bug that was setting incorrect sell unit quantity for packs in Products data export within Micronet Distribution adaptor..
• Fixed bug so that Taxcodes data export within MYOB Retail Manager adaptor sets the correct field names in the exported document.
• Fixed bug stopping Customer Account Enquiry Back Orders data export in MYOB AccountRightPremier adaptor from successfully completed.

Version: 1.8.0.0
Date: 15/03/2017
Time Released: 7:40pm ADST

New Features

• Witin the Generic adaptor that allows JSON or XML data to be obtained from a webservice over HTTP, or from a file stored locally on a file system.
  The "JSON/XML Web Service/File" data source type now supports the following data exports within the Generic adaptor:
  • Categories
  • Alternate Codes
  • Product Images
  • Product Attachments
  • Item Relations
  • Surcharges
  • Payment Types
  • Purchasers
  • Supplier Accounts
  • Supplier Account Addresses
  • Sell Units
  • Adaptor Status
  • Flags
  • Kits
  • Item Groups
  • Locations

Improvements

• Added ability tp pagination through Scheduled History Logs within the Adaptor Export/Routine Scheduler Window
• Increased timeout of Product Pricing data exports to 10 minutes.
• Adaptors and Messages tab within the Connector application now allows the connector messages to be viewed in its own window.
• Added ability to show surcharge label, description and keySurchargeID fields within Sales Order and Purchase Order Detail windows
• Modified Type3, and Type4 sales order files generated by Micronet Distribution adaptor to support setting delivery region name if delivery address 3 field is empty
• Modified Connector database upgrader to provide more technical error message if it fails.
• Added setting to Attache adaptor to allow supplier account enquiry purchase order records to text line descriptions within the comments of the order instead.
• Modified MYOB AccountRight Premier/Enterprise adaptor to support placing space between user name and intructions data within sales orders set to its system.

Bug Fixes

• Fixed bug in Product Account Pricing data export within Datapel WMS adaptor to not cluding pricing when quantity is set to 0.
• Fixed bug in Product Account Pricing data export within Micronet Distribution adapter to not factor in contract quantity break discounts on price levels not associated to an account's price group.
• Fixed bug in Product Combination data export within Generic adaptor if the first child product in a combination is the default, then to allow the default product mapping to be exported.

Version: 1.7.0.0
Date: 13/12/2016
Time Released: 2:45pm ADST

New Features

• A new data source type witin the Generic adaptor that allows JSON or XML data to be obtained from a webservice over HTTP, or from a file stored locally on a file system.
  The "JSON/XML Web Service/File" data source type supports the following data exports within the Generic adaptor:
  • Taxcodes
  • Customer Accounts
  • Customer Account Addresses
  • Customer Account Status
  • Products
  • Product Pricing
  • Product Price Level Pricing
  • Product Stock Quantities
  • Sales Reps
• JSON/XML Query Browser added to Connector application that allows querying of JSON or XML data stored in files, requested from a web service using HTTP, or placed directly into the query browser.
• Base 64 Text Encoder/Decoder added to Connector application to make it easy to encode text into base64 text, or decode base64 text back into plaintext.
• Attache adaptor now supports data exports for Supplier Accounts, Supplier Account Addresses, Supplier Account Purchase Order Records.

Improvements

• Locations data exports ran from the Connector application timeout increased from 2 minutes to 10 minutes.
• Adaptors and Messages tab within the Connector application now allows the connector messages to be viewed in its own window.
• Data exports that were scheduled and missed in the Connector are now rescheduled based on the number of days in the future from the last date that the data export was scheduled to run.
• Generic adaptor's ODBC data source type now supports generating SQL queries that match data records numerically for customer account record data exports, supplier account data exports, and customer account status data exports. Key record IDs fields must have the DB Field Type set to Integer to allow numeric comparisons to take place.
• MYOB AccountRight Premier adaptor's Supplier Account Purchase Orders data export now supports searching for  orders based purchase order code.
• MYOB AccountRight Premier adaptor's Taxcodes data export now enables the taxcode and taxcode label fields by default.
• MYOB AccountRight Premier adaptor contains setting that allows a contact name to be found within purchase order delivery addresses.
• Micronet Distribution adaptor's xCBL3.0 Reconcilliation Invoice Export routine to remove special characters in invoce line descriptions when sending out invoice data.
• Micronet Distribution adaptor's xCBL3.0 Reconcilliation Invoice Export routine to set the tax rate in invoice lines based on the taxcode tax rate assigned to the invoice line.
• Connector application now signed with a coding certificate to ensure that Windows trusts the application being downloaded and installed.

Bug Fixes

• Fixed bug stopping invoice data from being exported with SAP Business One adaptor.
• Fixed bug in Micronet Distribution adapter that was stopping customer account back order records from being exported.
• Fixed bug in Micronet Distribution adaptor that was stopping category records from being exported out in Categories data export.
• Fixed bug in Micronet Distribution adaptor where it was not setting the correct transaction type in a generated CSV sales order file when the payment method of a sales order was set to Quote.
• Fixed bug in Micronet Distribution adaptor where customer acocunt enquiry invoice record data was returning incorrect unit pricing for lines containing back-ordered quantities.
• Fixed bug in MYOB AccountRight Premier adaptor to ensure that product records were not being incorrectly set as being kitted products when they were not.

A new version of the Connector has been released, version 1.5

Version: 1.5.0.1
Date: 05/07/2016
Time Released: 7:30pm AEST

New Features

• Ability to search for sales orders, purchase orders, and customer account payments within the Connector application.
• Ability to export Supplier Accounts, Supplier Account Addresses, Payment Types data from MYOB Exo, AccountRight Premier, Retail Manager, SAP Business One and Datapel WMS adaptors.

Improvements

• Setting in Datapel WMS adaptor for sales orders to be re-priced when imported into its system.
• Export comments, shipping and promise date data on customer account invoices from MYOB AccountRight Premier adaptor.
• Link customer/supplier accounts to codes in the Generic adaptor alternate code export.
• Export additional delivery, billing, and freight fields with account enquiry record data from the Generic adaptor.
• Adaptor setting to control sales orders being imported as invoices or sales orders into MYOB AccountRight Premier.

Bug Fixes

• MYOB AccountRight Permier adaptor able to retrieve customer account data again.
• Ability to import purchase orders into Connector again.
• Ability to obtain details of a purchase order from a supplier account enquiry data export again.
• MYOB AccountRight Premier adaptor able to return balance data in customer account enquiry invoice record export again.
• Connector application loading customer/supplier account name in Sales Order Detail and Purchase Order Detail windows.

A new major version of the Connector has been released, version 1.4
This version adds the ability to export a number of different types of data from an accounting/ERP system, or CSV files, ODBC/MS SQL Server databases, all through the use of a configured generic adaptor in the Connector. Additionally the release adds additional security to the Connector to allowing incoming connections to use HTTPS protocol and TLS/SSL certificates. This ensures any data pushed through the connector can be securely transferred without having to rely upon another webserver being placed in front of the Connector.

Version: 1.4.0.0
Date: 25/05/2016
Time Released: 5:30pm AEST

New Features

• Ability to accept incoming Connector requests directly over HTTPS, using TLS/SSL certificates to secure the incoming connections.
• Ability to export Item Relation data from all data source types in the Generic adaptor.
• Ability to export Item Group data from all data source types in the Generic adaptor.
• Ability to export Surcharge data from all data source types in the Generic adaptor.
• Ability to export Payment Type data from all data source types in the Generic adaptor.
• Ability to export Purchaser data from all data source types in the Generic adaptor.
• Ability to export Supplier Account data from all data source types in the Generic adaptor.
• Ability to export Supplier Account Address data from all data source types in the Generic adaptor.
• Ability to export Sell Unit data from all data source types in the Generic adaptor.
• Ability to validate Squizz.com security certificates created for an organisation in the platform.
• Ability to export out Purchase Order data associated to a supplier account from all data source types in the Generic adaptor

Bug Fixes

• Fixed bug where the generic adaptor's Taxcodes data exports would fail to export data if the "Taxcode ID" data field was enabled for ODBC, CSV, or MS SQLServer data source types.

A new major version of the Connector has been released, version 1.3
This version adds the ability to route data exports to different adaptors, allowing for flexibility on which data sources certain data can be retrieved from. The release also adds the ability for the connector to be able to import purchase orders into ODBC and Microsoft SQL Server databases through the use of the generic adaptor in the Connector.

Version: 1.3.0.0
Date: 13/04/2016
Time Released: 9:12pm AEST

New Features

• Ability to import purchase orders into ODBC accessible databases using the Generic adaptor
• Ability to import purchase orders into Microsoft SQL Server databases using the Generic adaptor
• Ability to route adaptor data imports to other adaptors.

Improvements

• Added settings to the Generic adaptor's ODBC and MS SQL Server data sources to be able to use transactions and prepared database statements to write adaptor sales orders, purchase orders, and customer account payments data.

Bug Fixes

• Fixed bug where adaptor Product Account Pricing data exports would fail to export data if the data transfer mode was set to be incremental.

A new major version of the Connector has been released, version 1.2
This version adds the ability to import sales orders into ODBC and MS SQL Server databases using the Connector's generic adaptor. This gives great flexibility to software providers and data specialists on importing sales order data into new and existing business systems.

Version: 1.3.0.0
Date: 13/04/2016
Time Released: 9:12pm AEST

New Features

• Ability to import sales orders into ODBC accessible databases using the Generic adaptor
• Ability to import sales orders into Microsoft SQL Server databases using the Generic adaptor
• Added routine to Micronet Distribution adaptor that can reconcilled orders imported through the Connector, with invoices in the distribution system, then sent out invoices to a web service in the xCBL3.0 data format.

Improvements

• Added setting to Datapel WMS adaptor to restrict the number of next-arrival-dates that can be set for each product if the adaptor is configured to obtain data from purchase orders.
• Generic adaptor's settings window in the Connector application modified to have bigger fields for modifying data import and data export settings.

Bug Fixes

• Fixed bug where the "Is Tax Inclusive" data was not being exported out from any adaptor Products data export.
• Fixed bug where sales order or purchase order detail window would not load in the Connector application if the order contained any product delivery records for a line.

A new major version of the Connector has been released, version 1.1
This version adds the ability for requests to export data from the Connector to be routed between adaptors. This is very handy when one adaptor does not support a data export, so instead it can be routed to another adaptor such as the generic adaptor which can source the data from somewhere else.
Additionally the is now the ability in the Generic adaptor to configure an invoice line report. This allows reports such as "most ordered products" or "ordered products not delivered yet" to be built, based on data coming from business system databases.

Version: 1.1.1.0
Date: 22/03/2016
Time Released: 8:43pm AEDST

New Features

• Adaptor Data Export Routing
• Customer Account Enquiry Invoice Lines Report adaptor data export
• Generic adaptor MS SQL Server data source data exports
• Generic adaptor ODBC data source data exports

Improvements

• Set purchase order next stock arrival dates for products when exporting from Datapel WMS adaptor

Version: 1.0.0.4
Date: 24/02/2016
Time Released: 5:00pm AEDST

New Features

• "Xsquizzit Accounting Connector" rebranded to the "Squizz.com Connector".
• Connector Host Service renamed from "Accounting Connector" to "Squizz.com Connector"
• Generic adaptor's CSV data source can now import sales orders, purchase orders and customer account payments to CSV files.
• Generic adaptor's HTTP-Ecommerce Standards Document data source now has the ability to export all data from a compatible webservice, as well import sales order, purchase order, and customer account payment data.
• Data exported from the Connector service now supports and implements version 1 of the Ecommerce Standards Documents standard https://www.squizz.com/esd/index.html
• Adaptor Password field added to boost security of incoming requests for given adaptors.
• Implrmentation of basic HTTP authentication of incoming adaptor data requests.

Improvements

• Refactoring of all classes within the Connector software.
• Connector Application now shows version numbers of the application, the windows host service, and the database within the Settings tab.
• Additional fields added to Sales Order Details and Purchase Order Details windows within the Connector application.
• Connector Application and Connector Host Service now place application launchers into a "Squizz.com Connector" start menu folder.
• Sales order and purchase orders imports into the Connector now support importing multiple orders in one request.

Version: 0.29.1
Date: 24/02/2016
Time Released: 5:30pm AEDST

New Features

• Wizard in Connector application to migrate the connector's 0.x database to version 1.0.

Improvements

• Micronet Distribution adaptor to remove asterisks characters from sales order instructions when generating sales order files for Micronet's DataConnect software. This is done to mitigate DataConnect not being able to handle such characters.

Bug Fixes

• Datapel WMS adaptor's product data export modified to correctly obtain data mapped to the barcode field.

Version 0.28.1 of the Connector has been released. The details of the release are:

Version: 0.28.1
Date: 30/11/2015
Time Released: 1:30pm ADST

New Features

• Generic adaptor to read data from CSV files and export data for all data exports including:
  Taxcodes
  Price Levels
  Categories
  Customer Accounts
  Customer Account Addresses
  Customer Account Status
  Customer Account Contracts
  Locations
  Products
  Product Price Level Pricing
  Product Price Level Quantity Pricing
  Product Customer Account Pricing
  Product Flags
  Product Alternate Codes
  Product Kits
  Product Stock Levels
  Product Attributes
  Product Combinations
  Product Images
  Product Attachments
  Product Stock Levels
  Sales Representatives
  Adaptor Connection
  Account Enquiry Invoices
  Account Enquiry Sales Orders
  Account Enquiry Back Orders
  Account Enquiry Credits
  Account Enquiry Payments
  Account Enquiry Transactions

Improvements

• Micronet Distribution adapter to factor in sales unit quantity set for each product when exporting data in product pricing, product quantity pricing, and product customer account pricing data exports.
• SAP Business One adaptor to contain Kitted Products data export to export Bill Of Materials data from SAP Business One as kitted product data.
• MYOB AccountRight Premier adaptor has settings to include or exclude login ID and sales representative in the sales order comments when imported into MYOB AccountRight Premier/Enterprise..

Bug Fixes

• Removal of double quote characters in instrustions field of sales order CSV file generated by the Micronet Distribution adaptor to ensure that DataConnect does not crash when importing the sales order CSV file.
• SAP Business One adaptor's Products data export to correctly export out depth product data.
• MYOB Retail Manager adaptor to handle importing sales orders and trim the instructions field when its data exceeds 250 characters.
• MYOB AccountRight Premier adaptor to ensure that the correct terms are returned when obtaining the customer account status from MYOB AccountRight Premier adaptor.
• MYOB AccountRight Premier adaptor to not include quotes when obtain account enquiry invoices from MYOB AccountRight Premier/Enterprise.

Version 0.27.1 of the Connector has been released. The details of the release are:

Version: 0.27.1
Date: 06/08/2015
Time Released: 7:51pm AEST

New Features

• Product Account Price data export for Datapel WMS adaptor to export out special pricing from the WMS system.

Improvements

• Micronet Distribution adapter to calculate contract line discount pricing when Product Account Pricing data export is run.
• Product Quantity Pricing data export to timeout after 10 minutes when uploading pricing data to Ecommerce systems.
• Setting in Micronet Distribution adaptor to decide if surcharge lines are added with order lines when the adaptor generates DataConnect order files to import orders in the distribution system.
• Micronet Distribution adaptor to have settings to decide to recalculate the sales order being imported and set price difference in the header field of the CSV Data.Connect order file.
• Setting in MYOB AccountRight Premier adaptor to configure the prefix text set in account enquiry invoice record descriptions.

Bug Fixes

• Datapel WMS adaptor modified to correctly ignore retreiving account enquiry invoices for a customer account when the invoice is a template based on the invoice number containing SPS in the code.

Version 0.26.1 of the Connector has been released. The details of the release are:

Version: 0.26.1
Date: 01/07/2015
Time Released: 9:30pm AEST

New Features

• Generic Adaptor

Improvements

• Address 4 and Organisation Name address fields added to address data exports for all adaptors.
• Address 4 and Organisation Name address field data able to be imported with sales orders into all adaptors business systems.
• SAP Business One adaptor supported for SAP Business One system version 9.1.
• Micronet Distribution adaptor to place freight, minimum order, and credit card surcharge column data in the heade row of the generated order CSV file.
• Micronet Distribution adaptor to set payment method code in a header row of generated order CSV file.
• Micronet Distribution adaptor when running a Product Account Pricing data export now allows discount matrix pricing to be grouped based on each discount category to reduce the amount of pricing records that are calculated and exported.

Bug Fixes

• Invoice records obtained from Micronet Distribution adaptor correctly calculate the quantity ordered and quantity delivered for each line in the record when obtained From Micronet Distribution system.
• Sales orders are now able to be imported when using the MYOB Exo adaptor when a product's description in the order contains more than 40 characters.
• Invoice records now can be obtained from Micronet Distribution adaptor when an invoice contains a line that contains 0 delivered quantity.
• Alternate Products data export from Micronet Distribution adaptor now correctly obtains all alternate product code data.
• Sales Order invoice records now contain be correctly obtained from the Micronet Distriubtion adaptor.
• When an error occurs when calling the Micronet Distribution adaptor to obtain Product Stock levels, the error message log now correctly refers to the Micronet Distribution adaptor.
• Make a requesting through any adaptor to filter the list of customer account records now correctly filters records based on the date range being set to 30-60 days, and 60-90 days.
• The timeout period of the Customer Account Address data exports being imported into an Ecommerce system has now been increased to 5 minutes to allow enough time for the data to be exported.

View the Version History page within the Connector Documentation Centre page to see all version changes.

Version 0.24.1 of the Connector has been released. View the Version History page within the Connector Documentation Centre page to see the latest changed made to the connector.

Version 0.24.1 of the Connector has been released. View the Version History page within the Connector Documentation Centre page to see the latest changed made to the connector.

Version 0.23.1 of the Connector has been released. View the Version History page within the Connector Documentation Centre page to see the latest changed made to the connector.

Version 0.21.1 of the Connector has been released. View the Version History page within the Connector Documentation Centre page to see the latest changed made to the connector.

Version 0.20.1 of the Connector has been released. View the Version History page within the Connector Documentation Centre page to see the latest changed made to the connector.

Version 0.19.2 of the Connector has been released. View the Version History page within the Connector Documentation Centre page to see the latest changed made to the connector.