azurecurve

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 updates items with an Item Number starting 0 to a status of Discontinued.

As with any script, before running on production test the script to make sure it works and have a good backup of the database.

/*
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).
*/
UPDATE
	IV
SET
	IV.ITEMTYPE = 2
FROM
	IV00101 IV WHERE IV.ITEMNMBR LIKE '0%' AND IV.ITEMTYPE <> 2
GO

Click to show/hide the Series Index


New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1Specify Dimensions on Posted Entries Applications With Realized Gains or Losses
New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1Specify Dimensions on Posted Entries Applications With Realized Gains or Losses
New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1Specify Dimensions on Posted Entries Applications With Realized Gains or Losses

I use Vivaldi as my main browser on desktop PC, tablet and mobile phone. I typically install the same extensions on each of them (excluding mobile which I don’t think supports extensions), but have sometimes installed them in a different order which means they end up in a different order on the toolbar (I regularly use about four computers and one tablet).

I have Google Translate installed on all of them as I listen to a lot of German music and my German is still rudimentary, although I am actively learning.

I prefer Google Translate to show up in the left-most position, but it is only there if I install it first.

Extensions can be reordered:

On a touchscreen tablet you need to press and hold and then drag to the new position.
On a traditional desktop a lot of online resources say to hold shift down and drag and drop, but this does not work; you actually need to hold down the control key while you drag and drop.