Page 10 of 22« First...6789101112131415...Last »

My Son’s Wedding

I don’t typically post personal info on this blog, but I’m so proud of my son Brad and new daughter-in-law Susanne, I couldn’t resist.  They were married on Sunday, September 2nd, 2012.  Here’s the handsome couple . . .

Congratulations Brad and Susie!!

Visit site:
My Son’s Wedding

September 4, 2012 · Frank Hamelly MCP-GP MCT MVP · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 237

Warning! Install GP2010 SP 3 and lose your SmartList reminders!

If you do not want to run the risk of losing some of your SmartList reminders, then do not install SP 3. To my chagrin, I learned yesterday that there is a bug in SP3. In my world, that bug is a train wreck to many of my clients. Microsoft tech support acknowledged the existence of the bug and does not have any clue as to when it might be corrected.

Here’s what happens. Let’s say you create a SmartList object using SmartList Builder. Your users fashion favorites based on the created SmartList and then use those favorites in Reminders. After you install SP 3, the users with reminders based on objects built in SmartList Builder will not be able to log in to the system. That’s it, the system crashes, and crashes hard!

If you remove the reminders based on the SmartList Builder objects, your users will be able to log in just fine. So the “work around” is to delete the reminders. What! Yes, that’s the work around, you cannot use the feature. I don’t know how it affects you all, but that bit of news is a crushing blow in my world.

This problem has been a difficult one for Microsoft to isolate. They told me that they didn’t know if the problem was being caused by SQL code, Dexterity scripts, or the VSTools addins. All three are in play with SmartList Builder.

The error is easy to duplicate, and it fails just as the system begins to draw the home page window. If you are already logged in when you created the linked reminder, as soon as you refresh your home page you will get the error below, and GP will fail.

crashed

The next time you try to log in to GP, right after the navigation pane comes to your window, the system will crash. The partial screenshot below shows you what I mean.

error on big window

To identify the SmartList reminders you have at risk, you can query the DYNAMICS database. Type the statement below in the query window of Management Studio.

SELECT * FROM SY01404 WHERE DICTID = 3830

SmartList builder’s product ID is 3830.

This problem does NOT require you to disable SmartList Builder itself, you just cannot build any Reminders off of the SmartLists you create. You can:

  • Create and use Reminders that are not based on a Favorite belonging to an object created in SmartList Builder.
  • Create Favorites based on an object created in SmartList Builder.
  • Create and use Reminders based on a SmartList object that came with GP.

The bottom line is that you still have access to the custom Favorite, you just can’t create a reminder based on it.

While there are many ways to present the information that was captured by the Reminders, I haven’t been able to come up with an alternative that is as elegant and user-friendly as the SmartList Reminders.

I welcome anyone’s ideas on how to easily replace the SmartList Reminders until the time we get a fix from Microsoft.

Go forward with caution! Consider yourself warned.

Until next post!

Leslie Vail
Dallas, TX

Read this article:
Warning! Install GP2010 SP 3 and lose your SmartList reminders!

August 31, 2012 · Leslie Vail · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 435

GPTip42day – Taxable Inventory Items – SOP & POP

This is a topic that bears some reminding now and then.  When you set up an item in the Item Card to be Taxable for sales (or purchasing, for that matter), you must assign the ‘All Details’, or equivalent tax schedule to the item.  Not doing so will prevent sales tax from being calculated on the item on a sales or purchase order, even though all other tax-related settings are in place.

* Click on image to enlarge

Read more here:
GPTip42day – Taxable Inventory Items – SOP & POP

August 10, 2012 · Frank Hamelly MCP-GP MCT MVP · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 326

Mark Polino’s Dynamic Future – Vote – Multicurrency Cash Flow Forecast

If you work in a multi-currency environment, take a look at this suggestion Mark has made for multicurrency cash flow forecast . . .

Dynamic Future – Vote – Multicurrency Cash Flow Forecast

See more here:
Mark Polino’s Dynamic Future – Vote – Multicurrency Cash Flow Forecast

August 9, 2012 · Frank Hamelly MCP-GP MCT MVP · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 260

The ‘Microsoft.ACE.OLDB.12.0′ provider is not registered on the local machine

If you’ve ever experienced this error when trying to view the integration logs in Integration Manager, it’s because one of two shared components is missing on the workstation –
Resolution 1
Install the Report Viewer Redistributable using the link below:
www.microsoft.com/…/details.aspx
Resolution 2
Install the 2007 Office System Driver: Data Connectivity Components using the link below:
www.microsoft.com/…/details.aspx
Try one or both of these resolutions and it should fix the issue for you.  And yes, you need to install the 2007 Office System Driver even though you have Office 2010 installed on the workstation.  Integration Manager looks for the 2007 version.
Alternatively – and I like this solution better – in Integration settings, you can direct the log to save as a local text file instead of in the IM database.  IMHO, viewing the log as a text file makes it easier to analyze.

Original post:
The ‘Microsoft.ACE.OLDB.12.0′ provider is not registered on the local machine

July 12, 2012 · Frank Hamelly MCP-GP MCT MVP · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 791

Dynamic Future – Vote – Debits before Credits in SmartList!

Mark must stay up late at night remembering all these little annoyances that we all experience.  Here’s this week’s installment.  Vote early and vote often!

* click image to vote

Visit site:
Dynamic Future – Vote – Debits before Credits in SmartList!

May 30, 2012 · Frank Hamelly MCP-GP MCT MVP · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 278

Releasing Multiple POs Without Printing Them

I learn something new every day.  I had to release a couple dozen POs in a test environment today and thought there must be a better way to do this than print every one of them.  And there is – just go to Purchasing>>Transactions>>Edit Purchase Orders, select the PO you want to release, change the status to Released and that does it.  If you have multiple POs to release, just keep scrolling through them using the scroll buttons at the bottom of the window and select ‘Save Changes’ on each PO when prompted.

* click image to enlarge

See the article here:
Releasing Multiple POs Without Printing Them

May 24, 2012 · Frank Hamelly MCP-GP MCT MVP · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 309