O'Reilly logo

Microsoft Dynamics GP 2013 Cookbook by Mark Polino, Ian Grieve

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Change data using Modifier

Modifier functions exist in PSTL to allow record IDs to be amended. One such use might be if a non-standard Customer ID was created or if Customer Combiner has been used to combine two customer records which now has a new name and the Customer ID reflects the name. For example, if Pacific Digital was combined with Aaron Fitz Electrical, the merged company may change its name to Fitz Digital and for ease of use the Customer ID in Dynamics GP may need to be changed.

How to do it…

To change the Customer ID perform the following steps:

  1. Make a backup of the SQL Server database.
  2. Open PSTL and select Customer Modifier from Sales Tools.
  3. Click on Next.
  4. In the Starting Customer Number field, enter AARONFIT0001.
  5. In the New Customer ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required