PowerShell Snippets: Prompt for Multiple Inputs
Sep25

PowerShell Snippets: Prompt for Multiple Inputs

This post is part of the series on PowerShell Snippets. Over the last two posts of this series, I’ve shown PowerShell cmdlets which prompt for user input and prompt for secure entry of passwords. A PowerShell script can prompt for multiple inputs as well as output text to screen. When I originally posted about the Write-Output cmdlet, I only showed how it could be used to output text; you can… Continue Reading...

Read More
PowerShell Snippets: Prompt User for Password
Sep24

PowerShell Snippets: Prompt User for Password

This post is part of the series on PowerShell Snippets. In this last post, in this series, I showed a PowerShell snippet which would prompt a user for input. This is fine if you are prompting for a username, filename, version tag or similar, but if you are prompting for a password, you would not want to expose to people watching over the users shoulder. The Read-Host cmdlet has a parameter… Continue Reading azurecurve’s...

Read More
How to Enable the Microsoft SQL Server Database Mail Feature
Sep23

How to Enable the Microsoft SQL Server Database Mail Feature

I’ve done work for a few clients recently where I’ve created stored procedures or triggers in SQL Server which needed to send email. One of them was for a Microsoft Dynamics GP client where they wanted to send an email when a PR was converted to PO; sending emails in tis way uses a part of SQL Server called Database Mail. Database Mail is installed but not configured by default, so using it… Continue Reading...

Read More
In Microsoft Dynamics 365 Business Central, how do I… Add a User in Dynamics BC
Sep22

In Microsoft Dynamics 365 Business Central, how do I… Add a User in Dynamics BC

This post is part of the In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central. Once a user has been added in Microsoft 365 we can progress to adding them in Dynamics BC. To do this click the “Tell me what you want to do” magnifying glass in the top right corner ad type Users. Select Users from the… Continue Reading...

Read More
Microsoft Certified: Dynamics 365 Business Central Functional Consultant Associate
Sep21

Microsoft Certified: Dynamics 365 Business Central Functional Consultant Associate

I’ve really only been working with Microsoft Dynamics 365 Business Central a short time, but I am pleased to be able to announce that I have passed the MB-800 Microsoft Dynamics 365 Business Central Functional Consultant exam yesterday. With the exam out of the way I can now focus on learning more about Dynamics BC generally and not just the topics required for sitting the exam. It’s always… Continue Reading...

Read More
In Microsoft Dynamics 365 Business Central, how do I… Add a User In 365 Admin Center
Sep20

In Microsoft Dynamics 365 Business Central, how do I… Add a User In 365 Admin Center

This post is part of the In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central. The first in creating a user with access to Dynamics BC, is to give them access to the Microsoft 365 tenant itself via the 365 Admin Center. When you login, the User management section should be open in the main part of… Continue Reading...

Read More
PowerShell Script to Change Language of SSRS Reports
Sep19

PowerShell Script to Change Language of SSRS Reports

Microsoft Dynamics GP ships with a set of standard SSRS reports which includes many useful reports which clients want to use. However, these reports ship with the language set to en-US which means all the numbers could out as US dollars. For a UK based client this isn’t very useful. There are also lots of reports which would need to be updated. I looked into this years ago with a colleague and… Continue Reading...

Read More
PowerShell Snippets: Prompt for User Input
Sep18

PowerShell Snippets: Prompt for User Input

This post is part of the series on PowerShell Snippets. The following PowerShell command will prompt the user to input some text which is then stored in the $ghTag parameter for later use: $ghTag = Read-Host “Please enter the tag” Click to show/hide the PowerShell Snippets Series IndexPowerShell SnippetsWrite-OutputStart-SleepPowerShell to run script bypassing execution policyUnlock BitLocker… Continue Reading...

Read More
In Microsoft Dynamics 365 Business Central, how do I… Create a User
Sep16

In Microsoft Dynamics 365 Business Central, how do I… Create a User

This post is part of the In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central. Creating a user in Dynamics BC is not difficult, but there are two distinct steps which need to be followed. For clarity, I will break these down into two separate posts following this one. The reason I am splitting them… Continue Reading...

Read More
Remove a Language Course from Duolingo
Sep15

Remove a Language Course from Duolingo

After visiting Italy in 2020 I started using Duolingo, but gave up on the Italian after a short time and switched over to learning German. I decided I might not make it back to Italy again so there wasn’t much point learning the language, but I listen to a lot of German music so learning German would have an immediate benefit. It did leave me with the Italian language course hanging around… Continue Reading...

Read More
In Microsoft Dynamics 365 Business Central, how do I… Create a Sandbox Environment With a Copy of Production
Sep14

In Microsoft Dynamics 365 Business Central, how do I… Create a Sandbox Environment With a Copy of Production

This post is part of the In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central. I previously showed how a sandbox environment can be created from within Dynamics BC, but this type of sandbox will only contain the Cronus development company. With access to the Microsoft Dynamics 365 Business Central… Continue Reading...

Read More
Restart Windows Service Using Commands
Sep13

Restart Windows Service Using Commands

A client has recently been having an issue with a process which appears to starts having problems after it has been running for a few days. While the application was investigated, they wanted to restart the service periodically restarted automatically. The below Windows command script was created to stop the named service, wait 30 seconds and then start the service again: @echo off net stop

Read More
In Microsoft Dynamics 365 Business Central, how do I… Access Dynamics BC Admin Centre
Sep12

In Microsoft Dynamics 365 Business Central, how do I… Access Dynamics BC Admin Centre

This post is part of the In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central. There are some tasks in Dynamics BC which require you to use the Microsoft Dynamics 365 Business Central Administration Center. The link for this is not (as far as I am aware), available through the Dynamics BC site… Continue Reading...

Read More
PowerShell Snippets: Get Numeric Value from String
Sep11

PowerShell Snippets: Get Numeric Value from String

This post is part of the series on PowerShell Snippets. In the previous post, I showed how a single element could be retrieved from a GitHub release by executing curl and selecting the required element. I quickly discovered that the element retrieved in this was contained some additional characters and I needed only the numeric ones. The PowerShell below will extract the numeric elements of… Continue Reading azurecurve’s...

Read More
PowerShell Snippets: Get One Value from GitHub Json
Sep10

PowerShell Snippets: Get One Value from GitHub Json

This post is part of the series on PowerShell Snippets. While looking into uploading a release asset to a GitHub release, I discovered that to do this I needed the internal numeric id for a release and not just the id I’d given it. The element I needed from the GitHub json was id which can be retrieved using the below PowerShell which executes curl and then selects a single element:

Read More
SmartConnect Scheduled Integration Regularly Failed
Sep09

SmartConnect Scheduled Integration Regularly Failed

A client reported that a SmartConnect integration they’d been using for a couple of years had started failing regularly. It was scheduled to run in the early hours on every week day, but was failing most of the time; oddly, it was working sometimes. If the integration was run manually it ran successfully every single time. When running on the schedule it failed more often than not. There was an… Continue Reading...

Read More
In Microsoft Dynamics 365 Business Central, how do I… Create a Sandbox Environment With Cronus
Sep08

In Microsoft Dynamics 365 Business Central, how do I… Create a Sandbox Environment With Cronus

This post is part of the In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central. There are two ways that a sandbox environment can be created in Dynamics BC. The first way, and the way I’m going to show in this post, will only create a sandbox environment containing the Cronus sample company; the… Continue Reading...

Read More
Discount on All Books Until the End of September
Sep07

Discount on All Books Until the End of September

As I announced the other day, I a href=’https://www.azurecurve.co.uk/2022/09/things-change-farewell-farewell-my-friends-or-i-have-a-new-job-working-with-microsoft-dynamics-365-business-central/’>have recently changed jobs and will no longer be working with Microsoft Dynamics GP. In celebration of my new role, and as a small give back to the Dynamics GP community I’ve been part of for 19 years… Continue...

Read More
In Microsoft Dynamics 365 Business Central, how do I… Switch Between Companies
Sep06

In Microsoft Dynamics 365 Business Central, how do I… Switch Between Companies

This post is part of the In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central. Once you’re using Dynamics BC and have created a new company or copied one you will be working in a multi-company environment and will need to switch between them. As someone new to Dynamics BC, how to do this was not… Continue Reading...

Read More
eOne Support Lifecycle Policy for SmartConnect
Sep05

eOne Support Lifecycle Policy for SmartConnect

I only recently became aware of the lifecycle policy which eOne Solutions use for SmartConnect on-premise. For SmartConnect 2018 and before the product is supported for three years on standard support and a further two years for extended support. This means that SmartConnect 2018 is only under support until 15th December 2022; this means if you are using SmartConnect 2018 then you only have… Continue Reading azurecurve’s...

Read More
PowerShell Snippets: Use Curl
Sep04

PowerShell Snippets: Use Curl

This post is part of the series on PowerShell Snippets. The following PowerShell command will execute curl passing in the authorization token and json parameters defined above the curl statement. The main difference between this and curl on a normal command line is that you need to do curl.exe which is a built in alias for the Invoke-WebRequest cmdlet: $ghAuthorizationToken =… Continue Reading azurecurve’s Article on their...

Read More
PowerShell Snippets: Format Json for Curl
Sep03

PowerShell Snippets: Format Json for Curl

This post is part of the series on PowerShell Snippets. The following PowerShell shows the format required for use in Curl (which I will cover in the next post of this series). It took me a number of attempts to get the format correct; the backticks (`) are needed to escape the double quotes (“) for PowerShell and the backslashes (\) to escape them for the curl command: $json = ” {… Continue Reading...

Read More
In Microsoft Dynamics 365 Business Central, how do I… Copy a Company
Sep02

In Microsoft Dynamics 365 Business Central, how do I… Copy a Company

This post is part of the In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central. In the last post, in this series, I showed how a new company can be created; which is fine if you’re creating a new company or deploying a new sample company, but sometimes you might want to create a copy of an existing… Continue Reading...

Read More
“Things change. Farewell, farewell my friends” or “I have a new job working with Microsoft Dynamics 365 Business Central”
Sep01

“Things change. Farewell, farewell my friends” or “I have a new job working with Microsoft Dynamics 365 Business Central”

I am just over half way through my working life (24 years post university and 22 years until I reach the state retirement age) and after doing some serious thinking earlier this year, I decided that it was time to reassess what I was doing now and what I wanted/needed to be doing in future. The result, as the title says, is that I am changing jobs and will, from today onwards, be working with… Continue Reading azurecurve’s...

Read More
In Microsoft Dynamics 365 Business Central, how do I… Create a Company
Aug31

In Microsoft Dynamics 365 Business Central, how do I… Create a Company

This post is part of the In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central. In an earlier post, I thought it important to clarify terminology around companies and environments in Dynamics BC. In a later post, I will show how to create a new environment, but in this one I am going to focus on… Continue Reading...

Read More
SQL View to Return Purchasing Status for the GP Elementz PO Management Module for Microsoft Dynamics GP
Aug30

SQL View to Return Purchasing Status for the GP Elementz PO Management Module for Microsoft Dynamics GP

While it isn’t listed on the GP Elementz website, there is a module available called PO Management which replaces the standard POP/SOP link in Microsoft Dynamics GP. The standard functionality requires that all of a sales order line where there is a commitment to a PO must be fulfilled before that line can be invoiced; the PO Management module allows partial invoicing of a line committed to a… Continue Reading...

Read More
In Microsoft Dynamics 365 Business Central, how do I… Get Access to the Microsoft 365 Admin Center
Aug29

In Microsoft Dynamics 365 Business Central, how do I… Get Access to the Microsoft 365 Admin Center

This post is part of the In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central. When you sign up Dynamics BC you are also signing up to Microsoft 365 which comes with an Administration Center, some elements of which are used to maintain Dynamics BC. The Microsoft 365 Admin center is not available for… Continue Reading...

Read More
PowerShell Snippets: Run Application (Such as 7-zip)
Aug28

PowerShell Snippets: Run Application (Such as 7-zip)

This post is part of the series on PowerShell Snippets. The following PowerShell command will execute a Windows application supplying a number of parameters; in this case I am using 7-zip to compress a single one of my ClassicPress plugins to a releases folder (part of this command came from a post I did on compressing all sub folders individually: $releaseFileName = “.\Releases\$ghRepo.zip” &… Continue Reading...

Read More
PowerShell Snippets: Delete File
Aug27

PowerShell Snippets: Delete File

This post is part of the series on PowerShell Snippets. The following PowerShell command will check if the named file exists in the current directory and, if so, delete it (replace the highlighted section with the name of the file to be deleted): $FileName = “azrcrv-smtp.zip” if (Test-Path $FileName) { Remove-Item $FileName } Click to show/hide the PowerShell Snippets Series IndexPowerShell… Continue Reading...

Read More
Error Trying to Log Into On-Premise Microsoft Dynamics 365 Business Central
Aug26

Error Trying to Log Into On-Premise Microsoft Dynamics 365 Business Central

I’ve started working Microsoft Dynamics 365 Business Central for a short time now and have been using both the on-premise and cloud versions and have encountered my first uninformative error message. I got used to these when working with Microsoft Dynamics GP, and especially the Integration Manager tool, but had hoped that Dynamics BC might have been better in this respect. I am a little late… Continue Reading...

Read More
In Microsoft Dynamics 365 Business Central, how do I… Sign Up For a Trial
Aug25

In Microsoft Dynamics 365 Business Central, how do I… Sign Up For a Trial

This post is part of the In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central. In this exploration of Dynamics BC, the first thing I need to do is sign up for a free trial in order to try it (I have installed an on premise test system, but want to try the full online experience). To sign up for a… Continue Reading...

Read More
Custom Email Notification When PO Create from PR in Microsoft Dynamics GP
Aug24

Custom Email Notification When PO Create from PR in Microsoft Dynamics GP

The workflow module in Microsoft Dynamics GP can send quite a lot of different notification emails, but the one I am often asked for, an email notification when a purchase is created from a purchase requisition, does not exist. After being asked a few times, I had a think about how this could be done and came up with a SQL trigger on the Purchasing Requisition History (POP30200) table which… Continue Reading azurecurve’s...

Read More
In Microsoft Dynamics 365 Business Central (Administration), how do I… Series Index
Aug23

In Microsoft Dynamics 365 Business Central (Administration), how do I… Series Index

I have recently started working with Microsoft Dynamics 365 Business Central and have decided to blog about it as I learn; I’ve started a In Microsoft Dynamics 365 Business Central, how do I… series which will include everything, but have also decided to break that down into a set of smaller series on specific areas of Dynamics BC. This is the series index for the Administration related posts… Continue Reading...

Read More
SQL View to Extract Accruals from Microsoft Dynamics GP Payables Management Module (Without Joins to RED)
Aug22

SQL View to Extract Accruals from Microsoft Dynamics GP Payables Management Module (Without Joins to RED)

Back in January 2021 I posted an article which included a SQL view to return accruals from the Payables Management module of Microsoft Dynamics GP. What I forgot at the time was that view included joins into the Revenue/Expense Deferral module which is not part of the standard installation. I’ve been asked a few times since for aversion which didn;t include the RED joins as a system without… Continue Reading...

Read More
A Review of TasteWP
Aug21

A Review of TasteWP

I was recently contacted by TasteWP asking for people to take a look at their system and provide feedback. Before I get into the feedback I gave them and a wider review, I think it might be best to first explain what TasteWP is and what it can be used for. TasteWP provides a sandbox environment where you can easily test plugins or themes you are developing or which you want to try out before… Continue Reading azurecurve’s...

Read More
Git Command Line Snippets: Upload Release Asset
Aug20

Git Command Line Snippets: Upload Release Asset

This 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. Now that we have the json from GitHub for the release, we can upload the release zip (an extra asset) which is used for installing the plugin on a ClassicPress site: curl -X POST –header “Authorization: token ghp_authorizationtoken” –header… Continue Reading...

Read More
In Microsoft Dynamics 365 Business Central, how do I… Series Index
Aug19

In Microsoft Dynamics 365 Business Central, how do I… Series Index

I have worked with and blogged about Microsoft Dynamics GP for the last 19 years, but have now started doing some work with Microoft Dynamics 365 Business Central. I am going to be doing some blogging about the latter system as I learn. Early posts will be covering the basics of Dynamics BC, but will start to cover more complex topics as I learn more about Dynamics BC. This series will likely… Continue Reading azurecurve’s...

Read More
Microsoft Dynamics GP Workflow Approval SQL Views: Purchase Orders
Aug18

Microsoft Dynamics GP Workflow Approval SQL Views: Purchase Orders

This post is part of the Microsoft Dynamics GP Workflow Approval SQL Views series and contains a SQL view to return the workflow approval status of purchase orders. — drop view if it exists IF OBJECT_ID(N’uv_AZRCRV_POPOrderApprovalStatus’, N’V’) IS NOT NULL DROP VIEW uv_AZRCRV_POPOrderApprovalStatus GO — create view CREATE VIEW uv_AZRCRV_POPOrderApprovalStatus AS /*Created by Ian Grieve of…...

Read More
Microsoft Dynamics GP Workflow Approval SQL Views: Purchase Requisitions
Aug17

Microsoft Dynamics GP Workflow Approval SQL Views: Purchase Requisitions

This post is part of the Microsoft Dynamics GP Workflow Approval SQL Views series and contains a SQL view to return the workflow approval status of purchase requisitions. — drop view if it exists IF OBJECT_ID(N’uv_AZRCRV_POReqApprovalStatus’, N’V’) IS NOT NULL DROP VIEW uv_AZRCRV_POReqApprovalStatus GO — create view CREATE VIEW uv_AZRCRV_POReqApprovalStatus AS /*Created by Ian Grieve of…...

Read More
Microsoft Dynamics GP Workflow Approval SQL Views: Payables Transactions
Aug16

Microsoft Dynamics GP Workflow Approval SQL Views: Payables Transactions

This post is part of the Microsoft Dynamics GP Workflow Approval SQL Views series and contains a SQL view to return the workflow approval status of payables transactions. — drop view if it exists IF OBJECT_ID(N’uv_AZRCRV_PayablesTransactionApprovalStatus’, N’V’) IS NOT NULL DROP VIEW uv_AZRCRV_PayablesTransactionApprovalStatus GO — create view CREATE VIEW… Continue Reading azurecurve’s...

Read More
Microsoft Dynamics GP Workflow Approval SQL Views: Series Index
Aug15

Microsoft Dynamics GP Workflow Approval SQL Views: Series Index

A couple of years ago, I posted a SQL view which returned the status of general ledger batches. I’ve recently been working with a few clients with workflow in Purchasing and a common request was being able to report on the status of documents. I have three views which were created and which I will post over the next few days. If I create additional ones in future, I’ll tag them into this… Continue Reading...

Read More
Git Command Line Snippets: Get Release Information
Aug14

Git Command Line Snippets: Get Release Information

This 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. In the last post, of this series, I covered the command to create a release and mentioned that uploading a release zip (extra asset) had to be handled separately. While the command to do this isn’t too complex, there is one problem; to upload the… Continue Reading...

Read More
Git Command Line Snippets: Create Release
Aug13

Git Command Line Snippets: Create Release

This 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. Once changes have been added, committed and pushed to the repository, we can create a release. When developing for ClassicPress, there is also a need to upload a release zip which is used for deployment to a ClassicPress site. Unfortunately, this… Continue Reading azurecurve’s...

Read More
In Microsoft Dynamics 365 Business Central, What is a Company and What is an Environment
Aug12

In Microsoft Dynamics 365 Business Central, What is a Company and What is an Environment

Sometimes terminology can be benefit from being explained. There are two concepts for Dynamics BC which, in the short time I’ve worked with Dynamics BC, I have had to discuss with a client. These terms are company and environment. In simplistic terms, a company is a container which holds all information (setup, master and transactional data) for a legal entity. If we have a company called… Continue Reading...

Read More
Get Serial Number Count and Length in Microsoft Dynamics GP
Aug11

Get Serial Number Count and Length in Microsoft Dynamics GP

I 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,… Continue Reading...

Read More
Show Bookmarks in Word
Aug10

Show Bookmarks in Word

Bookmarks 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… Continue Reading azurecurve’s...

Read More
Fixed Asset Depreciation Not Calculating in Microsoft Dynamics GP
Aug09

Fixed Asset Depreciation Not Calculating in Microsoft Dynamics GP

I 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 ((

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

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

This 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… Continue Reading azurecurve’s...

Read More
Git Command Line Snippets: Add, Commit and Push Changes
Aug07

Git Command Line Snippets: Add, Commit and Push Changes

This 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: Add Commit 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… Continue Reading azurecurve’s...

Read More
Git Command Line Snippets: Choose Repository
Aug06

Git Command Line Snippets: Choose Repository

This post is part of the series on 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… Continue Reading...

Read More