Month: August 2022

Get Serial Number Count and Length in Microsoft Dynamics GP

Ian Grieve3 minute read0 comment

Microsoft Dynamics GPI needed to check how many serial numbers were assigned to sales transactions and the cumulative length of them. I’m not aware of any function in Microsoft Dynamics GP which would give me this information, so I wrote the below SQL statement to return both values along with the transaction type and document number.

It selects from the Sales Serial/Lot Work and History (SOP10201) table which, allowing for a simple statement, includes both the work and history data (SOP transactions don’t have a status of open).

/*
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
	SOP.SOPNUMBE AS 'SOP Number'
	,SOP.SOPTYPE AS 'SOP Type'
	,SOP.LNITMSEQ AS 'Line Item Sequence'
	,COUNT(1) AS 'Serial Number Count'
	,SUM(LEN(SOP.SERLTNUM)) AS 'Serial Number Length'
FROM
	SOP10201 AS SOP -- Sales Serial/Lot Work and History (SOP10201)
GROUP BY
	SOP.SOPNUMBE
	,SOP.SOPTYPE
	,SOP.LNITMSEQ
ORDER BY
	SUM(LEN(SOP.SERLTNUM)) DESC

Show Bookmarks in Word

Ian Grieve2 minute read0 comment

Microsoft OfficeBookmarks are not shown in Microsoft Word by default; this minimises the risk of someone accidentally deleting or changing a bookmark. However, sometimes you do need to make them visible.

I had to do this recently, but really had difficulty finding the setting.

To enable the display of bookmarks, click on File and select Options.

In the Word Options window, select Advanced and scroll down to Show document content; the fifth setting down is Show bookmarks. Mark this setting and click OK:

Word options

Fixed Asset Depreciation Not Calculating in Microsoft Dynamics GP

Ian Grieve2 minute read0 comment

Microsoft Dynamics GPI was on a call with a client the other day looking at a few issues with them in Microsoft Dynamics GP. One of the issues was that they had been setting up the Fixed Asset Management module, but when they ran depreciation, nothing happened.

We did some exploring and the only difference I could find, from who I would have normally configured the module, was that the Fixed Asset Calendar ((Financial » Setup » Fixed Assets » Calendar)) had been configured only for the required years starting in 2020; I usually set it up for a 200 year period.

The first asset being setup was dated in period 12 of 2020 so there is no logical reason why prior years should be needed. However, after we added 2019 into the calendar and re-ran the depreciation, all of the assets depreciated correctly.

Installing Microsoft Dynamics 365 Business Central 2022 Wave 1 On-premise Demo: Client Login

Ian Grieve1 minute read0 comment

Microsoft Dynamics 365 Business CentralThis post is part of the Installing Microsoft Dynamics 365 Business Central 2022 Wave 1 On-premise Demo series in which I am creating a demo series for learning/demonstrating Business Central.

With the Business Central demo environment installed we can now log in for the first time which you will need to do using the account which did the installation.

While Business Central is not a desktop application, the server will have a shortcut added to the Windows Start menu for the web client:

Windows Start menu

Continue reading “Installing Microsoft Dynamics 365 Business Central 2022 Wave 1 On-premise Demo: Client Login”

Git Command Line Snippets: Add, Commit and Push Changes

Ian Grieve2 minute read0 comment

GitHubThis post is part of the series on Git Command Line Snippets where I am taking a look at performing actions on GitHub using the git command line.

There are three steps required to add your changes to a GitHub repository:

  1. Add
  2. Commit
  3. Push

Fistly, you need to add your changes; it is possible to only add specific files, but in my case I always want to add everything; this command will add all changes including added changed or deleted files and folders:

git add --all

Once you have added the changes, you need to commit them; you can supply a commit message, but this should be a maximum of 55 characters.

git commit -m "Release for x and y"

Once you have committed the changes, you need to push them to GitHub for them to appear in the repository:

git push

Git Command Line Snippets: Choose Repository

Ian Grieve2 minute read0 comment

GitHubThis post is part of the series on Git Command Line Snippets where I am taking a look at performing actions on GitHub using the git command line.

I am new to working with the git command line so have spent a bit of time reading articles. One thing a lot of them say is to “choose your repository” and then tell you to run commands. When I was doing this it was a bit late and I’d been working all day (getting my excuse in early), but I didn’t immediately understand what they meant.

All it means when they say to choose your repository, is to navigate the command prompt to the repository folder on your computer.

In command line you can simply use cd followed by the path: to navigate to the required folder

cd C:\Users\azurecurve\Documents\Development\ClassicPress Development\azrcrv-smtp

In PowerShell you can largely do the same thing but must wrap the path in double quotes if the path contains a space:

cd "C:\Users\azurecurve\Documents\Development\ClassicPress Development\azrcrv-smtp"

Installing Microsoft Dynamics 365 Business Central 2022 Wave 1 On-premise Demo: Server Installation

Ian Grieve1 minute read0 comment

Microsoft Dynamics 365 Business CentralThis post is part of the Installing Microsoft Dynamics 365 Business Central 2022 Wave 1 On-premise Demo series in which I am creating a demo series for learning/demonstrating Business Central.

Once you have downloaded the media, extract the files and launch the setup utility. On the Welcome step, click Next:

Welcome to the Microsoft Dynamics 365 Business Central Setup

Continue reading “Installing Microsoft Dynamics 365 Business Central 2022 Wave 1 On-premise Demo: Server Installation”

Installing Microsoft Dynamics 365 Business Central 2022 Wave 1 On-premise Demo: Download Software

Ian Grieve2 minute read0 comment

Microsoft Dynamics 365 Business CentralThis post is part of the Installing Microsoft Dynamics 365 Business Central 2022 Wave 1 On-premise Demo series in which I am creating a demo series for learning/demonstrating Business Central.

When I first downloaded Business Central, I had a false start as I found a page of download oinks on the Microsoft Docs website, but the latest version on there was 2020 Wave 2. I assumed this was the latest release avaiable as on-premise, but later found other download links which had the Release 2022 Wave 1 download.

I’m not sure why Microsoft switched the download locations, but the new location only appears discoverable via a web search and not browsing from the Microsoft Docs site where the rest of the Business Central documentation is located.

When you click download, you get to choose a language to download; I opted for the UK language version which is Dynamics.365.BC.38230.GB.DVD.zip.

Installing Microsoft Dynamics 365 Business Central 2022 Wave 1 On-premise Demo: Selected Server Configuration

Ian Grieve2 minute read0 comment

Microsoft Dynamics 365 Business CentralThis post is part of the Installing Microsoft Dynamics 365 Business Central 2022 Wave 1 On-premise Demo series in which I am creating a demo series for learning/demonstrating Business Central.

in this last post, I covered the system requirements for a demo/test system. Before getting started, I thought I would quickly post on the exact system configuration I am using for this demo system.

Firstly, I have a standalone active directory domain controller, although I don’t think it will actually be needed. I’m using it though, as I always connect my demo machines to an AD domain controller as I’ve been caught a few times needing one after initially thinking I would not.

Secondly, the Business Central server which will host all of the Business Central services. This is a server with a 100GB HDD, 4 GB RAM (below the system recommendations, but I can scale up if needed) and running Windows Server 2022 Datacenter (H21H2).

I have also installed Office 2019 Professional in order to have access to Excel and Word.

Other software requirements will be installed by the Business Central Setup utility.

Installing Microsoft Dynamics 365 Business Central 2022 Wave 1 On-premise Demo: System Requirements

Ian Grieve2 minute read0 comment

Microsoft Dynamics 365 Business CentralThis post is part of the Installing Microsoft Dynamics 365 Business Central 2022 Wave 1 On-premise Demo series in which I am creating a demo series for learning/demonstrating Business Central.

The full system requirements for Business Central are available on Microsoft Docs. In this post, I’m listing out the requirements for running Business Central in an offline learning/demo environment; I will be missing some functionality, such as that around email, but am concentrating on the core functionality.

The below is not the configuration you’d be using for a full production installation, but only for a more limited test/demo system.

Server

Specification Requirement
Supported operating systems
  • Windows 11 Pro, Enterprise, or Education (64-bit edition).
  • Windows 10 Pro, Enterprise, or Education (64-bit edition).
  • Windows Server 2022 (Datacenter, Standard).
  • Windows Server 2019 (Datacenter, Standard).
  • Windows Server, version 20H2 or later (Datacenter, Standard).
Hardware resources
  • Hard disk space: 2 GB.
  • Memory: 8 GB.
Additional software
  • Microsoft .NET Framework 4.8.
Additional information Business Central Setup installs the following software if it’s not already present on the target computer:

  • Microsoft .NET Framework 4.8
  • Windows Identity Foundation.
  • Report Builder for SQL Server 2019.

Continue reading “Installing Microsoft Dynamics 365 Business Central 2022 Wave 1 On-premise Demo: System Requirements”