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

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

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

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

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

CBM Cash Receipt Customer GL Posting Account Error

A user reported this issue when he tried to enter a cash receipt in CBM module. Following error message prevented him from continuing further.

Screen Shot 2015-02-23 at 3.10.24 PM

This error was confirmed to be happening only for one particular customer record. For all other customers, it worked.

We basically do not have posting accounts setup for each customer or customer class. So it is absolutely no way due to missing posting accounts. Several minutes later, decided to compare customer records between this particular customer and one other customer that’s working.

REASON: Customer Class ID for this customer record was wrong and was not part of the list of customer classes that we have setup on our company. Because this class ID was wrong, posting accounts validation stopped right there and threw a message that was totally irrelevant to actual reason.

RESOLUTION: I changed the customer class ID for this customer with an existing one. User could then enter a cash receipt in CBM.

Troubleshooting issues successfully is probably the best way to end a business day!

VAIDY

Filed under: #MSDYNGP, Cashbook, CBM, Troubleshooting

Continue reading here:
CBM Cash Receipt Customer GL Posting Account Error

February 23, 2015 · Vaidyanathan Mohan · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 120

SQL view for total payments to 1099 vendors in the prior year

We received several requests just yesterday for a listing of total vendor payments in the prior calendar year. Below is a view that will show the total payments in the prior year for all 1099 vendors. This is not necessarily meant to match the report that comes out from the Print 1099 window, rather this is total payments for […]

View article:
SQL view for total payments to 1099 vendors in the prior year

January 20, 2015 · Victoria Yudin · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 93

Microsoft Dynamics GP backups with Windows Azure Blob Storage Service – Follow up

As a follow up to my post yesterday (see Microsoft Dynamics GP backups with Windows Azure Blob Storage Service), an issue has been identified with Microsoft Dynamics GP 2015 running on SQL Server 2014 when choosing Microsoft Azure storage as the destination for the backup.

You will receive the following warning message:

The SQL Server version that you are using does not support backing up or restoring your database from Microsoft Azure storage.

I have traced the issue back to the logic in the ‘(L) RGRestoreBackupOption’ of window BackupRestore of form syBackupRestore field change script, which seems to compare the build number even after it has determined the version number is greater than SQL Server 2012 SP1 CU2 (11.0.3339). Of course, the build number for SQL Server 2014 CU4 is 12.0.2430. Since 2430 is not greater than 3339, the script sets the validation flag to false, causing the script to abort with the message indicated above.

This problem is exclusive to Microsoft Dynamics GP 2015 RTM (14.00.0524) running on SQL Server 2014, and cannot be replicated if you are running Microsoft Dynamics GP 2013 R2 or Microsoft Dynamics GP 2015 on SQL Server 2012 SP1 CU2 or greater. Microsoft is currently aware of this situation (at least via the Dynamics GP Online Partner Technical Community Forum), but if you are

For more information on SQL Server 2014 build numbers, see Microsoft Support kb article 2936603, SQL Server 2014 build versions.

Until next post!

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

View article:
Microsoft Dynamics GP backups with Windows Azure Blob Storage Service – Follow up

December 15, 2014 · Mariano Gomez · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 119