Keep up to date with the latest information about Microsfot Dynamics GP through articles from the Perfect Image and azurecurve blog.
Fixing Typo in Fabrikam’s Tax Schedule Description
September 1st, 2016 by Ian Grieve
The script in this post fixes a typo, in the Fabrikam sample database, in the Tax Schedule Description whereby the h in Purchases was missing. Not a big thing, but I was working on a report which was configured to return the Description as well as the Tax Schedule ID and it was bugging me.
Hence a script to fix it, so I can easily fix it again in future.
/* Created by Ian Grieve of azurecurve|Ramblings of a Dynamics GP Consultant (http://www.azurecurve.co.uk) This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 2.0 UK: England & Wales (CC BY-NC-SA 2.0 UK). */UPDATE ['Tax Schedule Header Master'] SET TXSCHDSC = REPLACE(TXSCHDSC, 'Purcase', 'Purchase') FROM TX00101 AS ['Tax Schedule Header Master'] WHERE TXSCHDSC LIKE '%Purcase%'