IC Item Number Change Import File Issue

Question

When trying to use an import file for IC Number change we get the following errors before it starts trying(and failing) to read the actual item numbers. We've used this functionality in the past with no problems. Even tried an old import file and still have the issue. It seems to be trying to read way more files than are actually in the spreadsheet. Any ideas? 
 Old code = New code = . Rejected: Invalid Action Code Old code = New code = #. Rejected: Invalid Action Code Old code = New code = $. Rejected: Invalid Action Code Old code = New code = %. Rejected: Invalid Action Code Old code = New code = &. Rejected: Invalid Action Code Old code = New code = '. Rejected: Invalid Action Code Old code = Check Cell&rsquo; New code = &rsquo;. Rejected: Invalid Action Code 
 
 Sage 300 2019 Windows Server 2019 Excel 2019 Saved as Excel 5.0/95 also tried 97/2003

Nathan Kahn · Answer

After much fiddling I've found a format that works. This is a plain text file: 
 "Field1","Field2","Field3","Field4","Field5" "UN-3161","X-UN-3161","0","LONG", 
 Note there is a space after the final comma, but no quotes around the space. The space maintains the current item description. But don't put quotes around it or it won't work. If you want to change the item description, then you can enter a new one in this place and in that case DO surround it with quotes. 
 And LONG is the name of my item structure code.

Sage 300

IC Item Number Change Import File Issue

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING