Matrix Inventory Management for Acumatica

Matrix Inventory works for a wide variety of product families and attributes such as size/color/style, or pattern/color/width, etc.

Easy Setup


Supports any product attribute scenario including size, color, and style. Create and maintain inventory product families easily and consistently with the matrix inventory creation window.

Easy to Use


Entering matrix quantities in sales order and purchase order modules is easy using the Matrix entry-form order module. Entering many line items becomes quick and simple.

Matrix Inventory Management

Realize significant time savings by automating the inventory entry process and leverage your investment in Acumatica with MaxQ’s Matrix Inventory Management module. Regardless of the type of product or industry this module supports the flexibility of handling an unlimited number of user defined characteristics and works for a wide variety of product attribute types such as size/color/style and waist/length for apparel, size/width for shoes, or pattern/color for flooring.

The greater number of attributes, the more challenging and time consuming it is to create and maintain these items using manual entry. The Matrix Inventory module facilitates the definition, creation, and maintenance of matrix groups and their associated items. It provides mass creation and update capabilities with all or selected variations of product attributes. Items can be created with user defined, or system generated inventory IDs, and intelligent item descriptions constructed from attribute definitions and values.


Define Product Families

Easy to set up product families, supports any number of attributes:

Size, Color, Style
Length, Width
Head Pattern, Length, Alloy, Thread Type
(Basically Anything)

Quick Order Entry

Enter quantities in Sales Order and Purchase Order Modules using the fast inventory matrix entry forms.



Matrix Inquiry

Matrix Inquiry shows all inventory quantities for a product family in one easy to use form.

Inventory Item Maintenance

Set up fields and defaults in the Matrix Inventory Maintenance form for easy inventory item creation and maintenance.


Features and Functionality

Supports a very large number of item groups and attributes (up to 50)
Inserts attribute elements as needed for additional product variation support
Flexibility to choose combinations of attribute values in the creation of inventory items
Auto populates/updates Acumatica’s inventory fields with default and/or specified data for product class, product line, list price, base price, etc. for all or selected matrix items
Ability to handle the use of attributes with more than one matrix
Supports Acumatica’s Inventory Lookup by Attribute by automatically populating inventory item physical attributes with attribute values
Matrix entry screens added to Inventory Items, Sales Orders, Shipping Confirmation, Purchase Orders, and Purchase Order Receipt/Vouchers for multiple quantity entries
Matrix Inventory Inquiry display of all items in a matrix group for inventory quantity viewing
Supports Acumatica’s Inventory Lookup by Attribute by automatically populating inventory item physical attributes with attribute values
Combines attribute captions, attribute values, group description, attribute reference fields, and constants/delimiters when generating inventory item descriptions
Automatically create kits with intelligent component substitution