Writing on the MBS Guru site, Bryan Prince covers ActiveX component can't create object run-time error 429
You, Me and Dynamics GP
The premier information site for Microsoft Dynamics GP
29 December 2011
Convergence 2012 tips
Manick Vell delivers some Convergence 2012 tips. For some fun, my Space Alien’s Guide to Microsoft Convergence is still relevant too.
Weekly Review: Printing SmartLists
Sometimes you've created a SmartList and you just want to print it out. Maybe the auditors need it. Maybe your boss, coworker or the filing cabinet behind your desk needs a copy. But when you click the print icon the output is pretty ugly. Typically, too many items are forced to the next line making the printout overly long and complex or some items are squished and don't print out right. How do you fix a SmartLlist printout?
This is so easy it's scary. SmartList follows the width of the columns on the screen. It's not perfect, but it's close. If a column is only partially visible on the screen, it will typically be partially visible on the printout. If a column has a huge space after the date it can cause the next column to move down to the next line. Fortunately these reports can be printed to screen first to ensure that things will look the way you want.
This SmartList:
Produces this report:
Notice that the huge space after the account number forces items to the next line and Account Description is cut off.
Originally Posted by Mark Polino at 1/25/2010 09:00:00 AM
28 December 2011
How To Create A Domain Controller | azurecurve
As GP get deeper into the Microsoft stack with more ties to IIS, Sharepoint, and the SQL Server components things like How To Create A Domain Controller become more important. Azurecurve has a the info.
![W-2 File creation error_thumb[1][1]](http://lh5.ggpht.com/-Iq4zo-KzaV0/TvsmQsRreJI/AAAAAAAABMI/yJEwjhu83UI/s1600-h/W-2%252520File%252520creation%252520error_thumb%25255B1%25255D%25255B1%25255D%25255B3%25255D.png "W-2 File creation error_thumb[1][1]")
Mohammad R. Daoud: An Error while importing Analytical Accounting Budget
Budget imports have been a hot topic lately with lots of people searching for help. Mohammad Daoud digs into An Error while importing Analytical Accounting Budget and provides a solution.
Dynamics Confessor Blogspot: Beware the 2012 Tax Tables!
Leslie Vail tells us about a problem with the 2012 tax tables in Beware the 2012 Tax Tables!. Checkout her post for details.
Optimizing and Maintaining Performance for Microsoft Dynamics GP® 2010 - Inside Microsoft Dynamics GP
Brand new from the Support and Services team is Optimizing and Maintaining Performance for Microsoft Dynamics GP® 2010 . I grabbed my copy yesterday and I’m looking forward to reading it before the new year.
Getting Started with Social Media - Microsoft Dynamics Convergence
Writing on the Dynamics Community site, Joe Wiley looks at Getting Started with Social Media - Microsoft Dynamics Convergence.
Joe highlights ways in which partners can use Social Media to get more from Convergence. Of course, Jon Rivers and I would also recommend the eBook Social Media for Microsoft Dynamics Partners.
Sure we’re biased but then we’re always biased toward things that work.
New Challenges and Opportunities for 2012
It’s time for a new challenge so I’m making a change. Starting in January I’m moving out of direct consulting with Dynamics GP.
My new challenge is to help build a Corporate Performance Management (CPM) practice at I.B.I.S. CPM generally involves financial reporting, budgeting, forecasting and planning. There is some overlap with Business Intelligence on the financial side but generally not operationally. We are looking to deliver CPM cross product so I’ll get to do some work with AX and CRM as well as with GP.
This is an area where I have some significant experience. In addition to typical budget work, some of you know that a good chunk of the time that I spent as a CFO was directly involved with trying to sell our division. It’s really hard to imagine how many budget and forecast scenarios you can come up with in 8 months when the options include explosive expansion and severe contraction. I’ve also been involved in the CPM software selection process several times with a mix of products.
Right now Microsoft’s CPM strategy is less than complete, especially for larger enterprises. We like what deFacto is delivering in terms of CPM,and we like the way they partner. Expect to hear more about that as time goes on.
So what does this mean for the blog? Probably not much. I know that I tend to write about what I’m thinking about, it just doesn’t always get published when I’m thinking about it. Sometimes there are delays to protect everyone. You can probably expect to see a few more original pieces on CPM.
I’m already deep into a brand new 50 Tips presentation so that will get done in 2012 and speaking is set for Convergence in Houston. I’ve also got a pile of GP related projects in the hopper for the next 3 months. It’s going to be a challenge to get everything done but frankly, I need a new challenge and I’m looking forward to this one.
27 December 2011
Initiating an employee FMLA leave (User Snippet) - Accidental Administrator
John Lowther is back with an Accidental Administrator post on Initiating an employee FMLA leave (User Snippet)
Mohammad R. Daoud: eConnect POP Integration: Invalid Object Name PA10601
Mohammad Daoud tackle a problem with eConnect POP Integration: Invalid Object Name PA10601
Dynamics GP Land: Management Reporter Size Limitation
Christina Phillips runs into some Management Reporter Size Limitation over at Dynamics GP Land.
The eOne Dynamics GP and CRM Blog: Troubleshooting SmartConnect Data Issues
Alex Sugak from eOne provide help Troubleshooting SmartConnect Data Issues.
Importing GP Account Segment Descriptions
Sheldon from Etelligent Solutions looks at Importing GP Account Segment Descriptions.
Off Topic–eBook Prices
Completely off topic, if you are interested in eBooks and eReaders check out my comparison of eBook costs.
Weekly Dynamic: PayPal Email
We’ve looked at some PayPal stuff before but I wanted to add something else. Typically when paying via PayPal there is one email for making the payment. The vendor may have multiple emails for various contacts. One way to ensure that the right email is being used for PayPal payments is to dedicate an Internet User Defined Field to PayPal. This avoids any confusion.
To set this up:
- Open the Company Setup Menu in the Administration Area Page | Company | Internet User Defined.
- Change the appropriate User Defined Field to Pay Pal and Click Ok
Now PayPal is available on the Internet Information window.
25 December 2011
Merry Christmas!
Merry Christmas from DynamicAccounting.net.
It’s going to be in the low 80’s here in Orlando today. Since Mariano saw fit to finish with a traditional Christmas song I decided to leave you with something with less tradition and more Florida.
22 December 2011
Canadian Payroll Year End 2011 Update - Blog - Kuntz Consulting
The Canadian Payroll Year End 2011 Update has been released according to Kuntz Consulting.
Mohammad R. Daoud: Dynamics GP Extended Pricing Error
Mohammad tackles a Dynamics GP Extended Pricing Error in his latest post
Microsoft Dynamics GP 2010 R2 64-bit Hyper-V Released! - Inside Microsoft Dynamics GP
From Microsoft comes news that the Microsoft Dynamics GP 2010 R2 64-bit Hyper-V has been Released!
This is really more relevant to partners than to end users but it’s still nice to see.
21 December 2011
Stairway to PowerPivot and DAX - Level 1: Getting Started with PowerPivot and DAX - SQLServerCentral
SQL Server Central shows us the Stairway to PowerPivot and DAX - Level 1: Getting Started with PowerPivot and DAX
I’m a huge fan of PowerPivot for data analysis.
Frequently Asked Questions about the 'Reconcile to GL' Routine in Microsoft Dynamics GP - Dynamics GP Support and Services Blog
Cheryl W. from Microsoft tackles Frequently Asked Questions about the 'Reconcile to GL' Routine in Microsoft Dynamics GP
I’ve had mixed success with Reconcile to GL but I have to tell you that, for me, this quote from the article:
This Reconcile to GL spreadsheet was not intended to be matched to the HATB. It was intended to be an aid to help match distributions to distributions to assist in finding differences that may occur between the GL Trial Balance and RM/PM HATB.
is one of the reasons that I prefer The Closer from Reporting-Central for reconciling subledgers and the GL.
7 Dynamics GP Resolutions for GP 2012 - Mad Mark, the GP Road Warrior
I’ve got 7 Dynamics GP Resolutions for GP 2012 up for you now on my Mad Mark column on the Dynamics Community site.
20 December 2011
I.B.I.S., Inc. Announces Domain Change to www.ibisinc.com
I.B.I.S. is changing our domain name back to www.ibisinc.com.
This means that my email now becomes mpolino at ibisinc.com. I’ve got back and adjusted all of the links at DynamicAccounting.net. That’s how I found out that I have almost 15,000 links on this site.
Why are we going back to www.ibisinc.com? Simple, someone paid a boatload of money for the ibis.com domain. What does this prove? It proves that Andy’s is shrewd enough to know when he’s got an offer that he’ll never see again.
If you would like to offer me a boatload of money for DynamicAccounting.net…I’m listening.
19 December 2011
Dynamics GP Land: Helpful Microsoft Forecaster Scripts
Christina Phillips delivers some Helpful Microsoft Forecaster Scripts
Dynamics Confessor Blogspot: Internal Error 2738
Leslie Vail tackles an install issue with a missing vbscript.dll file and Internal Error 2738.
![[image%255B6%255D.png]](http://lh6.ggpht.com/-Ws7SAFDMwQE/TulHlwAJnJI/AAAAAAAAARs/O5MBDpPJACQ/s1600/image%25255B6%25255D.png)
Did you Know? - Using Adjustments in Microsoft Forecaster - Dynamics Corporate Performance Management
From Dynamics Corporate Performance Management, Ryan Sandness covers Using Adjustments in Microsoft Forecaster
Enrolling Employees in Health Insurance (User Snippet) - Accidental Administrator
John Lowther covers Enrolling Employees in Health Insurance (User Snippet) in his new Accidental Administrator column.
Weekly Dynamic: Project Accounting Access List
Project Accounting provides an option to control access to projects using the Access List on the Project Maintenance Card.
Most of the consultants I know who use Project Accounting aren’t fans of controlling access to projects this way because it’s a maintenance nightmare. I did however want to cover one aspect of this.
Rather than adding access one user at a time, select the Icon next to the Project Number on the Employee Access List to open a wizard to allow adding employees in bulk, like from a class.
The problem with the wizard is that it only adds the employees to the list. It doesn’t add the class so adding and subtracting employees to the class later doesn’t change the access list. Also, you can’t tell that employees were added from a class if you are trying to maintain the list based on classes.
16 December 2011
15 December 2011
Standardize SQL Server backups and maintain existing job schedules
In a great tip for accidental administrators, MSSQLTips shows how to Standardize SQL Server backups and maintain existing job schedules
Weekly Review:Scrolling when reports are Printed to Screen
So you're working along in Dynamics GP and you print a report to screen. You scroll the wheel on your mouse to move to page 2 on the screen and nothing happens. So hit the Page Down key. Nada, nothing, nope. The page doesn't move down. Yes you can scroll down with the scroll bar but that's not efficient.
So what's going on here? It a bug, plain and simple and there's a plain and simple workaround. Click on the zoom button, the one shows the percentage size, then highlight a line on the report. Now the scroll wheel and page down button will work fine. This is supposed to be fixed in GP 2010.
[H.T. to Mohammad Daoud who solved this for a user on the newsgroup]
Originally Posted by Mark Polino at 1/18/2010 09:00:00 AM
14 December 2011
Financial Year End Closing – Only Open Year Error Message | azurecurve
Ian Grieve reminds us that you have to have another year open to close the current year in Financial Year End Closing – Only Open Year Error Message
Microsoft Dynamics GP Year End Release 2011 - General Ledger Year End Close - Dynamics GP Support and Services Blog
Wrapping up their year end process posts, the GP team shares Microsoft Dynamics GP Year End Release 2011 - General Ledger Year End Close
Understanding the Value of Social Media for the Dynamics Ecosystem
Brandon George, a social media giant in the Dynamics AX world also likes our “Social Media for Microsoft Dynamics Partners” eBook. He reviews it at Dynamics AX: Understanding the Value of Social Media for the Dynamics Ecosystem.
Thanks Brandon!
Microsoft Dynamics GP Hyper-V Image Set - Inside Microsoft Dynamics GP
Jay Manley updates partners on the status of the Microsoft Dynamics GP Hyper-V Image Set
I’m looking forward to playing with it.
13 December 2011
Available Now: Decisions Fall 2011 On Demand | MSDynamicsWorld.com
If you missed last weeks great virtual sessions they are Available Now: Decisions Fall 2011 On Demand
Convergence 2012 Partner Only Event, March 17 – Save the Date! - Microsoft Dynamics Partner Community Blog
Kevin Machayya reminds us to save the date for a Convergence 2012 Partner Only Event, March 17.
I’ll be there but then you probably expected that.
Integration Manager Error – MSScriptControl | azurecurve
Ian Grieve works through another Integration Manager Error this time with MSScriptControl
The eOne Dynamics GP and CRM Blog: GP resellers. Stand and make Revenue.
Martin from eOne encourages GP resellers to Stand and make Revenue. He’s right of course. No one likes a whiner and there’s a lot of whining going on the channel right now.
Mohammad R. Daoud: Kill All Connections to an SQL Server Database
Mohamad Daoud shows how to Kill All Connections to an SQL Server Database for maintenance.
Dynamics GP Year End Close Resources - Etelligent Solutions
Sheldon from Etelligent Solutions has collected a number of great resources on Year End Close for Dynamics GP.
He’s also a fan of MyGPSearch.com and just a really nice guy.
Navigating Dynamics GP Data Using Navigation Lists | Dynamics GP Insights
Fellow MVP Charles Allen highlights Navigating Dynamics GP Data Using Navigation Lists
DynamicAccounting.net on the iPhone
I’ve been wresting with whether or not the developer fees and pain is worth creating an iPhone app for DynamicAccounting.net. Then I was blown away by the recently released Flipboard for the iPhone and how well DynamicAccounting.net looks on it. I’m assuming that this works on Flipboard for Android as well
To add DynamicAccounting.net to Flipboard for the iPhone
- Click a tile marked “More”
- In “Search for Anything” enter DynamicAccounting.net
- Pick DynamicAccounting.net under the RSS heading.
Now you can view all the coolness of DynamicAccounting.net on your iPhone, iPad or Android device with Flipboard.
12 December 2011
Dynamics Confessor Blogspot: W-2 Issues with Deceased Employees
Leslie Vail tackles a tough subject, W-2 Issues with Deceased Employees.
Problem With SOP Word Templates | azurecurve
Ian Grieve has run into a Problem With SOP Word Templates
New Social Media Book for Dynamics Partners - Microsoft Dynamics Community Team Blog
The Dynamics Community team recently interviewed Jon Rivers and I about our New Social Media Book for Dynamics Partners. The interview is up now and the ebook is available in PDF or Kindle format for $10.
You wouldn’t have any respect for us if we gave it away for free.
Convincing Your Boss You Should Go to Convergence - Microsoft Dynamics Convergence
Alexa Hoekstra offer suggestions for Convincing Your Boss You Should Go to Convergence.
For a fun look at Microsoft Convergence check out my Space Alien’s Guide to Microsoft Convergence in PDF or Kindle format.
I’m thinking about something new for this year.
Microsoft Dynamics GP User Group Elects New Advisory Board Members - GPUG Events & News
GPUG added New Advisory Board Members congrats to everyone and I’m sure you’ll continue the upward trajectory of GPUG.
Convergence Opening Keynote Speakers Announced! - Microsoft Dynamics Convergence
Check out the Convergence opening keynote speakers at Convergence Opening Keynote Speakers Announced!
Sadly I didn’t make the list this year but these are good second choices.
Word Template Generator, Where Art Thou? | azurecurve
Word Template Generator, Where Art Thou? asks Ian Grieve. He found it eventually an made it easier for you to find.
Automate SQL Server Monitoring with Email Alerts
MSSQLTips shows how to Automate SQL Server Monitoring with Email Alerts. We’ve talked before about monitoring things like the the size of TempDB, backups and transaction logs. Now MSSQLTips provides some options for doing just that.
Weekly Dynamic: Error message when you install Microsoft Management Reporter Server: “An error occurred while creating the database”
Courtesy of Rob Mitchell who wrestled with this Error message when you install Microsoft Management Reporter Server: “An error occurred while creating the database”
Oddly the solution for this is that:
You must install SQL Compact Edition SP2 for Windows Desktop on the computer that you are running the Management Reporter Server installation from. You can download the SQL Compact Edition SP2 for Windows Desktop from the following link:
You must install both the x86 and x64 version if you are using an x64 operating system.
Not intuitive at all. On the plus side this does come up near the top of the results on MyGPSearch.com when searching this error. It’s KB 2406948.
09 December 2011
![144933.strip.print[1]](http://lh6.ggpht.com/-WB9y8V1_zg4/TuEJPaZPU3I/AAAAAAAABJU/tj1pxUUIUe8/s1600-h/144933.strip.print%25255B1%25255D%25255B3%25255D.gif "144933.strip.print[1]")
08 December 2011
Integration Manager Error – ADO Field Is Nothing | azurecurve
azurecurve digs into Integration Manager Error – ADO Field Is Nothing essentially this error is normally telling you that the data source is not available. You entered it wrong, moved the source, don’t have access to that source, goofed the setup or have it open.
Dynamics Confessor Blogspot: Demystify Monthly Maintenance Routines Transcript
Leslie Vail has a transcript of questions from her Demystify Monthly Maintenance Routines presentation at Decisions Fall 2011.
The Consultant Identity: Can Your Microsoft Dynamics GP Pro Deliver? | MSDynamicsWorld.com
My new article on The Consultant Identity: Can Your Microsoft Dynamics GP Pro Deliver? is up now at MSDynamicsWorld.com.
I’m a consultant so I pick on consultants. What do you expect?
Weekly Review: SQL Script to Monitor Transaction Log Backups
We see a surprising number of huge transaction logs in clients who should know better. This commonly happens when transaction logs are not being backed up regularly and the database is running in Full recovery mode. If the log grows large enough, SQL Server can stop working leading to a lot of excitement.
Typically, this solved with a properly setup maintenance plan in SQL Server but what if that's not the case? What if the maintenance plan is failing and not providing notifications? Short of regularly monitoring transaction log growth, how can a DBA ensure that logs are being properly truncated?
Thanks to the MSSQLTips site, we've now got this SQL Script designed to show any databases in Full or Bulk-Logged recovery model that have had a full backup without any subsequent transaction log backups.
SELECT
D.[name] AS [database_name], D.[recovery_model_desc]
FROM
sys.databases D LEFT JOIN
(
SELECT BS.[database_name],
MAX(BS.[backup_finish_date]) AS [last_log_backup_date]
FROM msdb.dbo.backupset BS
WHERE BS.type = 'L'
GROUP BY BS.[database_name]
) BS1
ON D.[name] = BS1.[database_name]
LEFT JOIN
(
SELECT BS.[database_name],
MAX(BS.[backup_finish_date]) AS [last_data_backup_date]
FROM msdb.dbo.backupset BS
WHERE BS.type = 'D'
GROUP BY BS.[database_name]
) BS2
ON D.[name] = BS2.[database_name]
WHERE
D.[recovery_model_desc] <> 'SIMPLE'
AND BS1.[last_log_backup_date] IS NULL OR BS1.[last_log_backup_date] < BS2.[last_data_backup_date]
ORDER BY D.[name];More information on this script and similar scripts is available from MSSQLTips.com
Originally Posted by Mark at 1/11/2010 09:00:00 AM
07 December 2011
The Dynamics GP Blogster: The Dynamics GP Blogster's YouTube Channel launches with Decisions Fall 2011
Mariano is launching The Dynamics GP Blogster's YouTube Channel with Decisions Fall 2011
Find out more about the Support Debugging Tool from Mariano’s videos.
Microsoft Dynamics GP Year End Release 2011 – Analytical Accounting Year End Close - Dynamics GP Support and Services Blog
The Microsoft Support and Services blog continues their look at year end with Analytical Accounting Year End Close
How to Lose Your LIFO Preserver
CFO.com looks at the impact of the loss of LIFO inventory valuation with IFRS. Fortunately Dynamics GP maintains the cost layers throughout so it’s possible to switch from LIFO to something else.
06 December 2011
Hidden total cost of public cloud ownership–CFO.com
One of the interesting things I learned at last year’s GPUG Summit (2010) was that a number of people were looking at cloud deployments because they were unhappy with IT an wanted them out of the mix.
Well, the cloud is all the rage and it certainly has some areas where it’s a great fit. CFO’s have to deal with additional considerations when deciding whether moving to the cloud is the right answer. Currently CFO.com has a look at the Hidden total cost of public cloud ownership.
It’s worth a read to make sure that you are taking a 360 degree look at your business when considering ANY solution.
The eOne Dynamics GP and CRM Blog: Tech Tuesday is back and not just on Tuesdays.
The beauty of Martin being in Australia is that he claim that it’s any day he wants it to be and we’ll probably believe him. Despite posting this on Monday, Tech Tuesday is back and not just on Tuesdays at eone.
Missing Font Causes Crash In Management Reporter | azurecurve
Ian Grieve figures out the hard way that a Missing Font Causes Crash In Management Reporter
05 December 2011
Microsoft Dynamics GP Year End Release 2011 – Fixed Assets Year End Close - Dynamics GP Support and Services Blog
Microsoft ads to their year end support series with details on the Fixed Assets Year End Close
Dynamics GP Land: GP Developer Tip: List All Parameters for a SQL Server Stored Procedure
Over at Dynamics GP Land, Steve Endow shows how to List All Parameters for a SQL Server Stored Procedure
Microsoft Dynamics GP Year End Release 2011 – Payables Management Year End Close - Dynamics GP Support and Services Blog
Microsoft Continues their Year End series with a look at Payables Management Year End Close - Dynamics GP Support and Services Blog
The Dynamics GP Blogster: Resetting GP desktop position and size with the Support Debugging Tool
Mariano demonstrates Resetting GP desktop position and size with the Support Debugging Tool
Make sure to catch his session on the Support Debugging Tool at Decisions Fall 2011.
Make sure to catch his session on the Support Debugging Tool at Decisions Fall 2011.
Subscribe to:
Posts (Atom)