Page 1 of 9312345678910...2025303540...Last »

Find All Custom SQL Objects In Database | azurecurve

CREATE VIEW uv_AZRCRV_GetCustomObjects AS /* Created by Ian Grieve of azurecurve|Ramblings of a Dynamics GP Consultant (http://www.azurecurve.co.uk) This code is licensed under the Creative Commons … MVP Profile azurecurve Publishing azurecurve on the Dynamics Community Email azurecurve View azurecurve View Detailed RSS Feed View Ian Grieve’s about.me View azurecurve’s Feed on Twitter View Ian Grieve’s profile on LinkedIn View …

Read More:
Find All Custom SQL Objects In Database | azurecurve

February 3, 2016 · Ian Grieve · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 9

Error Executing Script 'Before Integration' Line 17 … – azurecurve

MVP Profile · azurecurve Publishing · azurecurve on the Dynamics Community · Email azurecurve · View azurecurve · View Detailed RSS Feed · View Ian Grieve’s about.me · View azurecurve’s Feed on Twitter · View Ian …

View article:
Error Executing Script 'Before Integration' Line 17 … – azurecurve

December 24, 2015 · Ian Grieve · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 42

Navigation List Error: “Cannot insert the value NULL … – azurecurve

MVP Profile azurecurve Publishing azurecurve on the Dynamics Community Email azurecurve View azurecurve View Detailed RSS Feed View Ian Grieve’s about.me View azurecurve’s Feed on Twitter View Ian Grieve’s …

Read the article:
Navigation List Error: “Cannot insert the value NULL … – azurecurve

December 23, 2015 · Ian Grieve · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 25

Management Reporter Client Crash During Import of … – azurecurve

Fixing Base Period On Management Reporter Sample Company Reports … Social Media & Other Sites. MVP Profile azurecurve Publishing azurecurve on the Dynamics Community Email azurecurve View azurecurve View Detailed RSS Feed View Ian Grieve’s about.me View azurecurve’s Feed on Twitter View Ian Grieve’s profile on LinkedIn View azurecurve on facebook View azurecurve on Google+ azurecurve Development azurecurve WordPress Plugins …

See more here:
Management Reporter Client Crash During Import of … – azurecurve

November 27, 2015 · Ian Grieve · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 5

Management Reporter Error: An Error Occurred While … – azurecurve

Can’t Delete Company In Management Reporter · Management Reporter Error: … Social Media & Other Sites. MVP Profile azurecurve Publishing azurecurve on the Dynamics Community Email azurecurve View azurecurve View Detailed RSS Feed View Ian Grieve’s about.me View azurecurve’s Feed on Twitter View Ian Grieve’s profile on LinkedIn View azurecurve on facebook View azurecurve on Google+ azurecurve Development azurecurve WordPress Plugins …

Read More:
Management Reporter Error: An Error Occurred While … – azurecurve

November 23, 2015 · Ian Grieve · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 10

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!

MG.-
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: 96

Delete/Unassigned bulk items from Sites or Assign bulk Items to Sites

Few days before I was having client requirement to unassigned around 50K + items from specific sites. There were several help available on web one of is from MVP Mohood (http://mahmoudsaadi.blogspot.com/2013/11/delete-item-site-assignment.html) . I followed his sql query to delete all those items from sites.

But recently I found new feature in Dynamics GP 2013. From Navigation–>Click on Inventory –> Click Items. You have option to add filters base on your requirements.  Check mark items you want to unassigned from sites.  Click on Unassigned Site icon. Select Site and click Unassigned.























You have option to to add site with same screen.

Thanks much
Sandip Jadhav

Continue Reading:
Delete/Unassigned bulk items from Sites or Assign bulk Items to Sites

July 28, 2015 · Sandip Jadhav · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 104