Change data using Modifier

Modifer functions exist in PSTL to allow record IDs to be amended. One such use might be if a non-standard ItemNumber was created or if ItemNumber Combiner has been used to combine two item records that now have a new name and the item number reflects the description. For example, if Attr. 5352-Red was combined with Attr. 5352-Wht, the merged Item Number may change its description to Attr. 5352-Wht/Red and for ease of use the Item Number in Dynamics GP may need to be changed.

How to do it…

To change and item number from an existing ID to a new one, follow these steps:

1. Make a backup of the SQL Server database.
2. Open PSTL and select Item Number Modifier from Inventory Tools.
3. Click Next:
   
4. In the Starting Item Number, enter PHON-ATT-53RD.
5. In the NewItem Number, enter PHON-ATTR-53RD/WHT.
6. Click Convert.
7. Click Continue on the warning prompt regarding having a backup of the SQL Server database.

There's more...

As with the Combiner function discussed in an earlier recipe...