Fixing Typo in Fabrikam’s Tax Schedule Description

Microsoft Dynamics GPThe 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 (
This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 2.0 UK: England & Wales (CC BY-NC-SA 2.0 UK).
	['Tax Schedule Header Master']
	TXSCHDSC = REPLACE(TXSCHDSC, 'Purcase', 'Purchase')
	TX00101 AS ['Tax Schedule Header Master']
	TXSCHDSC LIKE '%Purcase%'

What should we write about next?

Your Name (required) –
Your Email (required) –