Skip to main content
Solved

Non-stock item import - Error: Item Class cannot be found

  • Oct 29, 2024 6:20 PM UTC
  • 9 replies
  • 271 views
  • Translate All

jhouser
Captain II
Forum|alt.badge.img+7

I exported items from one tenant and am trying to import to another tenant. Item classes have all been configured the same way. I get the following error: Field: Item Class, Value: DIRECT -LABOURBEN , Error: 'Item Class' cannot be found in the system.

I suspect the issue is that item class is actually “DIRECT    -LABOURBEN          ” since segmented key is 30 characters. The values exported without all the spaces, so I tried adding them in Excel before uploading file. However, when preparing data on Import by Scenario screen, values appear without spaces on the end. Acumatica removes them.

Anyone know how I can resolve this? Could be wrong about the cause, open to suggestions. Below are screenshots of the import scenario configuration, error message, and value in Excel. 

Thanks in advance!

 

 

 

 

Best answer by jhouser

I submitted a support case. They exported the item classes from SQL for me. Turns out the required format was to include the trailing spaces for each segment, but exclude the hyphen. 

View original

9 replies

josborn02
Varsity III
Forum|alt.badge.img+3
  • Varsity III
  • Oct 29, 2024 6:23 PM UTC

Can you add the spaces directly into the import scenario Source Field using the & and “ characters?

Translate

jhouser
Captain II
Forum|alt.badge.img+7
  • Author
  • Captain II
  • Oct 29, 2024 7:00 PM UTC

@josborn02 Hmm, how would you format that in this example?

Translate

josborn02
Varsity III
Forum|alt.badge.img+3
  • Varsity III
  • Oct 29, 2024 7:06 PM UTC

Try: =CONCAT(Item Class,     ) or =CONCAT(Item Class,’     ‘)

I think the trailing spaces would be the only issue, as spaces between words would work just fine as they do for other fields (such as description).

Translate

jhouser
Captain II
Forum|alt.badge.img+7
  • Author
  • Captain II
  • Oct 30, 2024 3:12 PM UTC

@josborn02 Thanks for the idea. Tried that and similar formulas, not working unfortunately. 

Translate

jhouser
Captain II
Forum|alt.badge.img+7
  • Author
  • Captain II
  • Answer
  • Nov 5, 2024 4:35 PM UTC

I submitted a support case. They exported the item classes from SQL for me. Turns out the required format was to include the trailing spaces for each segment, but exclude the hyphen. 

Translate

Forum|alt.badge.img
  • Freshman I
  • Sep 25, 2025 8:25 PM UTC

I am trying to setup installation service as a nonstock item but when I try to select Item Class none show up, despite me having Installation and other items setup in Item Class. Can someone help with this?

Translate

jhouser
Captain II
Forum|alt.badge.img+7
  • Author
  • Captain II
  • Sep 25, 2025 9:03 PM UTC

​@jparoski72 Can you please share screenshots of the item you're trying to create, and also settings of the item class you're trying to use?

Translate

Forum|alt.badge.img
  • Freshman I
  • Sep 25, 2025 9:05 PM UTC

 

Translate

jhouser
Captain II
Forum|alt.badge.img+7
  • Author
  • Captain II
  • Sep 26, 2025 12:17 AM UTC

​@jparoski72 Please include screenshot of the class settings on Item Classes screen. 

Translate