Skip to main content

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!

 

 

 

 

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

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

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).

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

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. 

Reply


Terms & ConditionsCookie settings
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