SQL Scripts for Microsoft Dynamics GP: Update Inactive Flag on Items from CSV

Posted By Ian Grieve on 25 Jan 2023 in Dyn365GP

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 update the inactive flag on items from a CSV allowing items to be set to inactive or back to active en masse.

/*
Created by Ian Grieve of azurecurve | Ramblings of an IT Professional...

Continue Reading azurecurve’s Article on their blog

https://www.azurecurve.co.uk/2023/01/sql-scripts-for-microsoft-dynamics-gp-update-inactive-flag-on-items-from-csv/

Blog Syndicated with azurecurve’s Permission

More About This Author

Ian Grieve

Array

Array

• Dyn365GP2023.01.27SQL Scripts for Microsoft Dynamics GP: PO Receipt History View
• Dyn365GP2023.01.27SQL View to Return the Accounting Period Starting and Ending Dates in Microsoft Dynamics 365 Business Central
• Dyn365GP2023.01.26SQL Scripts for Microsoft Dynamics GP: SQL Trogger on PO invoice Insert to Change GL posted Date
• Dyn365GP2023.01.26Inactive OneDrive Account Cannot be Removed