Page 1 of 4112345678910...2025303540...Last »

Excel Copy/Paste feature not working on General Entry modified window

If you have grown used to the relatively new Excel Copy/Paste feature in the General Ledger Transaction Entry, you are probably enjoying the benefits of collecting journalized spreadsheets from around the company and simply integrating these into Microsoft Dynamics GP without too much effort.

Excel Copy/Paste in GL Transaction Entry window

The fact is, not having to run an integration from another tool for something apparently very simple, always seems to be the way to go.

Recently, however, I ran into a situation where this window had been customized with Modifier (but the same can be said for a third party alternate version of window) by a customer. The customer reorganized a few fields within the window and added a couple others with Modifier to address some specific business needs. As it turned out, the Excel Copy/Paste functionality no longer worked, even though the target fields remained the same. Reverting security to the original window rendered the feature usable once more.

If you must modify this window _and_ still require the Excel Copy/Paste feature, you will need to create an additional user with access to the original (core) window. This is very similar to what’s required for Integration Manager to function when a window has been modified with Modifier or changed by a third party product.

Well, now you know! Happy copy/pasting!

Until next post!

Mariano Gomez, MVP

See more here:
Excel Copy/Paste feature not working on General Entry modified window

October 23, 2015 · Mariano Gomez · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 43

OFF-TOPIC: Windows 10 and Microsoft File Transfer Manager (FTM) Issues (UPDATE)

Originally posted on Dynamics GP – Learn & Discuss:

This is my first post from Perth, WA. It’s been an excellent journey and so far so good. More about my Perth life later.

This is something that I never experienced before. When you download any file from PartnerSource or CustomerSource, Microsoft would let you do that only through it’s File Transfer Manager program. If you have that installed already, any download initiation would first invoke this program and then let you set the path/folder to take in that download and etc.

However, when I tried to do that from my new Windows 10 machine, the FTM did not open. I tried to figure that out, but later remembered this same issue happening on my Windows 8.1 machine.

Basically, from Windows 8.1, for some reason, calling the FTM from Internet Explorer worked only on a 32 bit Internet Explorer.

Looks like Microsoft has not fixed that yet. If you are wondering why your FTM…

View original 55 more words

Filed under: Uncategorized

See the original article here:
OFF-TOPIC: Windows 10 and Microsoft File Transfer Manager (FTM) Issues (UPDATE)

October 5, 2015 · Vaidyanathan Mohan · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 53

Discount from Packt Publishing

Have you been thinking you want to get one of my books, but holding off? No time like the present! Through the end of September my publisher, Packt Publishing, is offering 50% off if you use discount code MDGP150. No more excuses. :-)Filed under: Dynamics GP Tagged: book, Dynamics GP, featured

Original post:
Discount from Packt Publishing

September 15, 2015 · Victoria Yudin · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 79

GP2015 R2 Upgrade – GP Utilities “SynchronizeTableData()” Error & Fix

This issue has already been reported and it’s also been addressed. I would like to post this still. To act more like a pointer. It’s quite crucial in nature.

I have been testing GP2015 R2 upgrade on my test environment when I faced the following error message:

Screen Shot 2015-07-27 at 6.10.32 PM

Quite evidently, upgrade didn’t go through after. I remembered this being posted on our GP Support & Services blog. Dug the post and got the solution.

Here’s the post: Known Upgrade Issues When Upgrading To Microsoft Dynamics GP 2015 R2

Please note that this has been fixed already and is available with June 2015 Update.


Filed under: #MSDYNGP, GP 2015 R2, GP Utilities, GP2015, GP2015R2, Upgrade

More here:
GP2015 R2 Upgrade – GP Utilities “SynchronizeTableData()” Error & Fix

July 27, 2015 · Vaidyanathan Mohan · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 138

GP 2015 R2 Upgrade Issues & Possible Solutions

There is a GP community forum question that discuss about GP 2015 R2 upgrade errors. As always, contributors have poured in their thoughts and possible solutions to fix these issues.

Read the question here: GP 2015 R2 errors during update & Fixes

I recommend this post to everyone who are planning to upgrade to GP2015 R2 soon. This may save a lot of time.

Thank you GP community for being selfless, informative and helpful.


Filed under: #MSDYNGP, Dynamics GP 2015, GP 2015, GP2015R2, Microsoft Dynamics GP, Troubleshooting, Upgrade

GP 2015 R2 Upgrade Issues & Possible Solutions

June 4, 2015 · Vaidyanathan Mohan · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 255

Refreshable Excel report for monthly GL budget in Dynamics GP

Dynamics GP has some great functionality for uploading a General Ledger budget from Excel. However, if you have a lot of accounts, getting the data back into Excel is sometimes a little more time consuming than desired. I recently created a refreshable Excel report that uses a SQL stored procedure for this and wanted to […]

See the original post:
Refreshable Excel report for monthly GL budget in Dynamics GP

April 28, 2015 · Victoria Yudin · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 169

Microsoft Convergence Atlanta 2015 (#CONV15) – Day 4

Phew! How about that OneRepublic concert?

Day 4 is finally here and with it, all good things must come to an end. For a change, today David and I managed to make it down to the GWCC on time and had a fairly relaxed breakfast at the Meal Hall to then move over to the Phillips Arena for one very interesting closing keynote.

As customary, an energetic Judson Althoff, President Microsoft North America welcomed the crowd to the event and proceeded to recap the week and what will be seen from Microsoft in the coming months.

Judson Althoff, President Microsoft North America

The first thing in his opening was to remind the audience how Convergence is becoming the premier event for business and that Microsoft, at its core, is “the productivity and platform company for the mobile first, cloud first world” and how the company is thinking about innovation and technology.

Althoff then introduced the upcoming events, Microsoft Ignite which is geared to showcase innovations for IT professionals, the Dynamics User Group Summits hosted by Dynamic Communities.

Microsoft Ignite

Dynamics User Group Summits

Althoff then zeroed in on the upcoming Convergence events and announced the dates and locations for Convergence 2015 EMEA and Convergence 2016 New Orleans. The latter received a round of shouts from the audience.

Convergence next stops

Then came the topic of the day: Cyber-security and the work being conducted by Microsoft and its Digital Crime Unit to counter the effects of online criminal activity.

After a short intro video (above), David Finn, Executive Director Microsoft Digital Crimes Unit who then introduced the work of the new division opened just 16 months ago and located in Redmond, Washington. The unit fights two types of crimes: Technology-facilitated crimes which targets vulnerable population such as children and the elderly, and Malware and reduction of digital risk.

David Finn, Executive Director Microsoft Digital Crimes Unit

Finn then presented a number of grim statistics around the children victimization and introduced Microsoft PhotoDNA, a new cloud based solution that can be licensed by anyone to detect awful images and report them to law enforcement organizations around the world.

Microsoft PhotoDNA

David Finn then addressed the topic of malware and cyber criminal activity using botnets and how Microsoft assisted with the Citadel Malware case, which involved the infection of over 91 million PCs and the hijack of close to half a billion dollars ($500M). The case had a particular focus on using visualization and big data to analyze infection patterns across the world.

The Citadel Case

Citadel Infection Pattern

As a result of these efforts, Microsoft is experimenting with new visualization and sonification techniques to understand infection patterns. One such technique is dubbed the Specimen Box and was presented during the session.

Specimen Box – Live Mode

After the closing session, we returned to the GWCC to do some walk around the Expo. I stopped at the booth of my friends and partners at FieldOne to congratulate them for their new achievement. Microsoft has named them a Dynamics CRM Global ISV which shows their commitment to developing the channel and producing quality products.

The FieldOne team

From the Expo, I went to Mark Polino’s session CS15G003-R2 Microsoft Dynamics GP: New 50 tips in 50 minutes, a jammed pack session filled with bite size tips on Microsoft Dynamics GP functionality. Mark had a full room and as the rock star he is, he commands quite the attention from the attendees. I have to admit I picked up a few good tips for my toolbox.

Up next, I had to complete the repeat of my upgrade session, CS15G002-R2 Microsoft Dynamics GP 2015: Upgrading and deploying. I had been assigned the last slot on the last day of the event, which I have been doing for the past 6 years now. While I did not have the same amount of attendees as with my first bout at this session, 85 people were still pretty good, considering that a lot of people left to catch their flights early in the morning.

After my repeat session, it was time for some relaxation and the famous Tim Tam Slams. Earlier, I had sent out a tweet to a number of people to meet up at the Omni Hotel bar for what has become a tradition among a select few of us. Before the slams though, I managed to meet with a group of friends from Colombia to explain some good ol’ fashioned Microsoft Dynamics GP architecture and deployment options for their company and how the web client and Microsoft Azure have revolutionized the way Microsoft Dynamics GP is deployed.

I then moved over to the bar with my friends Olga Acosta and Eddie Yepes to grab a drink before sitting down for Tim Tam Slams.

Olga Acosta does the Tim Tam Slam

Eddie Yepes does the Tim Tam Slam (and fails miserably!)

The final stretch of the evening would have me doing dinner with my good friends and fellow MVPs Belinda Allen, John Lowther, and of course David Musgrave at Dantanna’s Downtown location, inside the CNN Center. We spent the evening chit-chatting from one thing to another and enjoying John’s vicious appetite for Thousand Island dressing on his salad.

After a wonderful meal and excellent service we proceed to leave, not without running into the Njvity folks.

Chris Dobkins, Mariano Gomez, Emily Roen, and David Musgrave

The event was now over for good and it was time to leave. I really could use some sleep… but wait, still more to come.

Until next post!

Mariano Gomez, MVP
Intelligent Partnerships, LLC

Read more here:
Microsoft Convergence Atlanta 2015 (#CONV15) – Day 4

April 2, 2015 · Mariano Gomez · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 165