Page 1 of 17212345678910...2025303540...Last »

#GPPT GP Power Tools Build 20 hotfix 2 released

David Meego - Click for blog homepageIf you come across the problem below, please download the GP Power Tools Build 20 hotfix 2 which is now available from the Mekorma website.

When using the Configuration Export/Import window to import a configuration settings file created with the Support Debugging Tool into GP Power Tools, it will say that there is nothing to import.

This issue was caused by the changes to make GP Power Tools work with SQL tables rather than with temporary tables written to a Debugger.xml file. It happened because the table names written into the configurations settings file was incorrectly changed so that they had a _TEMP suffix.

This hotfix now uses the correct table names when exporting and can read both sets of table names when importing, so it will be able to handle both the correct and incorrect formats.

If you already have GP Power Tools installed, please download this latest hotfix build and install it over the top of your existing instance.

This build can be identified by the Last Modified: 03-Sep-2015 date on the About GP Power Tools window. The installer versions (shown in file properties and under Control Panel >> Programs and Features once installed) are 11.00.0020.5, 12.00.0020.5 and 14.00.0020.5.

Version History

Below is a summary of the changes made for releases 11.00.0020, 12.00.0020 and 14.00.0020 hotfix 2 (Last Modified: 03-Sep-2015):

  • Fixed issue with incorrect table names for Configuration Export/Import causing imports to fail.

Downloads

The download links are on the bottom of Mekorma’s GP Power Tools page.

Note: You might be warned when downloading the installer that the file “is not commonly downloaded”. This is because the security certificate for Winthrop Development Consultants is still new and will take a little time to propagate through the internet. If this happens, you might need to unblock the file using Right-Click >> Properties >> Unblock.

GP Power Tools for Microsoft Dynamics GP – User Guide Manual Documentation

Note: The manual is included with the installer, but is also available as a separate download.

Support Information

Support for GP Power Tools is provided by Winthrop Development Consultants’ distribution and support partner, Mekorma.

Support cases can be logged using the link below:

Support hours are 6:00am to 5:00pm (US Pacific Time), Monday to Friday.

Pricing Information

For customers, the special introductory price for an annual subscription is US$365 per year. That’s Peace of Mind for a dollar a day, and every four years you will get an extra day for free. :)

Please place your orders via Mekorma’s Order Now page:

Partners can request Not for Resale (NFR) registration keys. Please email sales@Mekorma.com with the following details:

  • Contact Name
  • Company Name
  • Company Address
  • Phone Number
  • Your Microsoft Account Number

More Information

For more information, please see the GP Power Tools Portal Page:

You can also look at the GP Power Tools pages on the Winthrop Development Consultants and Mekorma sites:

 

Please post your feedback as comments on this article or using the GP Power Tools Feedback Survey on what you think of this build and what you would like to see in the future.

David

This article was originally posted on http://www.winthropdc.com/blog.

Filed under: 2010, 2013, 2013 R2, 2015, 2015 R2, Dynamics, GP, GP Power Tools, Microsoft, News, Products Tagged: GP 2010, GP 2013, GP 2015, GP Power Tools, GPPT

Continued here:
#GPPT GP Power Tools Build 20 hotfix 2 released

September 4, 2015 · WinthropDC · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 6

Friday Funny: What’s wrong with this mathematical proof?

David Meego - Click for blog homepageToday’s Friday Funny is something to see if you can remember your high school algebra.

The following mathematical proof suggests that 2 = 1, which would definitely cause some issues with the accounting type people out there.

So the question is:

“What’s wrong with this mathematical proof?”

Here is the proof that 2 = 1:

  1. Let a and b be equal non-zero quantities
    a = b
  2. Multiply both sides by a
    a2 = ab
  3. Subtract b2 from both sides
    a2 – b2 = ab – b2
  4. Factor both sides
    (a – b)(a + b) = b(a – b)
  5. Divide out (ab)
    a + b = b
  6. Observing that a = b
    b + b = b
  7. Combine like terms on the left
    2b = b
  8. Divide by b
    2 = 1      QED

If you can explain what is wrong here, then you might help explain why:

  • odd <> even
  • black <> white
  • night <> day

Post your explanations in the comments.

Enjoy

David

This article was originally posted on http://www.winthropdc.com/blog.

Filed under: Fun Tagged: Friday Funny, Fun

Originally posted here:
Friday Funny: What’s wrong with this mathematical proof?

September 4, 2015 · WinthropDC · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 9

Dexterity Training in Mexico City, Mexico (28th September to 2nd October 2015)

David Meego - Click for blog homepageLast week, I posted details of my Upcoming US Trip for reIMAGINE and GPUG Summit.

In that article I mentioned that I would be running a Dexterity Training session in Mexico City, Mexico during the time in between the reIMAGINE 2015 conference and the GPUG Summit 2015 conference.

Below are the details for the training as there is still some room for additional attendees.

Dexterity Splash

The training is running from Monday 28th September to Friday 2nd October 2015, from 8:30am to 5:30pm.

It is being held at the Axentit office, which is located at:

353 Durango Street,
México City,
Delegación Cuauhtémoc.

It is near from Chapultepec subway station.

If you are interested in attending, please contact Mariano Arias at marias@axentit.com.mx, or by phone at +52 55 52118871.

Looking forward to a great week.

David

This article was originally posted on http://www.winthropdc.com/blog.

Filed under: Development, Dexterity, News, Training Tagged: Development, Dexterity, Training

Read more here:
Dexterity Training in Mexico City, Mexico (28th September to 2nd October 2015)

September 3, 2015 · WinthropDC · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 8

You receive "Exception has been thrown by the target of an invocation" when running some reports in Management Reporter 2012 CU13

In my previous post, I talked about a cryptographic exception I encountered while upgrading Management Reporter 2012 from CU6 to CU9 (on the way to CU13), while attempting to setup the Data Mart database – see You receive “Could’n retrieve the list of available databases: The connection attempt failed” error when updating Management Reporter 2012. The solution turned out to be very simple, but in the scheme of things a bit time consuming to figure out. Once we had upgraded to CU9, it was time to attempt the upgrade to CU13.

The upgrade process

Upgrading to CU13 was pretty straight forward.  However, after the upgrade, the customer attempted to generate a couple of the many reports from Report Designer with the following error being displayed in Web Viewer:

This report can’t be displayed. Make sure that your computer has an internet connection and that Management Reporter is running. If this problem continues, contact your administrator.

Image
Management Reporter 2012 CU13 error when generating report to Web Viewer

When attempting to open the same report from Report Viewer, we obtained the following exception error, with the Report Viewer application crashing after clicking the OK button:

Exception has been thrown by the target of an invocation.

Image

After the errors, we tried copying the columns, row definitions, and trees onto completely new report objects (rows, columns, and trees), respectively, and tried to run the reports once more, obtaining the same results. The customer relies on this report on a daily basis, so it was critical we fix whatever issue was causing these reports to crash.

After some back and forth with Microsoft Support, it was determined that with CU13 the B0 print control in the row is not working and causing the exception:

System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.InvalidCastException: Specified cast is not valid.

Microsoft Support is currently working on getting the issue written up and triaged so as soon as a bug number (or a fix!) is available I will publish more about it.

As it stands, we reverted back to CU9 and upgraded to CU12 which did not display the issue described herein.

Until next post!

MG.-
Mariano Gomez, MVP
Intelligent Partnerships, LLC
http://www.intelligentpartnerships.com/

View the original here:
You receive "Exception has been thrown by the target of an invocation" when running some reports in Management Reporter 2012 CU13

September 1, 2015 · Mariano Gomez · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 13

How to dynamically modify Extender windows

David Meego - Click for blog homepageThis blog article has been prompted by the thread below on the Microsoft Dynamics GP community forum:

I had responded with some information on the thread, but when I tried to implement the suggestions I made, I found that it was not actually possible and that other methods would be needed.

The Extender product is a very clever tool created by my friend Andrew Brown from eOne Solutions, it allows Microsoft Dynamics GP windows to be “extended” with additional custom fields. These fields are entered using additional Extender windows and are stored in a series of tables in SQL Server. Each custom field is stored as a single record in one of a series of SQL tables depending on its datatype. The idea behind the product is to allow customisation of Dynamics GP without needing any coding. That said, the Extender Enterprise product does allow you to add custom logic with scripts.

While Extender itself is very flexible, it can be difficult to customise, or modify the windows. The methods that you would use for a standard window will not work.

The Problem

The issue is that Extender windows as they are seen by the user don’t really exist. The Extender windows that the user sees are dynamically created using a series of hidden template windows. For each type of Extender window or form, there are 10 template windows. The reason for the multiple windows is so that you can open more than one Extender window of each type at a time, Extender just uses the next available window. This is similar to how Dynamics GP has five Note windows which are dynamically used.

Each of these windows has one field of each datatype for each line on the window. When the window is opened by Extender, it reads the setup definition then hides and shows the fields as required to display the correct window. It populates the read-only string fields to display the prompts and also renames the window title. Finally, it resizes the window to remove the extra white space.

Disclaimer: There may be other steps and the order might differ. I don’t have the source code, so this is just my understanding…. but you get the idea. :-)

So, how can I modify a window that is dynamically created from one of the template windows? For our example, I want to disable the delete button on an Extender window, but only when that window is being used as a specified Extender window (based on the Window Extender ID).

Below are some of the usual tools which can be used and details of their limitations:

Customisation Tool Issues Notes
Modifier As the Extender windows are hidden from the Security subsystem, it is not possible to tell Dynamics GP to open a modified version of the window instead of the original. Even if it could work, you would need to modify all 10 windows of the same type and any change would affect all Extender windows of the same type as there is no scripting.
Field Level Security As the Extender windows are hidden from the Security subsystem, they cannot be selected from the Field Level Security Resource Explorer. Even if you could select the window, you would need to modify all 10 windows of the same type and any change would affect all Extender windows of the same type as there is no scripting.
Rockton Software’s Conditional Field Level Security As the Extender windows are hidden from the Security subsystem, they cannot be selected from the Field Level Security Resource Explorer. Even if you could select the window, you would need to modify all 10 windows of the same type. With the conditional scripting it would be possible to check which Extender ID and make the customisation dynamic, but Field Level Security prevents us even selecting the window.
Visual Basic for Applications It would be possible to use VBA scripting to read the Extender ID and create a dynamic customisation. This customisation would have to be repeated for each of the 10 windows and then be deployed to every workstation in your system.

 

The Simpler Solution

Just use GP Power Tools.

Using the Resource Information window in Form mode with the show currently selected window option enabled, I clicked on the Delete Button on the example Extender window that I created. It identified the field as ‘Delete Button’ of window ‘User Defined Window’ of form PT_UD_Window_1.

Using the Runtime Execute window, I used the Names button to lookup other fields on the PT_UD_Window_1. To display the form on the GP Power Tools Resource Explorer, I ticked the Hidden Forms checkbox. I located the ‘PT Window ID’ field which holds the Extender Window ID.

warning 'PT Window ID' of window 'User Defined Window' of form 'PT_UD_Window_1';

The above code was executed in the context of the Extender Dictionary and confirmed that the field contained the value I was expecting for the open Extender window.

Using the Automatic Debugger Mode Setup window, I created an Automatic Starting, Non-Logging Trigger on the Window Activate Focus event of the window ‘User Defined Window’ of form PT_UD_Window_1 with the following script:

out boolean OUT_Condition;

OUT_Condition = false;

if isopen(form PT_UD_Window_1) then
	case 'PT Window ID' of window 'User Defined Window' of form 'PT_UD_Window_1'
		in ["TEST ITEM 2"]
			disable 'Delete Button' of window 'User Defined Window' of form 'PT_UD_Window_1';
			OUT_Condition = true;
		else
	end case;
end if;

Where “TEST ITEM 2” in the case statement is the Extender Window ID for the window on which I want to disable the Delete Button. If desired, more windows can be added into a list separated by a comma.

Extender Window Delete Example

Using the Window Activate (window gains focus) event is a little lazy but it avoids having to identify the actual script after which our code should run.

Extender Window Delete Example 2

The final step, is to duplicate (using the Duplicate Button) and modify the Triggers for the other 9 windows. It is easiest to copy the script into a Notepad.exe window before modifying the form name on the Resource tab, so it can be pasted back.

Deployment of the customisation is simple… it is already done. The triggers will automatically start working on all workstation on which GP Power Tools is installed.  No need to do anything more.

The example GP Power Tools settings file for the 10 windows can be downloaded from here.

Hope you find this helpful.

David

This article was originally posted on http://www.winthropdc.com/blog.

Filed under: Development, Dynamics, GP, GP Power Tools, Microsoft, Modifier, Products Tagged: Application, Extender, GP Power Tools, GPPT, Modifier

Read More:
How to dynamically modify Extender windows

September 1, 2015 · WinthropDC · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 20

Dynamics GP – Cashbook Bank Management (CBM) vs. Electronic Bank Management (EBM) vs. Bank Reconciliation (BR)

I have been doing a fair bit of explanation around Cashbook Management and Bank Reconciliation modules in GP over the past few weeks. I found the explanation from Brian Wick below was pretty good. To add on to his excellent explanation – here are a few additional items –

Cashbook Management –

  • Cashbook has support for more Multicurrency transactions. They can do bank transfers in as many as four currencies at the same time for instance whereas Bank Rec allows just two
  • Easier to track Tax with Bank Transactions (However, you should typically be using AR/AP modules in GP and let tax flow from there) . I’ve heard the argument from some customers that they have been told that this is the only way to track tax when accounting for GST or VAT. That is NOT correct! 
  • Support for more transaction types such as GL Checks and RM Checks with don’t really have a counterpart in the Ban Rec product
  • No eConnect Import Interface

Bank Reconciliation

  • More commonly Used, better and easier to support 
  • Works well and meets most requirements other than the 4 currency bank transfer requirement discussed above.
  • Has eConnect Import Interface

Cashbook Bank Management (CBM) vs. Electronic Bank Management (EBM) vs. Bank Reconciliation (BR)

(Bank Management (BM) refers to both CBM and EBM)

The major difference between Bank Management and the Bank Reconciliation is that the Bank Reconciliation receives most of it transactions from other modules. Debtors and creditors cash transactions are captured in RM and PM and Bank Reconciliation is updated accordingly.

You can capture all your cash transactions in Bank Management and RM, PM and GL will be updated accordingly. The windows updated in Great Plains are RM Cash Receipts, RM Transaction Entry (payments to debtors), PM Manual Payments, PM Transaction Entry (receipts from creditors) and GL General Entry.

However in the CBM transactions captured in PM transaction entry, RM transaction entry, SOP, invoicing and PM computer cheques also update CBM in the same way that Bank Reconciliation is updated.

The reconcile functions in CBM and Bank Reconciliation are very similar so the major difference between CBM and Bank Reconciliation is that Bank Reconciliation receives transactions from other modules and Bank Management is a single point of entry for all cash transactions. All other differences are in functionality: Batch processing, full multicurrency, Electronic Reconcile Management (Auto Bank Recon), Intercompany Payments and Deposits, Intercompany many to many Bank Transfers, Payments to Debtors and Receipts to Creditors ext.

The difference between the CBM/Bank Reconcile and EBM is due to the fact that in EBM you do not have any source documents (Cheque counterfoils, Deposit slips ext.) as 90% of the transactions are done via electronic transfer. So the first time we find out about a transaction is when it appears on the bank statement.

In CBM and Bank Reconciliation we capture our transactions from source documents (Cheque counterfoils and deposit slips) and then reconcile the transactions that are on the bank statement to the transactions that we have already captured.

In EBM we capture our transactions from the bank statement and then post the transactions to RM, PM and GL. As the source document is the bank statement there is no need to do a separate reconcile so the post and the reconcile is one process.

In EBM we do however allow for transaction that originate form counterfoils and deposit slips. When this happens the user will capture these transactions in RM and PM but instead of posting to the Bank Account the transactions will post to a Holding account. When the transactions appear on the Bank Statement they will be captured as normal and then matched to the original transactions in the Holding Account. Regardless of the type of the transaction (GL, AP or AR) EBM will create GL transactions moving the money from the Holding account to the Bank Account. Thus the Bank Account will only be affected by transactions that have appeared on a bank statement. By doing this the Bank Account will always have a true balance.

So the difference between CBM/Bank Reconcile and EBM is that CBM/Bank Reconcile are driven by source documents and EBM is driven by the Bank Statement.



Best regards,
Brian Wick
Partner Online Technical Community

See the article here:
Dynamics GP – Cashbook Bank Management (CBM) vs. Electronic Bank Management (EBM) vs. Bank Reconciliation (BR)

July 23, 2015 · Jivtesh Singh · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 49

Microsoft Virtual Conference Sessions–May 14 & 15

As part of the MVP Virtual Conference – there are a range of sessions from Azure, to BI that you can attend for free. Register here – http://mvp.microsoft.com/en-us/virtualconference-sessions.aspx

Here are some I am keen on attending –

Detecting Facial Expressions with Azure Machine Learning and Kinect for Windows

Speaker: Dwight Goins

Moderator: Gian Paolo Santopaolo

This session is about learning how to use Microsoft Azure Machine Learning with the Kinect for Windows in order to detect Facial expressions. This session will cover an introduction to Machine Learning, and different algorithms used to detect data patterns. The algorithms discussed will be nearest neighbor, probabilistic learning, decision trees, and neural networks. It will also cover an introduction to the Kinect for Windows device, such as explaining the features and capabilities of the device and SDK. The session will show basic demos and data coming from the device. The session will then drill down into HD Face and describe the data which is generated from Face and HD Face tracking. Lastly the session will show a demo and provide steps on how to incorporate Azure Machine Learning features into a Windows 8.1 Kinect enabled application to detect facial expressions in real time.

Microsoft Azure Infrastructure Automation with PowerShell

Speaker: Trevor Sullivan

Moderator: Anil Desai

Many IT Pros in the industry have begun their virtualization training with VMware, but as the market shifts in other directions, a lot of administrators are finding themselves managing multi-hypervisor environments. Many businesses are now in the process of migrating some or all of their virtual workloads to the Microsoft Hyper-V platform for a number of reasons including, cost savings, scalability, and ease of management. While managing a Hyper-V cluster is somewhat similar in concept to ESXi, there are some fundamental differences. This session will cover Hyper-V clustering, management differences, and the migration of VMs from ESXi to Hyper-V. The entire session will be geared towards VMware administrators who are looking to broaden their horizons by adding Hyper-V know-how to their toolbox.

10 New Things for Developers on Windows 10

Speaker: Colin Melia

Moderator: Mark Schramm

It’s in the title. If you didn’t have time for Build or you just want to get a summary of 10 new features for developers from the new and/or updates APIs, tools SKUs and/or languages, from devices to the cloud, this is your chance to get on board.

Resolving Conflicts in Collaborative Occasionally Connected Mobile Apps

Speaker: Michael Perry

Moderator: Bryan Hunter

In collaborative apps, a change made on one device appears on another. Data flows seamlessly across devices. But those devices aren’t always connected. And even when they are, users don’t want to wait for a network connection before they can see or work with their data. So data needs to be stored locally, and synchronized in the background.

Read More:
Microsoft Virtual Conference Sessions–May 14 & 15

April 7, 2015 · Jivtesh Singh · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 103