Customising the Company Login window series Part 4 - Visual Studio Tools

Following on from my previous posts: Customising the Company Login window series Part 1 – Introduction, Customising the Company Login window series Part 2 – Visual Basic for Applications and Customising the Company Login window series Part 3 – Dexterity, here is a discussion about trying to create a solution using Visual Studio Tools. As discussed in…

2

Customising the Company Login window series Part 3 - Dexterity

Following on from my previous posts: Customising the Company Login window series Part 1 – Introduction and Customising the Company Login window series Part 2 – Visual Basic for Applications, here is the method to create a solution using Dexterity. As discussed in the earlier posts, the problem we are trying to overcome is that the company drop…


Customising the Company Login window series Part 2 - Visual Basic for Applications

Following on from my previous post: Customising the Company Login window series Part 1 – Introduction, here is the method to create a solution using Visual Basic for Applications (VBA). As discussed in the earlier post, the problem we are trying to overcome is that the company drop down list on the Company Login window is…

3

Customising the Company Login window series Part 1 - Introduction

Recently a comment from David M (not me) was posted on the Support Debugging Tool Portal (https://aka.ms/SDT) page asking: “We have some fairly long names for our GP companies. Well, when logging onto GP, the second “Company Login” screen cuts off the company names too short for us. The entry field for companies allow for…

1

Troubleshooting the Microsoft Dynamics GP 2013 Web Client Series

My friend, Mariano Gomez aka The Dynamics GP Blogster, has been busy writing a fantastic series of articles about troubleshooting the Microsoft Dynamics GP 2013 Web Client. Mariano was one of the early adopters of the technology and worked closely with Microsoft support and development teams to provide lots of great feedback. He has gained…

1

Developing with the Microsoft Dynamics GP 2013 Named System Database

Microsoft Dynamics GP 2013 introduced another long sought after feature…. The Named System Database. Instead of the System database being hardcoded to DYNAMICS, a different name can be selected when installing GP. So what does that mean? Well, it means that more than one Dynamics GP system can reside on a single instance of SQL…

0

How to create Dexterity Cross Dictionary Lookups

As you may know, I was one of the pioneers of Cross Dictionary Dexterity Development and have posted about it a number of times (also see Can I customise a 3rd party form with Dexterity? and Understanding Cross Dictionary Dexterity Development). I am currently involved as a technical advisor on a large consulting project which requires customisation to…

1

Update: Resizing SmartList TreeView and ListView panes using the Support Debugging Tool

As promised in my post Quick Tip: Creating a Splitter control between panes of a window with Dexterity, I have updated the concept of my previous post: Resizing SmartList TreeView and ListView panes using the Support Debugging Tool to use a Splitter control rather than selecting a percentage via a menu option. In this example, I am…

20

Quick Tip: Creating a Splitter control between panes of a window with Dexterity

For many years Dexterity developers have wanted to be able to add a splitter control to windows with “panes” created with lists, treeviews or listviews. Using the window Object property Resizeable set to True-Per Field, developers have created windows which can be resized but the join between the panes has been fixed as either Stay…

3

Further Update: Obscuring Table Data Fields using the Support Debugging Tool

A while back, I posted some articles which used the Support Debugging Tool and non-logging Automatic Debugger Mode triggers to “encrypt” data. The use of the word “encrypt” was unwise as it has connotations about providing a level of security and possible compliance with various standards. So, to more accurately describe what is happening AND…

0

Update: Adding Window Size and Position Memory using the Support Debugging Tool

While I am updating examples, I have made some changes to the Adding Window Size and Position Memory using the Support Debugging Tool sample code. The original version used the Dex.ini to store the window size and position as a setting, for example: MBS_Win_POP_PO_Entry_POP_PO_Entry=-400,-118,664,456 The problem with this method is that it does not work well…

4

Update: Obscuring Table Data Fields using the Support Debugging Tool

A little while ago, I posted an example of Obscuring Table Data Fields using the Support Debugging Tool. During my recent Dexterity Training class, I showed this example to the attendees and was asked about how the obscuring worked with reports. So, as a test, we printed the RM Customer Report from the Customer Maintenance window to find…

1

Determine Company_Options from DYNAMICS.dbo.SY01500 (Reading a Multi-Select List Box)

A recent post on DynDeveloper.com caught my eye as I have faced a similar problem before and had to work quite hard to get the correct answer. The post was titled: Determine Company_Options from DYNAMICS.dbo.SY01500 and asked how to figure out how to interpret the binary(4) field. I realised that the solution for this issue would…

2

Obscuring Table Data Fields using the Support Debugging Tool

My colleague, Allan, had a case recently where the customer had noticed that the Credit Card Number field stored on the Customer Master table at the SQL Server level was not encrypted or obscured and could be seen by anyone who could access the data. Before, you say that this is a huge security risk,…

1

Resizing SmartList TreeView and ListView panes using the Support Debugging Tool

This article is another Support Debugging Tool Non-Logging Trigger example and is a follow up to two previous articles: From this blog: Adding Window Size and Position Memory using the Support Debugging Tool  From Mark Polino: Dynamic Future – Vote – Resize the Left Pane on Smartlists This example stores the size and position of the…

7

Adding Window Size and Position Memory using the Support Debugging Tool

As a follow on to the article: Using Support Debugging Tool Non-Logging Triggers, I thought I would post a few small examples of how Non-Logging Triggers can be used for simple customizations. There have been some other examples posted in the past on this and other blogs. If you are interested have a look at…

2

How to calculate Aging Buckets based on documents shown on a Receivables Statement

I had a case a couple of weeks back, where the customer wanted to filter the transactions shown on a Receivables Management Statement. There was one type of transaction that they did not want included on the statements sent out to the customers. The transactions to be excluded could be identified by a particular value on the Description…

3

How to access data from other companies from Dexterity

Have you ever had to develop Dexterity code that needs to read data from a company other than the current Microsoft Dynamics GP company? Well, with my latest updates to the Support Debugging Tool, I came across this requirement. While developing the support for the Extender security objects, I realised that the Extender objects are…

7