How to Add a Dependency to a Windows Service

Windows ServerWhile I was blogging about implementing SmartConnect, I mentioned that the service account should be either set as delayed start or have a dependency added.

The former option, making it delayed start, can be done through the Services control panel applet, you can’t add a dependency this way. Instead the dependency can be added via a command.

The service can be changed by using the sc.exe which is a component of Windows. To use the command we need to know the Service name of both the service we want to add the dependency to and also the service name of the service it will be dependent on.

In my example, I am adding a dependency to the eOne SmartConnect Service; to find the Service name, open Services from the Control Panel, rich-click the service and locate the Service name:

eOne SmartConnect Service Properties

Continue reading “How to Add a Dependency to a Windows Service”

azurecurve ClassicPress Plugins: URL Shortener

ClassicPress PluginsThis is part of the azurecurve ClassicPress Plugins which introduces the plugins I have available for ClassicPress.

The plugin I am going to cover in this post, is a fork of someone elses plugin which I initially created a long time ago, but am now releasing it for others to use; URL Shortener.

Functionality

This plugin allows a fucntion call to be placed on a post or page to display a short URL.

The structure of the short URL is configurable via the plugins Settings page.

Demo

Both this site and azurecurve|GP Table Reference make extensive use of this plugin.

Short URLs are automatically generated for every post, page and custom post type on post creation. Custom short URLs can be assigned to all posts.

Download

The plugin can be downloaded via my Development site.

Click to show/hide the azurecurve ClassicPress Plugins Series Index

SQL View to Report on Fixed Allocation Accounts

Microsoft Dynamics GPIf you are using Fixed Allocation Accounts in Microsoft Dynamics GP, there is only a standard report which shows the distribution accounts against one of the accounts. These reports are not very user friendly and can;t be exported to Microsoft Excel in usable way.

Below is a SQL View which can be added to a reporting tool such as SmartList Designer, or a refreshable Excel report, which will allow users to see how Fixed Allocation accounts have been setup.

-- drop view if it exists
IF OBJECT_ID (N'uv_AZRCRV_FixedAllocationAccounts', N'V') IS NOT NULL
    DROP VIEW uv_AZRCRV_FixedAllocationAccounts
GO
-- create view
CREATE VIEW uv_AZRCRV_FixedAllocationAccounts AS
/*
Created by Ian Grieve of azurecurve|Ramblings of a Dynamics GP Consultant (https://www.azurecurve.co.uk)
This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 2.0 UK: England & Wales (CC BY-NC-SA 2.0 UK).
*/
SELECT
	['Account Index Master - Fixed Allocation'].ACTNUMST AS 'Account Number'
	,['Account Master - Fixed Allocation'].ACTDESCR AS 'Account Description'
	,CAST(['Fixed Allocation Master'].PRCNTAGE AS NUMERIC(15,2)) AS 'Distribution Percentage'
	,['Account Index Master - Fixed Allocation Distribution'].ACTNUMST AS 'Distribution Account Number'
	,['Account Master - Fixed Allocation Distribution'].ACTDESCR AS 'Distribution Account Description'
	,CASE WHEN ['Account Master - Fixed Allocation Distribution'].ACTIVE = 1 THEN 'Yes' ELSE 'No' END AS 'Distribution Account Active'
	,['Account Category Master'].ACCATDSC AS 'Distribution Account Category Description'
	,CASE WHEN ['Account Master - Fixed Allocation Distribution'].PSTNGTYP = 1 THEN 'Profit & Loss' ELSE 'Balance Sheet' END AS 'Distribution Account Posting Type'
	,['Account Master - Fixed Allocation Distribution'].USERDEF1 AS 'Distribution Account User-Defined 1'
	,['Account Master - Fixed Allocation Distribution'].USERDEF2 AS 'Distribution Account User-Defined 2'
	,['Account Master - Fixed Allocation Distribution'].USRDEFS1 AS 'Distribution Account User-Defined 3'
	,['Account Master - Fixed Allocation Distribution'].USRDEFS2 AS 'Distribution Account User-Defined 4'
FROM
	GL00103 AS ['Fixed Allocation Master'] WITH (NOLOCK)
INNER JOIN
	GL00105 AS ['Account Index Master - Fixed Allocation'] WITH (NOLOCK)
		ON
			['Account Index Master - Fixed Allocation'].ACTINDX = ['Fixed Allocation Master'].ACTINDX
INNER JOIN
	GL00100 AS ['Account Master - Fixed Allocation'] WITH (NOLOCK)
		ON
			['Account Master - Fixed Allocation'].ACTINDX = ['Fixed Allocation Master'].ACTINDX
INNER JOIN
	GL00105 AS ['Account Index Master - Fixed Allocation Distribution'] WITH (NOLOCK)
		ON
			['Account Index Master - Fixed Allocation Distribution'].ACTINDX = ['Fixed Allocation Master'].DSTINDX
INNER JOIN
	GL00100 AS ['Account Master - Fixed Allocation Distribution'] WITH (NOLOCK)
		ON
			['Account Master - Fixed Allocation Distribution'].ACTINDX = ['Fixed Allocation Master'].DSTINDX
INNER JOIN
	GL00102 AS ['Account Category Master'] WITH (NOLOCK)
		ON
			['Account Category Master'].ACCATNUM = ['Account Master - Fixed Allocation Distribution'].ACCATNUM
GO
-- grant permissions to view
GRANT SELECT ON uv_AZRCRV_FixedAllocationAccounts TO DYNGRP
GO

azurecurve ClassicPress Plugins: Toggle Show/Hide

ClassicPress PluginsThis is part of the azurecurve ClassicPress Plugins which introduces the plugins I have available for ClassicPress.

The plugin I am going to cover in this post, is an existing one which has been brought up to coding standards; Toggle Show/Hide.

Functionality

The Toggle Show/Hide shortcode allows content to be hidden until the user clicks the link. Default settings for the toggles can be set via the plugins Settings page, although these can be overridden on any toggle by setting parameters.

Demo

The Toggle Show/Hide plugin is used in numerous places on this site; the Buy My Books section on the sidebar is probably the easiest place to see this in action.

Download

The plugin can be downloaded via my Development site.

Click to show/hide the azurecurve ClassicPress Plugins Series Index

Feature Explained: Invoice Receipt Date

Microsoft Dynamics GPBack in 2017, regulations in the UK changed so that business of a certain minimum size, had to start recording the date an invoice was received. To support this new regulation, Microsoft introduced a new Invoice Receipt Date field to a number of windows in the Purchasing series. This new field was introduced in the July 2017 hotfix.

The presence of this field does not seem especially well-known, so I figured I do a quick post covering where it is and how it would be used.

The Invoice Receipt Date has been added to the Date Entry windows for the three types of transaction:

  • Payables Transaction Entry (Purchasing area page » Transactions » Transaction Entry)
  • Receivings Transaction Entry (Purchasing area page » Transactions » Receivings Transaction Entry)
  • Purchasing Invoice Entry (Purchasing area page » Transactions » Enter/Match Invoice)

Taking Payables Transaction Entry as an example, to access the Payables Date Entry field, click the expansion arrow next to the Doc. Date field:

Payables Transaction Entry

Continue reading “Feature Explained: Invoice Receipt Date”

azurecurve ClassicPress Plugins: Timelines

ClassicPress PluginsThis is part of the azurecurve ClassicPress Plugins which introduces the plugins I have available for ClassicPress.

The plugin I am going to cover in this post, is an existing one which has been brought up to coding standards; Timelines.

Functionality

The Timelines plugin allows a timeline of events to be created using a custom post type and displayed using a timeline shortcode.

Demo

You can see the timeline in action on my Experience page.

Download

The plugin can be downloaded via my Development site.

Click to show/hide the azurecurve ClassicPress Plugins Series Index

Installing FileZilla Client: Downloading

FileZilla - The free FTP solutionThis post is part of the Installing FileZilla Client series. FileZilla is a free software, cross-platform FTP application, consisting of FileZilla Client and FileZilla Server. Client binaries are available for Windows, Linux, and macOS; server binaries are available for Windows only. This series is taking a look only at the Windows FileZilla client.

FileZilla can be downloaded from the FileZilla Project website; click the big green Download FileZilla Client button:

FileZilla - The free FTP solution download page

Continue reading “Installing FileZilla Client: Downloading”

azurecurve ClassicPress Plugins: Theme Switcher

ClassicPress PluginsThis is part of the azurecurve ClassicPress Plugins which introduces the plugins I have available for ClassicPress.

The plugin I am going to cover in this post, is an existing one which has been brought up to coding standards; Theme Switcher.

Functionality

Theme Switcher allows users to switch between different themes using the supplied widget; example uses would be to allow them to change mode between light and dark themes.

Demo

This site uses Theme Switcher to allow users to Change Mode between light and dark; you can try this using the Change Mode widget in the sidebar.

Download

The plugin can be downloaded via my Development site.

Click to show/hide the azurecurve ClassicPress Plugins Series Index

Installing FileZilla Client: Series Index

FileZilla - The free FTP solutionI’ve tried a number of FTP applications over the years, but I keep coming back to FileZilla. While are a few things I don’t like about it, it seems to be the best of the free offerings available. FileZilla is a free software, cross-platform FTP application, consisting of FileZilla Client and FileZilla Server. Client binaries are available for Windows, Linux, and macOS; server binaries are available for Windows only. This series is taking a look only at the Windows FileZilla client.

Over the course of this short series I am going to install and use FileZilla. The index below will automatically upload if you are reading this the source blog, otherwise check back to the master post at azurecurve.

Continue reading “Installing FileZilla Client: Series Index”

azurecurve ClassicPress Plugins: Taxonomy Index

ClassicPress PluginsThis is part of the azurecurve ClassicPress Plugins which introduces the plugins I have available for ClassicPress.

The plugin I am going to cover in this post, is an existing one which has been brought up to coding standards; Taxonomy Index.

Functionality

The Taxonomy Index allows an index of posts included in a taxonomy to be displayed on a page using a taxonomy-index shortcode.

The default output is configurable via the plugins Settings page, but parameters can be used with the shortcode to customise.

Download

The plugin can be downloaded via my Development site.

Click to show/hide the azurecurve ClassicPress Plugins Series Index