Noble Matrix Updates

Note: you must backup your company database prior to performing this upgrade. Any unposted general ledger journals must be flushed through to Vision (see your End of Month Processing Chapter in the Matrix Manual). Also you must do a reindex in both Vision and Matrix prior to installing this release You must also do another reindex in Matrix after installing any update.

Useful Scripts

There are a number of useful scripts for the use of Matrix Support Consultants and Matrix Power Users for checking and repair purposes only. Note: You must backup databases prior to running any scripts and results validated before continuing general operation. Click here to download the scripting engine and most common scripts.

What's new in Build 431 - 7 December 2011

Included in this build are the following:

  • Allows General Ledger items to be added to Sales Orders and correctly flows through to the Sales Invoice. This has been done to work with the SPNet eCommerce Solution which posts sales orders into Vision with freight as general ledger (rather than non-diminishing stock).

Components:

Note: with this release you should recalculate Sales Orders and Purchase Orders (from the Matrix Utility drop down menu) prior to running any reports based on Orders (such as Picking Lists and Order Reports). This is a known issue that will be addressed in a forthcoming build

What's new in Build 429 - 13 March 2011

Included in this build are the following:

  • Fixes a problem with build 428 that does not allocate the Last Cost on non diminishing stock items (such as Freight), on the line items of sales invoices
  • A script Fix_AmtUCost.axs that repairs the data retrospectively

Components:

Note: with this release you should recalculate Sales Orders and Purchase Orders (from the Matrix Utility drop down menu) prior to running any reports based on Orders (such as Picking Lists and Order Reports). This is a known issue that will be addressed in a forthcoming build

What's new in Build 428 - 12 February 2011

Included in this build are the following:

  • Tested with Sybiz Vision version 10 
  • With Sales Credits where there is no stock on hand, returned stock is valued at last purchase cost rather than zero cost as in previous versions
  • Fixed a problem where Sales Credits which included non-style items were removed rather than returned to stock.
  • Sales Invoices based on Sales Orders now record the gross margin of the stock sold at the time of the sales invoice rather than the time of the sales order was raised.

 

What's new in Build 424 - 19 November 2010

Included in this build are the following:

  • A fix for credit notes that include general ledger items. Previously these sorts of transactions would cause Matserve to drop out. 

What's new in Build 423 - 13 July 2010

Included in this build are the following:

  • A fix for single location inventory databases that resolves a problem with Matserve shutting down. This problem arose from build 421. 

What's new in Build 421 - 9 June 2010

Included in this build are the following:

  • Changes the way styletakes (stocktakes for styles) and purchase and sales invoices post to the general ledger on multi-location databases. Previous versions would average the costs across multiple locations. From build 421 postings to the general ledger are calculated on the specific stock costs applicable to the location the stock is stored at.

What's new in Build 420 - 31 May 2010

Included in this build are the following:

  • Fixes a problem with Foreign Purchase Orders where the unit cost is shown in the Vision Viewer as local currency whereas it should be shown in the foreign currency.

What's new in Build 419 - 16 November 2009

Included in this build are the following:

  • Allows entry of delivery dates for Purchase Orders in the same way as Sales Orders. You do this by entering a future date in the Purchase Order date field and the system will ask you to confirm if you would like to set all line items on the Purchase Order to that date. This is a short cut to changing the delivery dates for individual line items on an order

What's new in Build 418 - 9 November 2009

Included in this build are the following:

  • Excludes zero quantities on Outstanding Customer Sales Orders Reports and Picking Lists
  • EDI Sales Invoice Export now specifically includes barcodes rather than the SKU (which in earlier versions doubled up as the barcode)
  • a series of defensive unlocking procedures to remedy an issue where the inventory table was locked if two or more users were simultaneously invoicing the same same style at precisely the same time.

What's new in Build 416 - 14 October 2009

Included in this build is the following fix:

  • Now allows Refresh of an individual style when a default season filter has been applied
  • Colours of Styles with codes contained within other styles may be unintentionally merged. For example Style code: ABC may have inherited the colours of style code: ABC1. This results in stock items automatically generated with a barcode as it's stock code rather than the normal style/colour/size. This problem can be repaired by running the redostylestockcodes.axs script.

What's new in Build 414 - 1 October 2009

Included in this build are the following fixes (affecting build 403 and later):

  • Free Stock (Stock on Hand plus Purchase Orders less Sales Orders) now displays for the currently selected location. Previous builds showed the available stock as a total across all locations.
  • Removed the warning message "LOGMSG doesn't exist" in the Matrix Log (for Matserve) and onscreen for non-Matserve sites.
  • Sales Stats on the Vision Summary Screen are now correctly calculated and displayed.

What's new in Build 413 - 11 August 2009

Included in this build is the following fix:

  • On "Stock" items the sales analysis code was incorrectly set to the first one rather than the "Default" code specified in the Customer Record. Note: this only occurred when the Stock item did not have a default sales analysis code associated with it. This fix affects only build 412 released on the 22nd July 2009

What's new in Build 412 - 22 July 2009

Included in this build are a number of fixes and improvements including the following:

  • Now automatically sets the Vision Sales and Purchase Order completed flags when orders are fully delivered. Note: you will need to run the CheckOSitems.axs script to retrospectively set these flags on existing orders.
  • Now allows you to raise a Sales Credit in Sybiz Vision for a Sales Invoice raised in Noble Matrix. Note: Sales Invoices raised prior to build 410 will need to be repaired by running the CheckDeliveries.axs script.
  • Now allows you to raise a Purchase Credit in Sybiz Vision for a Purchase Invoice raised in Noble Matrix. Note: Sales Invoices raised prior to build 410 will need to be repaired by running the CheckDeliveries.axs script.
  • Repaired a display problem in the Sybiz Vision Viewer whereby Sales Credits did not appear in the transaction history of the inventory item.
  • Tax Rounding for General Ledger Line items and Stock (non-Style) items in trasactions now adopts the Tax Rounding Options set in the Utilities Drop Down menu in the Localisation tab
  • Transactions with General Ledger line items in Australian databases did not include GST. Note: Most Matrix sites do not process transactions direct to the General Ledger but through non-diminishing stock items (such as Freight), which correctly calculates GST. This method is the recommended approach to processing non-Style entries on transactions.
  • Insufficient Stock Warnings have been added to Sales Deliveries. Previously they were available only on Sales Invoice transactions.

 

What's new in Build 409 - 4 June 2009

Included in this build are a number of fixes and improvements including the following:

  • Removes the ability to raise a Credit Note from a Sales Return to align with workflow in Sybiz Vision.
  • Fixes a problem with credit notes raised from sales invoices whereby the reference number generated is incorrect and the Quantity Returned is the wrong sign. To retrospectively repair sales credits created prior to installing this release, please download and run this script.
  • Also includes the change in build 407 that fixes a problem with editing purchase orders under certain circumstances that results in negative values on the documents. To retrospectively repair purchase orders created prior to installing this release, please download and run this script.

What's new in Build 407 - 5 May 2009

Included in this build:

  • New report: "Summary of Styles in Production"
  • Fixes a problem with editing purchase orders under certain circumstances that results in negative values on the documents. To retrospectively repair purchase orders created prior to installing this release, please download and run this script.

What's new in Build 405: - 30 Mar 2009

Fixed an error message that displayed whilst performing Stock Transfers on databases configured to post to the General Ledger by Product Groups.

What's new in Build 404:

Minor adjustment to GST to adjust the total calculated GST on a document line by line basis to the calculation of the complete document.

What's new in Build 403:

  • You can now define a barcode against a pack defined as a distinct stock item
  • Sales and Purchase transactions with only General Ledger caused Matserve to drop out - Fixed.
  • Purchase invoices were picking up the exchange rate from the Sybiz Buy rate rather than the Sell rate - Fixed
  • GL journal associated to foreign currency purchase invoices was incorrectly posting to the Stock on Hand accounts in COS and the Balance Sheet in the foreign currency rather than the local currency - Fixed.
  • Making inventory items inactive doesn't work when scrolling styles with more than 15 sizes - Fixed.

  • Various issues relating to Tax Rounding have also been fixed.

What's new in Build 402:

  • Sales Credits with Stock (non-style) items now correctly selects the default GST Code
  • Added a new Barcodes Listing Report by Supplier
  • The Agent field is no longer displayed on Purchase transactions
  • Customer records are time stamped for date created and date edited
  • Fixed a problem with the GST rounding under certain circumstances
  • Now has GST default codes on Stock and Ledger items as well as Styles

  • Activated user rights setting prohibiting Sales Orders and Purchase Orders

What's new in Build 398:

  • Implemented Sales Returns
  • Sales Credits can now be based on Sales Returns as well as Sales Invoices
  • Postings to the General Ledger for Stock on Hand in the Balance Sheet and Closing

  • Sock in the Trading Statement  are now performed by Sales Deliveries/Sales Returns or in Sales Invoices or Sales Credits when there is no related Delivery/Return.

What's new in Build 395:

  • Special prices has been enhanced to include percentage discounts on specific product groups
  • Agents Commission reports are now based on 4 decimals to minimise rounding issues
  • The GST Codes for General Ledger items in transactions are now initialised to what was set in Vision.
  • Various NZ GST fixes.
  • New option in Utilties/Options that allows you to specify the location of the Vision Viewer for each user.
  • Sales Deliveries can now be performed where a previous Sales Order has not been processed (a quick sales order is automatically generated in this case).
  • Branch as well as Head Office Remarks are displayed on transaction screens.
    Inter-branch stock transfers now use the branch transfer account specified in Vision.


What's new in Build 385:

  • Correctly handles both GST Free and GST Applies items on the same transaction
  • Handles GST inclusive selling prices on Styles (note: still treats all "Stock" sales as GST Exclusive.)
  • Summarises General ledger journals again. (note: requires a re-index in noble Matrix after installing this build.


What's new in Build 381:

Removed the "All Locations" selection from the Locations/Branch drop down in Production (Bill of Materials and Jobs).

What's new in Build 379:

This build repairs a problem on product discount on sales orders that have been edited many times.

What's new in Build 376:

This build incorporates some fixes and adds a new report called "GL Reconcilation with Debtors Ledger Report" in the "Customers" category of Standard Reports. This report summarises Sales Invoices, Sales Credits, Journals, Receipts, Payments and compares these to the movement in the General Ledger.

What's new in Build 372:

This build restricts the use of options 3 of build 371 to operators only with the ability to edit system tables.

What's new in Build 371:

This build will only work with Vision 6.0 and later and includes the following changes:

  • Microsoft Vista™ Support
  • Added a new option called "Failed Transactions" under the "Utilities/Server" Drop Down Menu that displays any MatServe transactions that failed to complete. We've noticed on some sites that have aggressive Anti Virus systems that scan all files that it is possible that excessive delays cause the Matrix Server to fail to process some transactions. If you use MatServe, we recommend you run this new option to interrogate the Matrix Server Log and report to us if any items are listed. We also highly recommend your Server's Anti-virus is configured to exclude from virus scanning the following file types: DBC, DBF, FPT, CDX
  • Added a new option in Utilities called: "Align Sales Margins to Standard Costs" which changes the cost of existing sales invoices to match the "Standard Cost" stored in the Style Maintenance Screen
  • Now automatically sets up the workstation if MatServe is detected without displaying a warning message.
  • There is a new field called Inventry.ExtPartNo is available in all Transaction Forms that will display the Supplier Part Number where the Matrix Layout is not required or the stock item is not a Style item. For Style items, there is still the styleprn.Supp_Part field available
  • A warning message now displays when trying to start, edit or end a production job where a bill of materials has not been defined for the appropriate location.
  • Repair to a problem where the average cost of a split production job was incorrectly calculated.

Known issue: there are some refresh problems on some screens due to subtle changes to the latest Microsoft Runtime Libraries. This has necessitated rewrites of some screens - a mock-up of a transaction screen is included in the "Transaction" Drop Down Menu for your valued feedback.

What's new in Build 365:

This build is compatible with Sybiz Vision 6.0 and includes the following changes:

Now allows a special price for customers/suppliers of $0.00.

What's new in Build 364:

This build includes the following changes:

  • General Ledger postings now can be expanded to support posting to a Work in Progress account in the trading statement. You will need to edit the setup of each stage of production and select the appropriate general ledger account to use this feature.
  • All the fields in the Inventory Table are now accessible to the Forms editor including fields such as the Supplier's Part number (inventry.extpartno).
  • You can now toggle from Postal Address, Delivery Address and Delivery Instructions in the Transaction screens by clicking on the address area.
  • A number of new standard reports including Stockists, Stock Position, Sample Catalogue with Barcodes, Free to Sell and many others

What's new in Build 363:

This build is compatible with Sybiz Vision 5.0 and includes the following changes:

  • Fixes a problem introduced in Build 361 that would not allow entry of zero selling prices
  • The generic styleprn.frx/frt invoice/order/credit form now handles accounts that you would like to use the mailing instructions as a delivery address without having to have a separate account for a delivery address as you would when you have a head office/branch scenario with chain stores. Note: this build still picks up the Delivery Instructions as the default when you click on the Instructions push button but does not write back to the customer record any changes made. A forthcoming release will introduce a switch that will allow you to chose to a) pick up a default Instruction b) write Instructions back to the customer record and c) whether to display the Mailing Address or Delivery Instructions on the Main Transaction Screen.


What's new in Build 361:

This build is compatible with Sybiz Vision 5.0 and includes the following changes:

  • Splitting a production job now apportions the costs of component costs on the basis of the proportion of the split. This results in more precise costs of finished goods and the calculation of margins of goods sold prior to the entire production job being completed.
  • Entering of Net Price after Discount and Tax now correctly calculates the Gross Price. Previously it was only possible to enter the Gross Price, and then enter Discount to display the Net Price.

What's new in Build 353:

This build includes the following changes:

Fixed a problem with the Production which occurs from build 349. If you are not using the Bill of Materials and Production Module there is no need to install this build if you are already on build 352.

What's new in Build 352:

This build includes the following changes:

  • Fixed an issue which confused styles such as ABC1234 with ABC12 in the selection screen of the special prices module
  • Added a new option in the general section of the options dialogue box to remember the setting that displays transactions in the Style/Colour/Size Matrix. The default is to print in Style/Colour/Size mode. Previous to this release the setting to not display in the Style/Colour/Size Matrix mode was active only for the life of the current session.

What's new in Build 351:

This build includes the following changes:

  • Price of Style set to the special price for quantity of 1 as a default.
    Added special buy prices in the Supplier maintenance screen and Style maintenance screen
  • Added new report: "Special buy prices from Suppliers" in the "Styles" Report Category.
  • Warning message displayed when an unit cost at stock adjustment screen is in excess of the first selling price.
  • Added a warning when renaming a style code in the style maintenance screen

What's new in Build 350:

This build includes the following changes:

  • Allow special prices that are higher than the normal price for the customer group. A warning is displayed that the price is higher.
  • Added an option to round tax up for half cents and higher rather than the default of truncating to 2 decimals (click on image below to view full size)


What's new in Build 349:

This build includes the following changes:

Fixed a problem in Purchase Orders and Invoices whereby the wrong purchase cost was being assigned to a Style where Style Special Prices have been entered (only affects build 348)

What's new in Build 348:

This build includes the following changes:

  • Added a new report in the Styles Categories for Style Special Prices by Customer
  • Added a "Specials" push button in the Customer Maintenance screen which displays all styles with a special price for the currently selected customer. Also allows you to change, delete and add new specials
  • Fixed a problem with the selection of special prices where style codes were similar

What's new in Build 346:

This build includes the following changes:

  • The Option: "Rewrite Titles on Style Refreshes" has been moved from User Options to General Options
  • Added a new "Specials" button in the Style maintenance screen which allows special pricing per customer based on minimum quantities for the current style.

What's new in Build 345:

This build includes the following changes:

Corrects a problem with running finance charges where there are zero value invoices (such as repair invoices).  There is also a utility in the Support section of Standard Reports that repairs any past zero value invoices.

What's new in Build 344:

This build has been tested with Sybiz Vision 4.0 and includes the following changes:

  • Added a new report in the Stocktake category: Stock Adjustments by Product Group
  • Added a new report in the EDI category: Stock Inconsistencies between EDItech and Matrix
  • Increased number of decimals of the transfer rate in Style Transfer from 2 to 6

What's new in build 343:

  • Added new commission report based on cash receipts by allocated agent for delivery accounts. Useful for customers that belong to buying groups.
  • Fixed forward dating of credit notes problem which caused a reconciliation problem as the transaction was dated in the forward month but the general ledger was posted to the current month.
  • Fixed a problem with forward dated credit notes where the transaction was correctly processed in the current month but the corresponding journal entry was incorrectly accounted for in the forward date causing a reconciliation complication.
  • All sales transactions must now be allocated to a sales analysis code during the sales transaction screen. This will help reconcile Agents Commision reports.
  • Sales invoices now allow changing of sales analysis codes (agents/reps) from the code specified in the sales order. Previously the sales analysis code specified in the sales order was not overwritten.
  • Added a new report in Sales Orders (Outstanding) called Margin Analysis by Product Group by Customer (delivery date range) .
  • Fixed a problem where it was possible to raise a sales invoice to an inactive customer.

What's new in build 340:

  • Now uses Microsoft Visual Foxpro 8.0 and requires a full installation. This version of FoxPro seems to improve the reliability of the software especially when working on very long orders. There are some minor incompatibilities in connection with the screen redrawing and background being lost after modifying report layouts etc. This can be overcome by not using Windows XP Themes.
  • Added new report: "Barcodes allocated to Styles (non contiguous)" which allows you to specify up to about 20 styles and produce the barcodes list. This report is much faster than the existing report which allows you to select a contiguous range of styles.

What's new in Build 339:

  • Added the ability to add custom deliminators apart from the standard "/" between Style and Colour, and Colour and Size. This can be found in the "Options" screen from the Utilities drop down. Note: if you would like to maintain total compability with earlier builds, you must add a "/" in both deliminator fields.
  • Added the ability to add custom construction string of the inventory description apart from the standard "Style Colour Size Description". This can be found in the "Options" screen from the Utilities drop down. An empty construction string retains the previous builds behaviour. Care should be taken when using this field. Only the following fields are available: style_code, style_name, colour_name, size_name, season_name. Note: Contact your authorised Noble Matrix consultant prior to entering anything in this field.
  • Fixed a problem with rounding on any GST other than 10%. This was apparent on New Zealand databases with 12.5% GST.