Sales & Inventory Improvements in Acumatica ERP 2020

Acumatica Warehouse

The release of Acumatica 2020 R1 introduced significant new or improved features across the entire cloud ERP platform including our articles specifically on the construction edition and Acumatica mobile app. In this article, we’ll take a closer look at updates to Inventory and Order Management.

NOTE: Acumatica 2021 R2 is now available. Click to check out the newest features rolled out in Acumatica ERP as of September 2021.

Introducing Inventory Matrix Items

Acumatica ERP 2020 R1 introduces a new type of inventory called matrix items.  Matrix Inventory allows you to more easily manage similar items that are available in a variety of attributes such as size, color, pattern or material. This is particularly helpful, for example, in the apparel industry where the same shoe might be available in different sizes and colors.

Without the functionality that matrix items provide, managing inventory for items with multiple attributes can become challenging because changing just 1 attribute of the same item requires a completely new and separate inventory record in many ERP systems NOT equipped with this functionality. In Acuamatica ERP, A matrix item is a stock or non-stock item that corresponds to a physical good or service with particular set of attributes and users can quickly create a wide variety of stock or non-stock items.

Acumatic Matrix Inventory Items Screen

In addition to the new functionality, additional reports and inquiries are now available for matrix items including:

  • Matrix Invoice / Memo
  • Matrix Sales Order
  • Matrix Purchase Order

Correction of Sales Order Invoices

In prior versions of Acumatica ERP, you could not make changes to Sales Order (SO) invoices that had already been released. In addition, SO invoices could not be canceled.  However, with the release of Acumatica ERP 2020 R1, new actions provide the ability to cancel and to correct existing SO invoices with the Open or Closed status.

Cancelling Invoices

On the Invoices form, a Cancel Invoice action has been added. Choosing this option creates an SO credit memo on the same form in the full amount of the invoice being canceled. In the created credit memo, you can change the date, posting period, and description, all of which are copied from the original SO invoice.

Acumatica Cancel Invoice Screen

In the canceled invoice on the Financial Details tab, the Correction Document box shows the reference number of the cancellation credit memo that was prepared for this invoice but have not yet been released. This reference number is a clickable link to view the cancellation credit memo. On release of the cancellation credit memo, it is applied to the original invoice automatically, the SO invoice is assigned the Cancelled status, and the cancellation credit memo is assigned the Closed status.

Correcting Invoices

On the Invoices form, a Correct Invoice action has been added. Clicking this option creates a correction invoice on the same form and copies all information from the original invoice to the correction invoice. In the created correction invoice, you can correct information in the settings, but cannot add new lines or remove existing lines.

Correct invoices in Acumatica

In the correction invoice on the Financial Details tab, the Original Document box shows the reference number of the invoice being corrected. This reference number is a clickable link to view the original invoice. On release of the correction invoice, Acumatica ERP automatically generates and releases a credit memo and applies it to the original invoice. The original invoice is assigned the Canceled status, the credit memo is assigned the Closed status, and the correction invoice is assigned the Open status. In the related sales orders and shipments, Acumatica replaces links to the original invoice with links to the correction invoice.

Note: Currently, there are certain known limitations and situations where correcting and cancelling SO invoices will not yet work (for example, when a payment or credit memo has already been applied). Check with your Acumatica Partner for additional details or if you have specific questions for your unique situation.

Other Inventory Enhancements

There are a variety of other enhancements in inventory and sales order features in Acumatica 2020 R1 including (but not limited to):

Credit Hold Improvements

The process for putting sales documents on credit hold has been improved and simplified

Shipping to Specific Warehouses in Purchases

If the items of a particular purchase request or requisition must be shipped to a specific warehouse, you now have the option of choosing that destination in the Shipping Destination Type box of the Shipping Instructions tab.

Unit of Measure (UOM) Specifications

You can now specify the UOM to calculate the linear dimensions of packages to be used in shipments.

Including Tax in the Cost of Purchased Items

For companies that need to include tax amounts in the cost of stock items, Acumatica ERP 2020 now allows you to configure taxes so that the applicable amounts will be posted to the inventory accounts of the stock or non-stock items being purchased.

User Interface (UI) Updates

A variety of elements in the inventory and order management forms have been renamed or reorganized to simplify screens and streamline your workflow.

Related: Acumatica 2020 R1 Overview

Need Help with Acumatica?

Click below to find an Acumatica partner in your local area that can provide a demo, quote, consulting or software support.


Need ERP Support?

Click to find a Sage or Acumatica partner in your local area.

Related Posts


Join your fellow Sage & Acumatica customers & partners who get our helpful tips sent straight to their inbox!

Success! Get ready for some great articles coming your way soon ...