Matrix Items in MYOB Acumatica

MYOB Acumatica Tips and Tricks #9

In MYOB Acumatica Release 2020.3, a new type of inventory item is now available – referred to as Matrix Items.  Matrix type inventory items typically have two or more attributes that make each SKU unique.  Colour, Size, Capacity, and Material are all attributes that can be designated.

In many ERP systems, managing inventory with multiple attributes can become challenging. Changing just a single attribute of the same item requires new and separate inventory records. In MYOB Acumatica (formerly MYOB Advanced), both Stock and Non-Stock items can be flagged as Matrix items, enabling users to create a new set of stock items quickly and easily by taking advantage of higher-level template settings.

How do I create Matrix Items?

To make use of Matrix Items, the functionality first needs to be enabled in the Enable / Disable features screen.  Select Matrix items located in the Inventory and Order Management Group.

In the following example we will trace how Matrix Items are created and used.  The scenario relates to mobile phones where there are various models frequently released in different colour and capacity options.

In this instance, attributes will be required for capacity and size.

MYOB Advanced Matrix Items Capacity Attributes
MYOB Advanced Matrix Items Colour Attributes

The attributes must have the combo control type.

**Tip: Consider the length of the Value ID when creating these attributes, as they will impact the Inventory Item ID further down the path.

The respective item class is then required to have the item attributes specified.

MYOB Advanced Item Attributes Feature

**Tip: The category of “Variant” indicates that this attribute can be used in generating matrix items.

Creating template items

A Template Item is now required to be created.  Note that Template Items cannot be added to Accounts Receivable, Accounts Payable, Purchase Order or Sales Order documents.

When creating a Template Item, first specify the Item Class under the General Settings.

Under the Attribute Configuration specify how the matrix item, its code and description, is to be built by referencing the attributes.

  1. First, select the attributes to be used
  2. Specify which attributes is be set as the default Column and Row
  3. Specify how the Inventory ID is to be formulated when creating new items
  4. Specify how the Inventory Description to be formulated when creating new items
MYOB Advanced Template Items Feature

This screen can also be used to quickly apply updates to details   and replicate these changes to all inventory items that were created from this template.

Using the Create Matrix Items screen

The Create Matrix Items screen enables the selection of different combinations of Colours and Capacity that may be released.

MYOB Advanced Create Matrix Items

Selecting the Create Matrix Items button will provide a series of inventory items to be confirmed for creation of each of the selected combinations.

Note there is a constraint on the length of the inventory item key.  If the inventory code to be created exceeds the specified maximum, then the item key length may need to be increased.

MYOB Advanced Inventory Item Key Feature

Matrix Items in Purchase and Sales Orders

Working with Matrix items has now become easier with tools now available on the Purchase Order and Sales Order screens enabling the user to quickly select each required combination of SKU.

An Add Matrix Item button will be visible on the grid Header of these screens.

MYOB Matrix Items Purchase and Sales Orders

Selecting the Add Matrix item button, then selecting the required Template ID and the option to Open Matrix View, enables the user to quickly select the required quantity of each combination to add to their Purchase Order or Sales Order.

MYOB Advanced Add Matrix Item

Interested in other ways to optimise MYOB Acumatica?

Check out our handy MYOB Acumatica Tips and Tricks blogs here:

  1. Generating On-Demand Statements in MYOB Acumatica
  2. The New User Interface – MYOB Acumatica
  3. Row-Level Security in MYOB Acumatica
  4. Generic Inquiries in MYOB Acumatica
  5. Fixed Assets in MYOB Acumatica
  6. Business Events in MYOB Acumatica
  7. Restricted use of Control Accounts in MYOB Acumatica
  8. Corporate Cards in MYOB Acumatica
  9. Matrix Items in MYOB Acumatica
  10. Restricted Visibility of Customer and Supplier Records
  11. Important features of reporting dashboards
  12. The Global Search Function in MYOB Acumatica
  13. Learn to Streamline your Intercompany Sales
  14. Simplify Your Cross-Company Sales
  15. Adding one-off public holidays to MYOB Acumatica Payroll
  16. Deferral Schedules in MYOB Acumatica
  17. Keyboard shortcuts to improve efficiency in MYOB Acumatica
  18. 3 Steps to Archive Documents in MYOB Acumatica
  19. How to streamline EOFY reconciliations in MYOB Acumatica
Need help icon

MYOB Acumatica Ultimate Compilation of Tips and Tricks eBook

Download now

We hope these tips and tricks were helpful to you! If you have any questions about Matrix Items in MYOB Acumatica, our friendly team is here to help. Call us on 1300 857 464 (AU) or 0800 436 774 (NZ), or send us an email.

Alternatively, for a comprehensive overview of all of our best MYOB Acumatica ‘hacks’ in one place, you can download our PDF from the panel on the right – The Ultimate Compilations of Tips and Tricks!

Accolades
MYOB Diamond Partner
MYOB ANZ Partner of the Year 2023 Badge
MYOB Consultant of the Year 2023 Badge
Velixo Award 2024
Velixo Award 2023
Prospend 2023 partner of the year
Consultant of the Year Award
ES-HIGH-ACHIEVER-AWARDS-2021-EX-BUS-DEV-AUS
ES-PARTNER-AWARDS-2021-RGB-Exc-Bus-Dev-Exo-AU_reversed
PARTNER-AWARD-2020-EXBUS-EXO-AU
MYOB-WARD-EXCEL-BUS-DEV-EXO-2019-AU
Velixo Award 2019
AwardPartner2018-2x
Business awards logo
AwardPartner2016-2x
Excellence in Business Development 2015 AU
MYOB EXO Award 2015
AwardPartner2013-2x
AwardSolutions2012-2x
Telstra Awards 2012