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 selects all items from Item Master (IV00101) and creates a Dynamics GP macro which can be played back to delete the items. It was created as some items were imported during an implementation and then it was decided to change how items were configured requiring all current items to be removed; there was no transactional data entered so a clean delete was still possible.
/*
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).
*/
SELECT
'# DEXVERSION=18.00.0028.000 2 2
CheckActiveWin dictionary ''default'' form ''IV_Item_Maintenance'' window ''IV_Item_Maintenance''
TypeTo field ''Item Number'' , ''' + RTRIM(ITEMNMBR) + '''
MoveTo field Inactive # ''FALSE''
MoveTo field ''Delete Button''
ClickHit field ''Delete Button''
# Are you sure you want to delete this record?
NewActiveWin dictionary ''default'' form DiaLog window DiaLog
ClickHit field OK
NewActiveWin dictionary ''default'' form ''IV_Item_Maintenance'' window ''IV_Item_Maintenance''
'
FROM
IV00101
