SQL Scripts for Microsoft Dynamics GP: Unmatch and Unmark ABR Transaction Matches

This script is part of the SQL Scripts for Microsoft Dynamics GP where I will be posted the scripts I wrote against Microsoft Dynamics GP over the 19 years before I stopped working with Dynamics GP.

This script which unmatches and unmarks transactions and statement entries in the Advanced Bank Reconciliation module looks to be a variation of this one I posted in February of this year, although the one below is an older version. I think the difference is that this script also unmarks the transaction and statement items as well as removing the match.

/*
Created by Ian Grieve of azurecurve | Ramblings of an IT Professional (http://www.azurecurve.co.uk)
This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0 Int).
*/
DECLARE @BANK VARCHAR(15) = 'CURRENT'
UPDATE

	NCABR012 --NC_Matched_GL_TRX (NCABR012)
SET

	NC_Match_Number = 0

	,NC_Matched = 0

WHERE

	BANKID = @BANK

AND

	NC_Matched > 0
UPDATE

	NCABR011 --NC Matched Statement Trx 11003k (NCABR011)
SET

	NC_Match_Number = 0

	,NC_Matched = 0

WHERE

	BANKID = @BANK

AND

	NC_Matched > 0

GO
DECLARE @BANK VARCHAR(15) = 'CURRENT'
UPDATE

	NCABR012 --NC_Matched_GL_TRX (NCABR012)
SET

	NC_Marked = 0

WHERE

	BANKID = @BANK

AND

	NC_Marked > 0
UPDATE

	NCABR011 --NC Matched Statement Trx 11003k (NCABR011)
SET

	NC_Marked = 0

WHERE

	BANKID = @BANK

AND

	NC_Marked > 0

GO

Read original post SQL Scripts for Microsoft Dynamics GP: Unmatch and Unmark ABR Transaction Matches at azurecurve|Ramblings of an IT Professional