Page 1 of 4412345678910...2025303540...Last »

Refreshable Excel report for historical GL trial balance in Dynamics GP

Want to see your historical General Ledger trial balance in Excel? Yes, you can always print out the one from GP and dump it to Excel and manipulate the results, but there is an easier way. Below is a stored procedure you can use to create this. As an added bonus, if you’re using GP Reports Viewer you can […]

More:
Refreshable Excel report for historical GL trial balance in Dynamics GP

August 13, 2015 · Victoria Yudin · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 36

You experience slow performance exiting Microsoft Dynamics GP 2015 on Windows 10

Today I ran across a very interesting partner forum post, in which the consultant described a slow performance issue when closing (exiting) Microsoft Dynamics GP 2015, which started happenning after his client upgraded their Windows workstations to the newly minted Windows 10 operating system.

A Microsoft support engineer acknowledge that “there have been a few people experiencing this issue“. The recommendation to bypass the slow application closing is to change or add the following Dex.ini setting to see if it resolves the issue on exit. The setting changes a Microsoft Dynamics GP global variable and avoids the pause that seems to be occurring during the exiting process.

OLEClose=FALSE

This Dex.ini setting controls whether the Microsoft Dynamics GP application checks for the OLE Container application being opened at the time of shutdown — a “shutdown” can occur if the user legitimately exits Dynamics GP or simply chooses to open either the Report Writer or Modifier tools. If the Container is open during the shutdown operation, Dynamics GP will attempt a graceful closure of it.

The default value of this setting is TRUE, whether the setting is present in the Dex.ini with a value of true or empty, or simply not present at all. This indicates to GP that it should always attempt to close down the Container if it is found to be open.

Given the fact that most customers are now taking advantage of Document Attachment (Doc Attach) and moving away from the Container application, there should be less and less dependency on Container, which would almost require that the default value for our flag is set to FALSE, rather than it’s current state.

As usual, you must apply these changes to your environment only if you are experiencing this issue.

Until next post!

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

Excerpt from:
You experience slow performance exiting Microsoft Dynamics GP 2015 on Windows 10

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

GP2015 R2 Upgrade – “ASI_MSTR_Explorer_Favorites: Number of results columns doesn’t match table definition”

There were couple of exceptions related to GP2015 R2 that I wished to share here. One would be discussed here and other one on the next post.

After upgrading to GP2015 R2, while doing a routine testing, following error message was thrown while trying to open Smartlist:

Screen Shot 2015-07-31 at 6.53.32 PM

Full message as follows:

Unhandled database exception:
A get/change operation on table ‘ASI_MSTR_Explorer_Favorites’ failed accessing SQL data.

Number of results columns doesnt match table definition.

Number of results columns doesnt match table definition.

EXCEPTION_CLASS_DB
DB_ERR_SQL_DATA_ACCESS_ERR

Debugging this error took me to the table Smartlist Favorites Master (ASIEXP81). Strange, however, that number of columns indeed matched.

I remembered this issue happening in GP 10 and GP 2010. Suggested solutions were to run GRANT.SQL on all databases and changing ODBC provider to SQL Native Client. However, in my case, both were already done and confirmed.

To avoid any further delay or issue(s), I decided to backup the records from ASIEXP81, recreate the table using GP SQL Maintenance and push the records back from the backup table.

Resolution: Drop and create the table Smartlist Favorites Master (ASI_MSTR_Explorer_Favorites, ASIEXP81) using GP SQL Maintenance.

Only that, I did not have to reinsert the records. When I opened the Smartlist after recreating the table, it automatically populated all records. Strange, again. But it worked.

Word of caution: Always take backup before you do anything with the data.

VAIDY

Filed under: Uncategorized

More:
GP2015 R2 Upgrade – “ASI_MSTR_Explorer_Favorites: Number of results columns doesn’t match table definition”

August 2, 2015 · Vaidyanathan Mohan · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 55

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.

Vaidy

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: 59

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.

Vaidy

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

More:
GP 2015 R2 Upgrade Issues & Possible Solutions

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

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: 110

Microsoft Convergence Atlanta 2015 (#CONV15) – Day 2

Wow, Day 1 sure proved to be very exciting with all the big keynotes, general sessions, and presentations, not to mention the whole Expo reception. It also seemed like the night went by flying and sleeping was overrated. To add to the mix, Atlanta’s Tuesday morning traffic came back with a vengeance and did not really allow David and I to make it down on time for some early sessions we had planned to attend, oh well!

As a result, we ended up going to the Speakers’ Room to finalize our last bits of demo code for our upcoming session, only to discover we were not using “best practices” as noted by our Microsoft friend Rob Bernhardt. Since we are very keen to deliver best practices in our Service Based Architecture code (more on this on a separate post). This put us in a tailspin, so we went looking for Kevin Racer to offer some advise. We finally got what we were looking for, just 10 minutes before our session.

Off we went to look for our dual A313/314 room where we would host CS15G024-R1 Microsoft Dynamics GP 2015: Customizing the user interface. We walked into the room and saw a gentlemen sitting in the front row with a t-shirt that read “David Musgrave”, but couldn’t quite make out the entire text until he decided to unbutton his shirt. The results can be seen in the picture below.

David Musgrave and mastermind Steven Vallarian

Our session started with the traditional introductions from David and I and our work within the community and off we went into demos. We definitely tried to provide some humor to a dry subject. Development sessions tend to be that way, so I believe we only lost like 3 or 4 attendees out of the 131 who assisted. We also were able to demo the cool Service Based Architecture posting routine using Google Postman which is a Chrome application extension.

After our session, I went back to the Expo to catch up with a few folks. It’s always good when I can say hi to my buddy Brian Roney, who I consider to be one of the brightest Dexterity minds in the business.

Mariano Gomez and Brian Roney

Walking around for so many hours can definitely make anyone hungry, so David and I caught up and decided to move over to the Omni Hotel’s bar. After a few drinks (all on me, since David doesn’t drink), we decided to have a quiet dinner evening at the Omni Hotel’s Prime Meridian restaurant. After going through a good session of explaining MSG intolerance to the waiter, we were shortly joined on David’s request by Cindy Reeves and Tanya Markwit from Tribridge who were on their way to be seated for dinner as well. The view from our table couldn’t have been any better.

Ferris Wheel in the foreground, the Westin Atlanta in the background

After dinner in excellent company, we all jumped in my car and off we went to the Rock & Rave party, down at the Georgia Railroad Freight Depot. After a frustrating 40 minutes of trying to find this place, we made it (mind you, I’m a local)!

However, the night just got weirder and weirder from this point on as we were greeted by (gasp!) a zombie. My good friend Ora Goldman from Mekorma was manning the door in her costume, which I must say looked really awesome!

Ora Goldman (Mekorma) as a Zombie

Inside the place, music was pumping at an exaggerated loudness, rendering the place just one big noise hall. After a beer, it was simply time to leave.

Rock & Rave at the Georgia Railroad Freight Depot 

Again, on the way out, Craig, Ora, and Ora’s daughter were acting the part, so we decided to snap one more pic for the evening.

Craig Klapman and Ora Goldman playing a scare tactic on Ora’s daughter 

David and I got back in the car and drove to my place to get a bit of rest and recharge batteries for the next day – note I said “get a bit of rest”, as it was almost 1:00 AM when we got home.

Until next post!

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

Read More:
Microsoft Convergence Atlanta 2015 (#CONV15) – Day 2

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