What is the best way to show the total on hand qty of combining alternative items?

  • 23 March 2021
  • 3 replies

Userlevel 4


      We are selling food, and we have several similar items, like: Chicken1, chicken2, chicken3, chicken4….   currently, these chicken items are handled in different individual item ids.
       These items are similar only with the Brand difference. 

      So now the management have a need to see the inventory(Qty on hand) of “Chicken” together at once. we previously did this by manually adding different chicken qty together.

       I know Acumatica having item class/item sub class,  item/sub item, matrix item, a lot of ways to define a group. But in my case, which is the best way. Can anyone give me some advice?

3 replies

Userlevel 4


       As I studied item/sub item and  matrix item. I think both the two ways are complicated.

For me ,right now, only report purpose is needed.

     So my solution is to create a sub item class, and assign all the chickens to this sub class.

    And Then I can do reporting by sub class if needed.

Userlevel 1

You can use subitems to take advantage of Inventory Summary showing the total figure for all subitems for an item, but this will require having the same inventory id for all items in the group (they differ only by subitem code), with no possibility (at least as far as I am aware of) to set up different sales and purchase prices for subitems


You essentially just need a common value to link these groups of items together. A relatively low impact solution could be using a stock item attribute. This attribute can then be used in your grouping for generic inquiries and reports to get a sum by attribute value.

I use something similar when we have customers that fall under the same customer class, but we then require more granular reporting on buying groups within that customer class.

Below is a quick example if I wanted to see the On Hand Qty for items that were listed on our advertised promos when group by an attribute [CSAnswers.Value].


Sample Relations
Sample CSAnswers Join




About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2020  Acumatica, Inc. All rights reserved