I got a surprise the other day when starting Outlook and the modules were no longer discreetly placed at the bottom left of the application, but occupying a new bar on the left of the app:
Continue reading “Move Outlook Modules Back to the Bottom of the Outlook App”
This script is part of the SQL Scripts for Microsoft Dynamics GP where I will be posting the scripts I wrote against Microsoft Dynamics GP over the 19 years before I stopped working with Dynamics GP.
This script was created for a client who had quite a few bank accounts and want to quickly check which G/L Accounts were linked to each bank account.
/*
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
CM.CHEKBKID
,CM.DSCRIPTN
,GL105.ACTNUMST
,GL100.ACTDESCR
FROM
CM00100 AS CM WITH (NOLOCK) --CM Checkbook Master (CM00100)
INNER JOIN
GL00100 AS GL100 WITH (NOLOCK) --Breakdown Account Master (GL00100)
ON GL100.ACTINDX = CM.ACTINDX
INNER JOIN
GL00105 AS GL105 WITH (NOLOCK) --Account Index Master (GL00105)
ON GL105.ACTINDX = CM.ACTINDX
This post is part of the In Microsoft Dynamics 365 Business Central (Administration), how do I… series and of the wider In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central.
On reflection, the terminology in the post on understanding posting groups, isn’t all that clear. It uses terminology similar to the official terminology from Microsoft and it took me a while to determine and properly understand what they meant.
There are two connected elements to the general posting groups:
The combination of the business and product general posting groups then determine the posting setup (i.e. the accounts used for the combination).
In this series of articles, I am going to introduce each of the plugins I have developed for ClassicPress, a hard-fork of WordPress, which was originally created to provide an alternative, yet compatible, CMS without the Gutenberg block editor.
The 28th plugin is Mobile Detection.
Plugin providing shortcodes and functions to allow different content to be served to different types of device (Desktop, Tablet, Phone); also includes checks on types of device (iOS, iPhone, iPad, Android, Windows Phone) and mobile browsers (Chrome, Firefox, IE, Opera, WebKit).
The following shortcodes are available:
All shortcodes available as functions with an `azrcrv_md` prefix for calling from themes, other plugins, etc. For example,
is_mobileavailable as function
azrcrv_md_is_mobile.
Uses PHP Mobile Detect class, the lightweight PHP class for detecting mobile devices (including tablets).
In this series of articles, I am going to introduce each of the plugins I have developed for ClassicPress, a hard-fork of WordPress, which was originally created to provide an alternative, yet compatible, CMS without the Gutenberg block editor.
The 27th plugin is Markdown.
Options to enable conversion of markdown in posts, pages or wrap markdown in the [markdown] to have it parsed and converted into HTML markup. Place opening and closing markdown shortcode tags on separate lines to ensure markdown converted correctly.
Uses Parsedown and Parsedown Extra.
This plugin is multisite compatible; settings need to be configured for each site.
Continue reading “ClassicPress Plugins Available From azurecurve | Development in 2023: Markdown”
This script is part of the SQL Scripts for Microsoft Dynamics GP where I will be posting the scripts I wrote against Microsoft Dynamics GP over the 19 years before I stopped working with Dynamics GP.
This script will change en masse the email message assigned to workflow steps; it was created for a client after they created new messages for each workflow type and had a lot of workflow steps which needed to be assigned to the new email message.
The two parameters to set are highlighted; care needs to be taken, especially with the @EmailMessageID as there is no validation in the script.
/*
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).
*/
DECLARE @Workflow_Type_Name VARCHAR(40) = 'Purchase Requisition Approval'
DECLARE @EmailMessageID VARCHAR(30) = 'AZRCRV POREQ ASSIGNED'
UPDATE
['Workflow Step Table']
SET
EmailMessageID = @EmailMessageID
,Workflow_Step_Send_Email = 1
FROM
WF100003 AS ['Workflow Step Table'] --Workflow Step Table (WF100003)
INNER JOIN
WF100002 AS ['Workflow Master'] --Workflow Master (WF100002)
ON
['Workflow Master'].Workflow_Name = ['Workflow Step Table'].Workflow_Name
WHERE
['Workflow Master'].Workflow_Type_Name = @Workflow_Type_Name
AND
['Workflow Step Table'].Workflow_Step_Send_Email = 0
GO
This post is part of the In Microsoft Dynamics 365 Business Central (Administration), how do I… series and of the wider In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central.
Posting groups are how Dynamics BC determines to which G/L accounts transactions are posted. They work by mapping entities, such as customers, vendors, items, sale documents, purchasing documents and so on, to the G/L accounts in order to save time and reduce errors.
There are three types of posting group in Dynamics BC:
In the next few articles in this series, I’ll take a deeper look into each of the posting group types.
This script is part of the SQL Scripts for Microsoft Dynamics GP where I will be posting the scripts I wrote against Microsoft Dynamics GP over the 19 years before I stopped working with Dynamics GP.
This script was created a while ago when I was doing some testing on a client system and wanted to quickly insert some creditor item numbers; in fact, it inserts a creditor item number for every single creditor/item combination.
/*
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).
*/
INSERT INTO dbo.IV00103
(ITEMNMBR
,VENDORID
,ITMVNDTY
,VNDITNUM
,QTYRQSTN
,QTYONORD
,QTY_Drop_Shipped
,LSTORDDT
,LSORDQTY
,LRCPTQTY
,LSRCPTDT
,LRCPTCST
,AVRGLDTM
,NORCTITM
,MINORQTY
,MAXORDQTY
,ECORDQTY
,VNDITDSC
,Last_Originating_Cost
,Last_Currency_ID
,FREEONBOARD
,PRCHSUOM
,CURRNIDX
,PLANNINGLEADTIME
,ORDERMULTIPLE
,MNFCTRITMNMBR)
--VALUES
(SELECT
IV101.ITEMNMBR
,PM2.VENDORID
,2
,IV101.ITEMNMBR
,0,0,0
,'1900-01-01 00:00:00.000'
,0,0
,'1900-01-01 00:00:00.000'
,0,0,0,0,0,0
,IV101.ITEMDESC
,0
,'' -- CURRENCY
,1,'',9,0,1,''
FROM
PM00200 AS PM2
CROSS JOIN
IV00101 AS IV101
LEFT JOIN
IV00103 AS IV103
ON
IV103.VENDORID = PM2.VENDORID
AND
IV103.ITEMNMBR = IV101.ITEMNMBR
WHERE
IV103.VENDORID IS NULL)
If you use this script, make sure you test thoroughly before running on a production system. After running the script, you may need to run an Inventory Reconcile.
I use multiple computes on a regular basis and want to have the same setup on each machine and I also have multiple profiles set up, all of which makes configuring Vivaldi on a new machine a complete pain.
I did some poking around and found that the %localappdata%\Vivaldi\User Data folder has sub folders for each profile. If you copy the content of a profile folder from one machine you can use the content of the folder to overwrite the profile folder on the new machine.
This will take over settings, bookmarks, speed dials and extensions to the new computer which basically removes the task of setting up the browser. All you need to do on the new machine is to create the profiles in Vivaldi, close the browser and then replace the content of the profile folder (copy and paste in and say yes to overwrite existing files).
This script is part of the SQL Scripts for Microsoft Dynamics GP where I will be posting the scripts I wrote against Microsoft Dynamics GP over the 19 years before I stopped working with Dynamics GP.
This script will return the approver of a workflow. It complements two other functions which I have previously posted:
IF OBJECT_ID (N'uf_AZRCRV_GetWorkflowApprover', N'FN') IS NOT NULL
DROP FUNCTION uf_AZRCRV_GetWorkflowApprover
GO
CREATE FUNCTION [dbo].[uf_AZRCRV_GetWorkflowApprover](@WorkflowTypeName CHAR(50),@WfBusObjKey CHAR(20))
RETURNS VARCHAR(50)
AS
/*
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).
*/
/*
Author: Ian Grieve
Version: 1.0
Date: 1/3/2017
Returns Workflow Approval status of a specified workflow item.
Requires parameters of WorkflowTypeName and WfBusObjKey
Valid Workflow Type Names are (as of Microsoft Dynamics GP 2016 R2):
General Ledger Batch Approval
Receivables Batch Approval
Payables Batch Approval
Payables Transaction Approval
Purchase Order Approval
Purchase Requisition Approval
Vendor Approval
Employee Profile Approval
Employee Skills Approval
Payroll Direct Deposit Approval
Payroll Timecard Approval
Payroll W4 Approval
Expense Report Approval
Timesheet Approval
Smartlist Designer View Approval
*/
BEGIN
RETURN ISNULL((
SELECT TOP 1
WFU.ADDisplayName
FROM
WF30100 AS WF --Workflow History (WF30100)
INNER JOIN
WFI10002 AS WFI --Workflow Instance Master (WFI10002)
ON WFI.WorkflowInstanceID = WF.WorkflowInstanceID
INNER JOIN
WF40200 WFU --Workflow Users (WF40200)
ON WFU.ADLogin = WF.Workflow_History_User
WHERE
WFI.Workflow_Type_Name = @WorkflowTypeName
AND
WFI.WfBusObjKey = @WfBusObjKey
AND
WF.Workflow_Action IN (3) --APPROVED
ORDER BY
WF.DEX_ROW_ID DESC)
,'')
END
GO
GRANT SELECT ON uf_AZRCRV_GetWorkflowApprover TO DYNGRP
GO