Solved

Simple Import Scenario for Item Attribute

  • 26 December 2023
  • 2 replies
  • 122 views

Userlevel 3
Badge

I’m trying to do a very simple Attribute Import. I created a Data Provider with an Excel doc that has 2 columns:

  • Inventory ID
  • INSZINPLNT

INSZINPLNT is the Attribute ID. I am trying to test import just 1 Item (Inventory ID = FIHYW2). I want the Attribute Value to = ‘2’ 

 

 

2 does exist as an Attribute Value and the Attribute has a Control Type = Combo. I confirmed that I added this attribute to the Item Class for this item. 

Below is what the Import Scenario looks like. I’ve read all the community articles and help articles on this topic and believe I set it up consistently. 

 

When I try to Import the Import Scenario, I get the following error: 

Field: Value, Value: 2, Error: The 406 class does not have the INSZINPLNT attribute. Make sure the attribute name is correct or consider adding the attribute to the class.

I thought I accounted for the Item Class. Is it another class that I’m missing? 

icon

Best answer by Yuri Karpenko 27 December 2023, 00:03

View original

2 replies

Userlevel 7
Badge +6

@lawsont , hi! There are a few things you need to fix with your mapping:

  1. Make the first 2 lines both active.
  2. In line #3, replace Inventory → Inventory ID with simply Inventory ID.
  3. In line #3, in the Source Field / Value, select Inventory ID from the dropdown.

Save and retry. It should work now :) 

Userlevel 3
Badge

That did the trick! Sometimes you just need a second pair of eyes I guess 😀 Thanks @Yuri Karpenko 

Reply


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 — 2024  Acumatica, Inc. All rights reserved