Skip to main content
Answer

Stock items with multiple attributes

  • November 8, 2024
  • 4 replies
  • 116 views

dpruckus
Freshman I
Forum|alt.badge.img

How do you handle stock items that have multiple attributes, like different colors, sizes, etc.? In my previous ERP, I had a single product ID with multiple attributes. For example:

  • 001 Pants (Green/Brown/Red)
  • 002 Shoes (Green/Brown/Red)


In that system, I only needed to create one SKU and assign multiple attributes. However, in Acumatica, it seems like I need to create a new ID for each variation. Am I missing something?

Best answer by iqraharrison

@dpruckus 

I do believe Matrix items is the best way to manage stock items with multiple attributes such as color and size however, are you able to use an alternate ID on the item profile? i believe it’s on the cross-reference tab.  it looks like you could specify the same vendor part number for multiple stock items.  

4 replies

Laura03
Captain II
Forum|alt.badge.img+19
  • Captain II
  • November 8, 2024

Hello,

I think you are looking for “Matrix items.” Search the help, You Tube and this community, for help and ideas. 

Laura


Laura03
Captain II
Forum|alt.badge.img+19
  • Captain II
  • November 8, 2024

Hello, My first post is delayed for review by moderators. I think you are looking for matrix Items.

Laura

 

 


dpruckus
Freshman I
Forum|alt.badge.img
  • Author
  • Freshman I
  • November 8, 2024

Hello, My first post is delayed for review by moderators. I think you are looking for matrix Items.

Laura

 

 

Yeah, well it still creates a separate inventory id for each. Its kinda tricky, as our supplier has only one for the item, and color is as an attribute, so for me there is no way to match this two together. I probably need to re-think my process here if that's how AC works.


iqraharrison
Captain II
Forum|alt.badge.img+8
  • Captain II
  • Answer
  • November 11, 2024

@dpruckus 

I do believe Matrix items is the best way to manage stock items with multiple attributes such as color and size however, are you able to use an alternate ID on the item profile? i believe it’s on the cross-reference tab.  it looks like you could specify the same vendor part number for multiple stock items.