Security Views For Use In SmartList Designer: Security Tasks & Operations

Microsoft Dynamics GPThe seventh SQL view in this series does not include users, but instead shows the tasks and the operations. To use this view you will need to have populated the Security Resource Descriptions table.

CREATE VIEW [dbo].[uv_AZRCRV_SecurityTasksWithOperations] 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
	['Security Task Master'].SECURITYTASKID AS 'Security Task ID'
	,['Security Task Master'].SECURITYTASKNAME AS 'Security Task Name'
	,['Security Task Master'].SECURITYTASKDESC AS 'Security Task Description'
	,['Security Resource Descriptions'].PRODNAME AS 'Product Name'
	,['Security Resource Descriptions'].Series_Name AS 'Series Name'
	,['Security Resource Descriptions'].DSPLNAME AS 'Security Operation Name'
	,['Security Resource Descriptions'].TYPESTR AS 'Security Operation Type'
FROM
	SY09000 AS ['Security Task Master']
INNER JOIN
	SY10700 AS ['Security Assignment Task Operations']
		ON
			['Security Assignment Task Operations'].SECURITYTASKID = ['Security Task Master'].SECURITYTASKID
INNER JOIN
	SY09400 AS ['Security Resource Descriptions']
		ON
			['Security Resource Descriptions'].SECURITYID = ['Security Assignment Task Operations'].SECURITYID
		AND
			['Security Resource Descriptions'].DICTID = ['Security Assignment Task Operations'].DICTID
GO

GRANT SELECT ON uv_AZRCRV_SecurityTasksWithOperations TO DYNGRP
GO

MDGP 2015 R2 Feature of the Day: Default SmartList Visibility

Microsoft Dynamics GPMicrosoft Dynamics GP 2015 R2 has been released and, as with previous releases, Microsoft have started a Feature of the Day series on the Inside Microsoft Dynamics GP Team blog. As I have done with the last three series, I’ll be reposting these blog posts here with a little commentary.

The twenty fifth, and last, Feature of the Day is Default SmartList Visibility. When creating a new SmartList Favorite, the user has the option to select to whom the SmartList Favorite will be visible, including the following options: System, Company, User Class, and User ID. System is the default option selected for the visibility.

Add or Remove Favorites

Continue reading “MDGP 2015 R2 Feature of the Day: Default SmartList Visibility”

MDGP 2015 R2 Feature of the Day: Customer Credit Limit Visual

Microsoft Dynamics GPMicrosoft Dynamics GP 2015 R2 has been released and, as with previous releases, Microsoft have started a Feature of the Day series on the Inside Microsoft Dynamics GP Team blog. As I have done with the last three series, I’ll be reposting these blog posts here with a little commentary.

The twenty fourth Feature of the Day is Customer Credit Limit Visual. In Microsoft Dynamics GP 2015 R2, you have additional options that determine how and when you are notified of a customer who is over the credit limit you set for them.

In Receivables Setup, you can select to display an icon or give a warning message for a customer who is over their limit.

The existing process for an existing credit limit password will still be asked when entering a line item or saving a transaction.

The warning message:

Continue reading “MDGP 2015 R2 Feature of the Day: Customer Credit Limit Visual”

Microsoft Dynamics GP Workflow 2.0 Available From Amazon

Microsoft Dynamics GPI recently released my fourth book Microsoft Dynamics GP Workflow 2.0.

Initiallially it was available only as an eBook in PDF format, but now the paperback format is available from Amazon UK and Amazon US.

eBook Paperback
azurecurve Publishing Amazon.com Amazon.co.uk

I will be adding ePUB and MOBI formats to the existing eBook format which you will receive free of charge, should you request, after buying the PDF version. I hope to have them available very soon (I am working on the format at the moment and will add them as soon as they are complete).

The book will also then become available from other retailers too (including the Apple Store).