We imported about 400 new ItemIds and on one of them the user did a mistake and added extra tabs at the end of the itemID e.g. CS04-0006, this does actually work in F&O! And we did not realise there was an issue till 1 month after the import. But then it was too late to change that.

Our idea was to trim any space or tab character at the beginning and at the end of the productID and ItemId to prevent the import of bogus primary keys. This can be done automatically, or with an error, and if Microsoft has customers using this, we can even think of a tick-box somewhere to turn this check on or off.
Needs Votes
Ideas Administrator

Thanks for your input! If it gets voted, we will consider adding it to our long term roadmap. 


Beatriz Nebot Gracia

Program Manager, Microsoft