My client needs to update messy, home grown GP ITEMNMBRs to standardized UNSPSC codes.
Is there a way, maybe a tool, to help set up all the mappings external to GP, and then subsequently bulk process the updates?
So, two questions:
1) Is there a tool/process to aid in the mapping of old ITEMNMBRs into new UNSPSC codes? I understand we will have to use a different field for the new codes.
2) Is it possible to run a bulk modify script to change records to reflect the new codes?
Client has Inventory and Purchasing GP modules.
Thanks in advance,
Ken