Is it OK to use a special character in the item number

Can a special charater, such as a / (slash mark) be used in the item number without a problem ??

  • The quick answer is yes. I'm not sure the future issues if/when you decide to migrate off.
  • I would generally avoid it. Besides migrating issues you might have importing issues.
  • Jen and John are correct when they say that special characters can cause problem during importing or migrating the data. I've only seen this really when working with CSV files though. Web Services or APIs using WCF or COM components usually accept values such as item ids as a string value so special characters such as slash (/) are considered part of the string when it is processed.

    I've worked with customers who have used dashes and slashes for their item ids in Sage 500 and have not run into any issues, so you are probable safe to do so as well. If you find in the future that you need to export the data to another system, first determine what method the other system will be using to import the data (CSV files, web service, WCF, etc.) and if it has any limitations about using special characters. Having worked with other systems, I found most don't have any issues with slashes or dashes.

    In regards to CSV files, most of the time placing double quotes (") around the data indicates to most systems to treat everything between the quotes as a string. Example ("SOA", "MyWidget/011", "1,500.34", "Each")