Simulate DEX_ROW_ID in a SQL View Using ROW_NUMBER() – #MSDYNGP


I have a requirement in which I have to access a SQL view from within my customisation dictionary, in order to create a custom lookup for users to select a value based on an Extender form and an Extender lookup. Easiest option is to create an Extender view (which in turn creates a SQL view for us).

Now, this is the view that I am suppose to refer to from my custom dictionary. Dexterity allows us to refer to any SQL object by simply create a TABLE definition and mention the SQL object (table or view) name as the physical name.

Dex View

Everything looks perfect till you actually see below error messages at runtime:

Dex View - Error 1

Dex View - Error 2

Error message is quite obvious; you do not have DEX_ROW_ID in that SQL view that you are referring to. Every single Dexterity table must have DEX_ROW_ID at the backend. It cannot afford to not have one.

So how am I going to resolve this? By simply adding a record number dynamically to the SQL view created by Extender. How to do that? By adding the T-SQL function ROW_NUMBER(). This is how I achieved it:

ROW_NUMBER USAGE

 

Definition of ROW_NUMBER() can be found here: ROW_NUMBER (Transact-SQL).

A simple yet powerful SQL function has given me the power to do what I wanted in no time. Oh, and my custom lookup referring to this view is working like a charm. Users are happy and so am I.

VAIDY

OFF-TOPIC: Change Power Button Behaviour in OS X Mavericks


Whenever I accidentally press the power button on my MacBook, it switches off the display. This behaviour change happened from OS X Mavericks (10.9).

Earlier it used to let us choose with following options:

Power Button Options

OSXDaily.com has got a workaround for this trouble. It does not straightaway enable these options the moment you press the power button, but it prevents OS X Mavericks from switching the display off, which is far more relieving.

To invoke the above power button options: press power button continuously for a second or two.

Thanks OSXDaily.com.

VAIDY

Support Debugging Tool (SDT) – Build 18 Released #MSDYNGP


Amidst crazily busy schedule that I have at the moment, this one must be blogged.

Support Debugging Tool (SDT) Build 18 has been released.

I have a fair idea about how much efforts had gone in. Knowing that, list of new features and list fixes this build contains, I think this is one of the biggest releases yet for SDT.

Just stop your work already and download it from provided links on SDT portal.

VAIDY

OFF-TOPIC: Motivating Employees a Choice of Promotion or Prevention – TLNT via @OfficeVibe


This post is so very different, even if it’s an off-topic one, from what I usually post on my blog. But considering the fact that I have been witnessing some of the worst things that directly relates to this topic, I think it’s quite timely.

I read this post, Motivating Employees Can Simply Be a Choice of Promotion or Prevention, posted on TLNT – The Business of HR, about how employees get motivated; either a promotion or a prevention. Thanks to @OfficeVibe to share this post.

To just brief you on this, an employee can get motivated in a typical corporate environment to perform well: to get promoted and climb up the corporate ladder OR to play it safe and prevent undesired. Both have it’s own pros and cons.

In my opinion, at times, promotion oriented motivation could easily lead one to become power-hungry and become selfish in achieving his/her goals that are totally self-centred. It easily poisons one’s attitude to put his/her organisation’s goals down. If this person is at middle level in an organisation hierarchy to whom people report, it could get worser than you might imagine. He/she becomes the biggest threat to an organisation than even the organisation’s competitors. I have witnessed this big time in the very recent past. So that makes this topic so relevant to me personally.

In a stark contrast, prevention oriented motivation could easily lead one to become completely oblivious unless his/her contribution is duly noticed by management and reward him/her without wasting any time. This person becomes oblivious when management fails to notice and recognise. Also, this approach may quite easily make the management to believe that such person would work and contribute irrespective of whether he/she is recognised and rewarded or not.

While promotion oriented approach may backfire at an organisation’s health, prevention oriented approach may backfire at the individual’s career and growth.

Big question hanging in front of me: How To Strike A Balance Between Both?

Do not hesitate to share your thoughts in the comments section.

VAIDY

The Challenge of Making ERP Systems More Configurable


Vaidhyanathan Mohan:

An interesting post that I read on Ventana Research by Robert Kugel.

Originally posted on :

In the wake of the past year’s usual crop of failed ERP implementations, I’ve read a couple of blogs that bemoan the fact that ERP vr_ERPI_01_implementing_new_capabilities_in_erpsystems are not nearly as user-friendly or intuitive as the mobile apps that everyone loves. I’ve complained about this aspect of ERP, and our research confirms that ERP systems are viewed as cumbersome: Just one in five companies (21%) said it is easy to make changes to ERP systems while one-third (33%) said making changes is difficult or very difficult. Yet as with many such technology topics, addressing the difficulty in working with ERP systems is not as straightforward as one might hope. ERP software vendors must make it easier, less expensive and less risky for customers to adapt the systems they buy to their changing business needs. To do this, vendors must design products to be more configurable. The goal should be that…

View original 1,178 more words

OFF-TOPIC: Batch Print Multiple Files in Mac OS X Without Opening Them – Jesse Chapman @jessechapman


One of my users use Mac OS X Mavericks and his major concern was to batch print files in a folder without opening each one of them. He somehow (?!?!?!) trusted my expertise in Mac OS to find a solution.

My best friend, Google, came to my rescue again. I got this gem of a post by Jesse Chapman (sorry Jesse, I tried getting a profile page of yours, but could only get your twitter page) on his blog wait, really? that saved my day.

Read it here: How to batch print multiple files in Mac OS X without opening them.

Though the post is for Mac OS Snow Leopard, it still works charmingly on Mavericks. Thanks a bunch, Jesse.

Upside; I am now considered an expert in Mac OS by at least one Mac user in this world :-DDownside; I may get more support requests with Mac OS :-P.

But hey, I am not even complaining.

VAIDY

Analytics For Dynamics GP – BI Solution From Mark Polino (DynamicAccounting.Net) #MSDYNGP


Mark Polino of DynamicAccounting.Net has released first among series of Excel Dashboards, Sales Analytics Starter Edition, for Dynamics GP. This dashboard series is named as Analytics For Dynamics GP.

Sales Dashboard

Sales Starter Edition has got following charts with whole set of important filters:

  • Top Customers (with costs)
  • Top 10 Products (with costs)
  • Top 10 Salespeople
  • Top 10 Sales Territories
  • Top 10 Sites
  • Sales with Trend and Projection
  • Sales Mix with Item Class

It’s a simple plug and play kind of dashboard on Microsoft Excel (v2010 & v2013) file. Setting this up once you buy it is so very easy. How to map your GP data server is clearly explained as part of this dashboard solution. And you can modify this as you wish once you link this to your GP data server.

As it is just an Excel file with a straightforward GP data server connection, all you need to do is to click on refresh to get the real time information.

This sales dashboard starter edition is priced at $249 +$49 annual maintenance. Maintenance covers updates, improvements and fixes. Click on links provided across this post to visit Mark’s Analytics For Dynamics GP product page, learn more about this awesome BI solution and know how to buy your copy.

In my personal opinion, this is a simplistic and satisfactory BI solution which meet its promises pretty well.

VAIDY

#MSDYNGP Extender View Involving Extender Window/Form – Strange “Add Link” Issue & Reason.


Firstly, I am not sure whether I should categorise this as an issue. Let me explain this with an example.

For illustrative purpose, my requirement is to assign an additional information to customers. In addition to Country Code, I would like to assign from which continent a customer is from.

First step; to create an Extender Form named Continent Maintenance in which I will maintain list of continents. I do not need anything information other than an ID (Continent ID) and a name (Name); as shown below:

Snip20140114_1

Note that there are no fields apart from ID and Description.

Second step; I am going to create an Extender Window for Customer Maintenance (Cards -> Sales -> Customer -> Additional -> Continent) to assign a continent to a customer. Extender Window definition is as follows:

Snip20140114_2

Third step; is to check whether things are properly done and confirm. Let me open Customer Maintenance and see if I can access this new Extender information:

Snip20140114_3

Perfect. Let’s now get into the actual issue.

I would like to create a view to retrieve customer continent information. To achieve this, I would like to link Assign Continent (Extender Window) with Continent Maintenance (Extender Form) to get the continent name. Ideally, my view should retrieve following:

Customer ID, Continent ID, Continent Name

Now, when I try to create an Extender View linking my Extender Window and Form, I end up facing below issue:

Snip20140114_4

Snip20140114_6

Did you see that? I do not have my Extender Form fields shown here. I have two fields; Continent ID and Name. Where are they? Why are they not shown here? Shouldn’t it be available for me to link with my Extender Window’s Continent ID?

REASON: If your Extender Form DOES NOT have any other field than an ID and a Description (in my case, Continent ID and Name), ADD LINK To Field will not list out the ID and Description fields.

Is that the actual reason? Let’s confirm by adding another field to Extender Form as follows:

Snip20140114_7

After adding above field, Additional Info., look at my Extender View Add Link now:

Snip20140114_8

Did you see that? They are available now. AFTER adding a field in addition to default ID and Description fields.

And I am not sure how many have ever noticed this. I am noticing it for the first time now. I haven’t created any form with only ID and Description till now. I had to spend 4 hours to identify this reason, honestly. Had no idea whatsoever.

Those who are going to deal with Extender views with form(s) having ONLY ID and Description fields, save your 4 hours. :-)

VAIDY

Delete a Company in Microsoft Dynamics GP – Compatible With GP 2013


We have a SQL script named ClearCompanies.sql, which is available on Customer Source or Partner Source. This script removes all references to those companies that are not available in SQL Server, but pretty much exist in GP records.

It’s an all important script for all implementers, developers and consultants. Now this script has been updated to cater for also GP 2013. I had not used this script for a long time, so never realised it till today. This is particularly important as GP 2013 now support multi-tenant architecture (multiple GP System DB on same SQL instance).

You can download this script from here (provided you have a Customer Source / Partner Source account): ClearCompanies.sql.

VAIDY

Management Reporter Configuration – Part Of Domain Error


I am not sure how many would have noticed this error message. Just thought of sharing this with you all.

I installed Management Reporter 2012 CU7 on my machine yesterday night for some testing. I had not done this outside a network (being physically away from a domain) before, so never expected an error. But following error message popped up:

Snip20140106_4

 

My machine is already part of a domain. So above message was a bit confusing. Later I realised that I MUST be connected to my domain when the configuration process is run.

Which means the machine on which you are installing Management Reporter Server component CANNOT be physically outside the domain (even though it is already added to one) when you configure it.

This morning I restarted the configuration process and it’s done without issues. Interesting.

VAIDY