Put away the Defibrillator, “Dynamics Live” is Just Fine

Three years ago I took a whack the Dynamics Live site, dubbed “My Space for Financial Professionals” by the press, and concluded that it was on life support. What a difference three years makes. Now My Space is on life support, Dynamics Live is now the Dynamics Community and it appears to be thriving. I take a full look at how Dynamics Live managed to survive, recover and now thrive in my new article up at MSDynamicsWorld.

Fixed Assets “History” Report

Omar takes a shot at SQL code to try to replicate some Fixed Assets History data. The problem is that Fixed Assets doesn’t really keep complete history so getting all of the information is problematic.

Weekly Review: Comments without a Comment ID

In many GP transactional screens you can input a comment. The comment functionality was intended to be used for repeating comments (things like "Remember to send your invoice to our new address", "Thanks for your business", etc.). Consequently comments have a comment ID to reduce keying and allow for consistent verbiage. It's easier to key or default "Thank1" than "Thanks for your business".

Since comments print on most default documents, their use often evolves into one time customer comment use, in place of consistent repeating comments. Things like ("Red gromets shipped in place of black gromets"). However, if you create a comment ID for each comment ever made on an invoice, order or P.O. you're soon drowning in comment id's.

Well in case you missed this functionality, you can skip the comment ID altogether. Simply click the blue arrow next to a blank comment id. Create a comment without ever entering an ID and you've got a nice way to provide one-time communication to your customers or vendors. These comments print just fine on orders, invoices, P.O.'s, etc.

This also allows easy separation of external facing notes (the comment) and internal facing notes (the note field). Also, since comments are already sent to print on default documents you don't have a bunch of modifications to do. No linking tables to add the notes field to a report.
So there you have it, "Thank you and have a nice day!".

Originally Posted by Mark at 7/08/2008 09:13:00 AM

New DynamicAccounting.net Newsletter

The September DynamicAccounting.net newsletter just made it under the wire going out to subscribers yesterday. If you’re not subscribed you can sign up on the DynamicAccounting.net home page. If you missed the September issue it’s available on the web.

 

Dynamics GP Dynamics Database and Company Information.

Christina Phillips is back with a look at the importance of the Dynamics Database in Dynamics GP.

50 Tips for Dynamics GP update, the Trilogy

Well, it took 5 months, but more people have downloaded the two sets of 50 tips from Convergence 2010 than saw it live. The newest set of 50 tips is ready for the GPUG Summit in Orlando and will complete the 50 tips trilogy. It would be useful to review the first two sets so that you can see that there are no overlaps when you see the new set. That and the chances are slim that you’ve put the first 100 tips into practice so it’s worth reviewing them again.

If you want to review the original two sets of 50 tips you can grab them on the right side of the DynamicAccounting.net home page. Additionally, the Microsoft Dynamics GP 2010 Cookbook is really an extension of these tips with all of the details fleshed out, step by step instructions and additional information and options.

Partner Connections

It's not enough for a teacher to be one day ahead of their students. (Though I've done it!) It's also not enough for partners to be one day ahead of their clients. With blogs, Twitter, Facebook and video clients are learning faster than ever. Partners need to update their skills as well. A great place to do that is at Partner Connections in Orlando, a couple of days before the GPUG Summit and yes, I get the irony of that. I'll be presenting as will many other terrific folks in the channel. Check out Andy's video for more.

Export and Import Integration Manager Integrations – Dynamics GP

Mohammad Daoud shows us how to Export and Import Integration Manager Integrations in Dynamics GP.

Microsoft Dynamics ERP Licensing Changes

David Musgrave takes a look at Microsoft Dynamics ERP Licensing Changes.  I’m going to say that on a personal level, there are elements of the new licensing that I find to be a naked cash grab by MS. Customers screamed about the DCO licenses and rather than deal with customer anger, MS renamed them to make them sound more appealing. Accessing GP data with other tools should be covered by other licenses, the SQL CAL, the Office CAL, etc.There is no good reason to allow access other data in the same location with these licenses but not cover Dynamics data. Companies have already paid for access to this data, there is no reason for them to have to pay again.

Debugging Microsoft Dynamics GP 2010 Word Templates

On the heels of his look at Word Templates, Mariano also looks at Debugging Microsoft Dynamics GP 2010 Word Templates. Somehow I think that one post led to the other but that’s just me.

How to add a "Terms and Conditions" page to a Microsoft Dynamics GP Word Template document

Mariano digs deeper into the Word Templates for Dynamics GP with a look at How to add a "Terms and Conditions" page to a Microsoft Dynamics GP Word Template document.

The Clock is ticking for Dynamics GP version 9

In Touch with Dynamics (GP) reminds us that The Clock is ticking for Dynamics GP version 9. Support for GP 9 ends January 11, 2010. A number of folks are going to get caught by this because they’ve been waiting for GP 2010 SP1 and things like the Spanish language pack  to upgrade. The timing of the SP 1 release that a number of folks are really going to get squeezed against year. end.

Microsoft Dynamics Partner Gut Check: Upcoming Certification Changes Realign VAR Ecosystem

MSDynamicsWorld has a great article up looking at  how Upcoming Certification Changes will Realign VAR Ecosystem. Resellers of Dynamics GP have a number of changes coming to the way they will interact with Microsoft and the article does a great job of parsing how these changes will affect large and small resellers.

SQL Server Express Failing To Start Revisited

Patrick Roth takes another look at a scenario where SQL Server Express is Failing To Start when using NTFS file compression.

Dynamics GP Copy Company Tool

Omar has a nice look at the Dynamics GP Copy Company Tool used to copy master records and setup files from one company to another in Dynamics GP.

Upcoming Dynamics GP Presentations

I’ve updated my speaking page with the next round of presentations. iSight is over and was a big hit based on in person and Twitter feedback, we’ll parse the survey results next week. I’ve still got seven (7) speaking engagements to go between now and November 2 so there are lots of opportunities to learn more about Dynamics GP before the holidays.

The Dynamics GP Blogster changes its motto

Mariano is making some improvements to his site. He details the improvements in his post The Dynamics GP Blogster changes its motto. I keep making improvements to DynamicAccounting.net so if you haven’t actually visited the site in a while now is a great time to do it. I’m keeping my motto for now. The site is still about you, me and Dynamics GP.

Dynamics GP Visual Studio Tools AddIns Won't Load

Steve Endow keeps troubleshooting with a look at why Dynamics GP Visual Studio Tools AddIns Won't Load.

7 Sure Steps to pass the Sure Step exam

Vjekoslav Babic does a great job giving us 7 Sure Steps to pass the Sure Step exam

SQL view for Payables apply detail and GL distributions in Dynamics GP

Victoria Yudin gives us a new SQL view for Payables apply detail and GL distributions in Dynamics GP

Archiving Integration Source Data for Dynamics GP

Over at Dynamics GP Land, Steve Endow looks at Archiving Integration Source Data.

Dynamics GP 2010 Service Pack 1...Hot off the press!

I was presenting at iSight when the news came through so if you’ve missed it, Service Pack 1 is now available for Microsoft Dynamics GP 2010. Crank up the upgrade machine.

Weekly Dynamic: Fast Access to Integrations in Dynamics GP

A common scenario with integrations is that some users only run them on a periodic basis and it’s tough for these user to remember how to access Integration Manager. Conversely there may also be a set of employees who regularly run integrations and would like fast access to IM.
A simple solution for both scenarios is to add IM to either the Shortcut Bar or the Menu Bar. On the Shortcut bar, add an external file and find IMRUN.exe to add the ability to run integrations. On the menu bar, right click to customize and Run Integrations… from the Dynamics GP | Tools tree.

New Theme: The Dynamics GP Engine

After presenting all the great new features in Dynamics GP at iSight last week it was very clear that the Dynamics GP engine is chugging along nicely so that’s the theme for this week.

Weekly Review: IM Tip, Key a Transaction

I was wrestling with a SOP integration recently. I had to use the old style adapter for Integration Manager because some fields I needed are missing in the econnect adapter. The integration would start, process a few records and fail, crashing IM and not writing to any logs.


This is a an effective way to learn new expletives.

To complicate things, the source was a really complex SQL query from a non-GP database. Also, the integration wasn't failing on the same record each time. Records that failed one time would integrate the next and the process would fail on another record. (aside: son of a motherless goat is good expletive to use here. Extra points if you can name the movie it's from)

I was ready to drop everything to a CSV and test it that way but that would have been time consuming and not fun.

My colleague who keeps claiming that she's "non-technical" but who keeps solving my technical problems sat down and we walked through keying an entry. The problem was subtle but we found it.

I was forcing the Ship To information into the integration (not necessarily using a ship to address id) because I wanted to make sure that the ship to data was right even if the address wasn't setup for that customer. But I had Ship To Address set to default. The problem was that Ship to Address wasn't defaulting so there was no ship to information to change when I forcing in data.

I've found lots of Integration Manager issues by keying integration transactions in the past but usually they stand out. This one was more subtle so even though I've given this advice before and thought I had done it here, I'll say it again. If you are having IM trouble, key one transaction from the integration. Key every step. Don't skimp. Don't say "oh, I know how that works". Key it. Do it now!

Originally Posted by Mark at 6/25/2008 08:10:00 AM

Accounting Technology Names I.B.I.S., Inc. Among VAR 100

In cased you missed it, I.B.I.S. came in at number 20 on Accounting Technology’s VAR 100 list for 2010. From me to you, thank you again for giving us the opportunity to serve you.

Extender Window Groups in Dynamics GP

Over at eOne, Martin walks us through how to use Window Groups in Extender to open Extender windows based on certain criteria.

Changing SOP Tax Rates using the Support Debugging Tool in Dynamics GP

David Musgrave provides scripts for Changing SOP Tax Rates using the Support Debugging Tool using upcoming changes to New Zealand’s tax rates.

I.B.I.S. 2010 Client Satisfaction

In a remarkably transparent post, Dwight Specht shows off our 2010 Client Satisfaction. survey results. Along with Dwight, I would like to say a big thank you to all of our clients. If you are going to iSight I’ll have the opportunity to say that to you in person.

Dealing with UK VAT changes coming in 2011 with Dynamics GP

In Touch with Dynamics (GP) has a look at VAT changes coming to the UK and how to deal with them in Dynamics GP. The article up at All Change on 20% Tax Again January 2011.

The Agile Sure Step Project Type: New Options for Implementing Microsoft Dynamics

Vjekoslav Babic looks a the new Agile Sure Step Project Type when implementing a Microsoft Dynamics solution in a new MSDynamicsWorld article. I know that this is a subject near and dear to him so it’s nice to see that Sure Step is progressing toward an agile option even if it’s not quite all the way there yet.

Mass emailing customer documents with Microsoft Dynamics GP 2010

Mariano Gomez covers Mass emailing customer documents with Microsoft Dynamics GP 2010 in his latest post.

Using the Miscellaneous field on SOP transactions to recapture Credit Card fees in Dynamics GP

Frank Hamelly provide a solution to a scenario where credit card fees need to be billed back to a customer. See how he did it Using the Miscellaneous field on SOP transactions to recapture Credit Card fees.

SQL Server Transaction Log Grows And Fills Up Drive

It is not all that uncommon to see the SQL Server Transaction Log Grow And Fill Up the Hard Drive. The problem is that the timing is never convenient. To help with that MSSQLTips looks at how to solve this problem in the short term and then diagnose the root cause.

Beyond Go Live with Dynamics GP

Go live is over. First month close is done. Too many companies and users take a deep breath here and never move deeper into the system. They keep repeating the same processes without growth and without finding out how to get more out of Dynamics GP. This applies to upgrades as well. Firms upgrade to a new version of Dynamics GP and don’t explore all of the great new features of that version.

It’s time to move beyond go live with the Microsoft Dynamics GP 2010 Cookbook. The Microsoft Dynamics GP 2010 Cookbook provides real world solutions to make users more effective when using Microsoft Dynamics GP. Many of the recipes are applicable to versions earlier than GP 2010 so users can’t start being more effective before they upgrade.

Go beyond go live now with the Microsoft Dynamics GP 2010 Cookbook.

 

Excel Team Favorite Keyboard Shortcuts

For those of you analyzing data from Dynamics GP in Excel, the Excel Team has compiled a giant list of Excel keyboard shortcuts…and this is only part 1 of 3! Get the list at Excel Team Favorite Keyboard Shortcuts – Part 1 of 3.

Is The New PartnerSource Search a Complete Dud?

Steve Endow is now a fan of the new PartnerSource search and lets us know that in his post Is The New PartnerSource Search a Complete Dud?

In the past I’ve publicly offered to help grab someone from the Bing team or rival Google and tie them to chair until search is fixed in PartnerSource. I’ve talked to members of the team, nicely and …um… we’ll leave it at that. It gets better for a while and then it gets worse. Site search improves and Knowledge Based search gets worse. I have no answers.

I guess they could put a pretty background in back (a la Bing) so we’ll all feel better when we don’t get the results we want.

eConnect Requester and eConnect_Out problem prevents entry of Purchase Orders in Dynamics GP

Steve Endow found another eConnect issue in GP 9, this time eConnect Requester and eConnect_Out problem prevents entry of Purchase Orders

eConnect Requester Crashes with "Run-time error 3265: Item cannot be found in the collection..." in Dynamics GP

Steve Endow tracks down a connection provider issue associated with the econnect error "Run-time error 3265: Item cannot be found in the collection..."

Is the new "Remember User and Password" feature in Microsoft Dynamics GP 2010 safe?

Mariano looks at whether or not the new "Remember User and Password" feature in Microsoft Dynamics GP 2010 is safe? I say that it’s as safe as your computer is. The protected password is safe but if you walk away from your logged in PC or give our your Windows password then you’ve exchanged convenience for vulnerability.

Dynamics GP Webinar Calendar

Inside Microsoft Dynamics GP points us to an online calendar of webcasts. These aren’t solely GP related but it’s great to have all of this in one place. Don’t forget about the I.B.I.S. DynamicsCare webinars either. This month I’m doing one around Best Practices for A/R on October 19. It’s a great warm up for the GPUG Summit.
Check out all of the other I.B.I.S. Dynamics GP webinars coming up here: http://demand.dynamicscare.com/?elqPURLPage=76

Weekly Dynamic: Segregation of Duties Tool

While not strictly a Dynamics GP tool, AuditNet.org has a great, free Segregation of Duties Tool. This Excel tool allows a company to enter a person or role and then check off what that person can do. The tool then figures out where the segregation of duties conflicts lie. This is a fantastic starting point for working with GP 10 or 2010 security to help figure out what user roles should be and what access they should have. Having this as a starting point really makes setting up and documenting GP security easier.

Blog Theme: Fresh Ingredients

Now that I’ve finished crying over my Cowboys this week, it’s time to change the blog theme. The newest incarnation of 50 Tips in 50 Minutes debuts at iSight this week. I’ll be rolling out the freshest tips to help users get the most out of Dynamics GP so the background is going to reflect fresh ingredients this week.

The Software Testing Disconnect

Steve Endow digs deeper into Dynamics GP certification and it’s application to the real world in his new post The Software Testing Disconnect. I’ve taken the GP 2010 Install exam and Financials exam and I agree with Steve. The Install exam was well updated to accommodate SQL 2008 and new install features. The Financials exam didn’t seem to be updated at all. I’ve got the 2010 Project and Distribution exams tomorrow so we’ll see how those go.

Configuring Email for Sales and Purchasing Documents in Microsoft Dynamics GP 2010

Mariano has nice primer up on Configuring Email for Sales and Purchasing Documents in Microsoft Dynamics GP 2010

Microsoft Dynamics GP 2010 Cookbook Signing

I’ve had a number of people ask about getting their copy of the Microsoft Dynamics GP 2010 Cookbook signed by me. If you are going to iSight in Atlanta or Charlotte I will be there and I’ll be happy to sign your book. Also, if you will be at GP Partner Connections or the GPUG Summit in Orlando bring your book, I would love to meet you and sign it.
The nature of these events means that I won’t have copies of the book for you to buy. If you want me to sign one, you’ll have to bring your own copy. If you don’t have one, you can buy it now from Amazon.com.

Weekly Review: SOP to POP with a Service Item

I ran into an interesting scenario when this article was first written.

A client (who we'll call X) provides a device to it's end user companies and provides services around that device. At the end of the service term, the end gets to keep the device. Because of this, some end users ask to purchase a manufacturers extended warranty through client X.

This an interesting example of the SOP to POP functionality. Client X is shipping a device from their warehouse but the addition of the warranty, requires Client X to actually purchase the warranty from the manufacturer at the time of sale.  It's essentially a near time process since delivery of the warranty is virtual. We looked at using SOP to POP functionality to create the PO for the warranty and kept running into a problem. We couldn't push the service item to a P.O.

My first concern was that this was a limitation in GP but after talking to support, we found the issue. We hadn't marked allow backorders on the item record. After all, when we setup the service items, why would we need to back order a service right? Doh!

So the ultimate solution was to fix the appropriate service item records to allow back orders, enter the warranty in SOP, change the Quantity from Ordered to Back Ordered and create a P.O.

Part of our problem with this was that the issue came up very late in the project and we didn't have enough time to really sit and evaluate all the possible settings that could be causing us problems, but now I know where to go look first the next time.

Originally posted by Mark at 6/20/2008 12:27:00 PM

Back to School with Dynamics GP

It’s back to school time. The kids are back in school and settled in. Microsoft Dynamics GP partners are back in school scrambling to learn enough to pass new GP 2010 certification exams. Now it’s your turn to learn how to get more out of Dynamics GP with the Dynamics GP 2010 Cookbook. The book is full of recipes designed to make you more effective when working in Dynamics GP. Don’t worry if you haven’t upgraded to GP 2010 yet, the cookbook is still extremely useful for users running Dynamics GP 8, 9 or 10 as well and you’ll be ready when upgrade day finally comes.

Don’t be a dunce, learn how to get the most from your Dynamics GP solution.

 

Deductions in Arrears in Dynamics GP

Christina Phillips has nice look at new Deductions in Arrears functionality found in Dynamics GP. GP Payroll is not a specialty of mine so it’s great to see Christina providing coverage.

Removing Dynamics GP companies that no longer exist

Steve Endow tackles a great topic over at Dynamics GP Land, Removing Dynamics GP companies that no longer exist. This happens most often with test companies, when firms move servers or when they combine multiple GP companies into one leaving orphan companies.

Dynamics Latam Blog launches today

A new Dynamics GP Latin America blog launches today at http://blogs.msdn.com/b/dynamics_latam/. David Musgrave has coverage at Dynamics Latam Blog launches today.

Coding specific dates in SQL Server

Victoria Yudin has a great look at Coding specific dates in SQL Server. If you’ve ever struggled with dates in SQL server this is fantastic reference. Do you need the second Thursday of the the current month? Yeah, she shows you how to do that. It’s very complete.

Last Chance to Register for iSight 2010 Conference!

If you’re an I.B.I.S. customer this is it. This is your Last Chance to Register for the iSight 2010 Conference! If you miss this, you’ll miss the newest set of 50 Tips for Dynamics GP. Other people will have to pay hundreds of dollars to see it at other conferences. You’ll miss learning about what’s new in Dynamics GP 2010 and Management Reporter. You’ll miss getting free food out of Andy. You’ll miss Dwight’s witty repartee’.
Better yet. Just don’t miss it.

The Rise of the Power User, with Dynamics GP Leading the Way

My new article, The Rise of the Power User, with Dynamics GP Leading the Way is up at MSDynamicsWorld.com. I took some time to look a the rise of the power user coming in IT, how it affects Dynamics GP and how GP is already well positioned for power users to take full advantage.

Upcoming Events in the Microsoft Dynamics GP Community

David Musgrave has a nice round up of Upcoming Events in the Microsoft Dynamics GP Community I’m speaking at a number of these events so it’s a pretty busy time but these events are going to rock!

SmartConnect Pricing - Keep it Simple

Over at the The eOne Dynamics GP and CRM Blog, Martin gives us some insight into the pricing of their SmartConnect integration tool. This a tool that I’m using a lot lately and I’ve been very happy with both SmartConnect and the support from eOne. If you’re struggling with integrations take a look at SmartConnect.

GL Transactions with AA Details

veeyeskay provides us with SQL code to look at GL Transactions with AA Details in his latest post.

Nigel Frank Salary Survey

Nigel Frank is again conducting their Dynamics salary survey. Take the survey so you can then review the results of where your pay stands in the Dynamics world. The survey is at http://www.surveymonkey.com/s/microsoft_dynamics_salary_survey_2010_mp

Dynamics GP build numbers and service packs

Victoria Yudin has a fantastic look at Dynamics GP build numbers and service packs. This post includes downloadable references as well.

Account Rollup – Getting the combined balance on a range of accounts

I love it when folks provide another take on a great feature. Account Rollup is one of my favorite GP features that no one seems to know about, that’s why it got highlighted in the 50 tips. Ian takes his own look at Account Rollup – Getting the combined balance on a range of accounts at  DynamicsGP.ie.

What are all those GPSFOINTEGRATIONID columns in some tables

Mariano solves the mystery of What are all those GPSFOINTEGRATIONID columns in some tables.

Weekly Dynamic: Defer Accounts Payable Transactions

Previously I worked for a company that purchased content. We would buy video, like TV shows, and have the right to use them for a period of time. We would often have to pay up front and then need to spread the expense over say, a year. Well, not only is this easy to do in Dynamics GP, it can be done at the point of the AP invoice. This is great for things like insurance too.

In this example, we’ll use the Profit and Loss option in Deferral setup. This setting let’s the user enter ultimate expense account and then defer the transaction.

To make this happen in AP:

1. Enter an AP transaction
2. Click the distribution button
3. Select the Expense line to defer
4. Select Additional | Deferral from the menu at the top
5. Set the End of Period date, Method and Deferral account
6. Click Ok

Dynamics GP will adjust the transaction to move the expense to the deferral account and then it will create and post transactions to recognize the expense in the future. It doesn’t get much easier than that.

Are you ready for some football?

It’s football time here in the U.S. so this week’s blog theme represents America’s team, the Dallas Cowboys. Giants, Eagles, Redskins and Packer fans can feel free to leave hate comments here. I’ll gleefully delete them.

Stephen Elop leaving ms for nokia

In case you missed the breaking news, microsoft business division (which holds office and dynamics) pres Stephen Elop is leaving to become the ceo of nokia.  You gotta love blogging breaking news from a plane about to take off.

Many GP Customers Waiting for SP1 of Microsoft Dynamics GP 2010 Despite Positive Feedback on Upgrades from Early Adopters

MSDynamicsWorld has a new article up looking at  why Many GP Customers Waiting are for SP1 of Microsoft Dynamics GP 2010 Despite Positive Feedback on Upgrades from Early Adopters. I have clients who are waiting but it’s not for SP1, they are waiting for the Spanish translation or year end.

Service Pack 1 for Microsoft Dynamics Management Reporter Available

From Dynamics Corporate Performance Management I see that Service Pack 1 for Microsoft Dynamics Management Reporter Available - Dynamics Corporate Performance Management.

New Existing Customer Webcasts: Mark Your Calendars!

Inside Microsoft Dynamics GP is highlighting two new upcoming webinars geared toward existing customers. Check them out at New Existing Customer Webcasts: Mark Your Calendars! .

“ADO field is Nothing” in Integration Manager

Up now at DynamicsCare, Amy Walsh has a great look at the “ADO field is Nothing”  error that shows up in Integration Manager when it can’t find the source data.

Stop cash receipts for a customer on hold – Dynamics GP SDT Essential Series 4

Pushing the Support Debugging Tool even farther, Rubal uses triggers to prevent receiving payments for a customer on hold. Why would anyone want to do that? One word, lawsuit. Check out Rubal’s post on GP Window titled Stop cash receipts for a customer on hold – Dynamics GP SDT Essential Series 4.

Dynamics GP SDT Essential Series 3 – Using Triggers (GP on Steroids)

Over at GP Window Chetna is pushing the limits of the Support Debugging Tool with triggers in Dynamics GP SDT Essential Series 3 – Using Triggers (GP on Steroids).  I have to admit that this is pretty cool.

GJ or ????

Belinda has a nice look at using different source documents for different types of journal entries. I’m doing something similar now to identify different types of GL integration sources. Make sure to check out Belinda’s post GJ or ????

Weekly Review: Copying SmartList Builder Reports

This week's Weekly Review was shamelessly stolen from the GP Newsgroup.

If you have an existing SmartList Builder SmartList and you want to copy it as a template for a new SLB SmartList, you can follow these steps:

With SmartList Builder Open and the definition of the SmartList to be
duplicated loaded, click Extras >> Tools >> Duplicate and Type the new ID.

Thanks to Tim Foster for the tip!

Originally posted by Mark at 5/25/2008 09:31:00 PM

More Microsoft Dynamics GP 10.0 Service Pack 5 releases

Amy Walsh beat David Musgrave to the punch with her coverage of additional GP 10 SP5 releases but David has full coverage in his post More Microsoft Dynamics GP 10.0 Service Pack 5 releases.

Recorded I.B.I.S. Webinars are now available

Many of the great I.B.I.S. webinar recordings for Dynamics GP are now available. We do these bi-weekly so make sure to catch some live too. Here is one with David Humphreys covering Inventory Returns – Dynamics GP Field Service to get you started.

Send Reports to Screen (Instead of Printer) in Dynamics GP

Tina expands on Mariano’s original post on sending all posting reports to screen with her post Send Reports to Screen (Instead of Printer) in Dynamics GP .

It’s a great post but I’m trying to track down where it originated (I found it on GP Window). Tina, if this didn’t originate on GP Window ping me so I can follow your posts.

Performance Benchmark Results for Microsoft Dynamics GP 2010

Inside Microsoft Dynamics GP has new Performance Benchmark Results for Microsoft Dynamics GP 2010. Can anyone say millions of transactions? It’s a good thing that we have PowerPivot to analyze all of these transactions with.

Microsoft Dynamics GP 10.0 Service Pack 5 Login Performance issue

David Musgrave and Mariano Gomez have coverage of a login performance issue related to Analytical Accounting and GP 10 SP 5.

David has coverage here: Microsoft Dynamics GP 10.0 Service Pack 5 Login Performance issue

and Mariano looks at the issue here: Service Pack 5 affects Microsoft Dynamics GP 10.0 logon performance

I’ve never been a big AA fan. Every time I think that it settles down something like this pops up.

Come to the GPUG Summit!

I’ve actually got a beagle not a pug but since GPUP has nothing to do with dogs and everything to do with Dynamics GP I’ll be at the GPUG Summit in Orlando, October 25-28. GPUG is the Great Plains User Group and the Summit is the place to learn more about Dynamics GP. This isn’t a fluffy conference. It’s nitty gritty deep in the application time.

I’ve got a brand new set of 50 Tips for Dynamics GP ready to be delivered in just 50 Minutes. Many of you remember how good the first 100 were, well these are 50 more things that I couldn’t stuff into the bag before. The tips are applicable from version 6 (you remember that right?) all way to Dynamics GP 2010.

The GPUG Summit is fun, accessible and inexpensive compared to the information you’ll walk out with.

Go, register now!

 

Fun facts:

This is not a pug or a GPUG. This is my beagle Gracie. She has almost a hundred twitter followers. Who knew!

A Dynamics GP Blast From The Past: Local Temp Tables

Somehow Steve Endow missed that some temp tables in Dynamics GP are c-tree files because they are faster than SQL temp tables. Well, he’s caught up now and in case you missed that too, here is Steve’s coverage: A Dynamics GP Blast From The Past: Local Temp Tables

Speed Certification Exams for Dynamics GP

Like many of us, Steve Endow is racing to finish certification exams. Four new GP 2010 exams were released mid August and we’re all racing to have them done before 10/1 when new certification requirements for partners goes into effect. Steve followed Christina’s advice and tried taking the actual exam quickly. My exams tend to work the same way. If I’m really prepared, they take about a 1/2 hour or so. I’ve four scheduled over the next two weeks to squeeze in around work, travel and presentations so I feel Steve’s pain.
Check out his experience in his post Dynamics GP Land: Speed Certification Exams!

What’s a Dictionary in Dynamics GP?

Belinda is back with a nice look at what a dictionary is in Dynamics GP along with some details on Reports dictionaries and dealing with corruption in her new post What’s up *.dic, Reports.dic that is.

How To Simplify FRx Catalogs

FRx Buzz continues their look at simplifying FRx with How To Simplify FRx Catalogs.

Throw out the calculator with Allocation Accounts in Dynamics GP

Chuck that calculator and let allocations accounts do the math for you is the theme of Belinda, the GP CSI’s new post Throw out the calculator

Sure Step Myths Debunked

Christina Phillips does a great job tackling Sure Step myths in her post Sure Step Myths Debunked.

GP Partner Connections Conference

If you’re a partner, it’s time to sign up for GP Partner Connections Conference. This event focuses specifically on topics squarely on partner’s radar. The event will be held in beautiful Orlando, FL on October 23-25, just before the GPUG Summit.
I’ll be at the Partner Connections Conference speaking on some Business Intelligence related topics and hashing through related issues with you in a workshop. I’ll also be speaking on the Support Debugging Tool.
At Convergence in April, users came out of sessions scolding their partners for not showing them the Support Debugging Tool. The partners had never seen it. Make sure you attend this session to see how you can leverage the Support Debugging Tool to better support your client.

Business Portal Webinar for Dynamics GP – TODAY!

Don’t miss Today’s I.B.I.S. webinar on Business Portal at 11am. Rob Mitchell has tons of experience in the nitty gritty of making Business Portal run. This will be a  great session so register and pop on your headphones while digging out your desk from the long weekend. Register now at Business Portal Webinar .

Weekly Dynamic: Speed Date Entry with only the Day

Todd McDaniel reminded me of a little tip recently. In any date field in Dynamics GP, simply enter the day and tab off. the system will fill in with the month and year from the current system date in Dynamics GP. This is one of those tips that is so simple that it's easy to forget that it's there.

Enter This:

 

GP Creates This:

Five Years of Covering Dynamics GP

Over the weekend DynamicAccounting.net hit it’s five year anniversary covering Microsoft Dynamics GP.

All I can say is thank you to everyone who has read, contributed and put to use the tips listed here as we try to push Dynamics GP to the limit together.

Happy Labor Day!

I’m taking Labor Day off. Posting will resume tomorrow with a new Weekly Dynamic tip.

Microsoft Dynamics GP 2010 RTM "CoreMR" VPC is NOW AVAILABLE!!

For partners a new VPC image for GP 2010 is now available. This includes Management Reporter and should make basic demoing and testing easier than trying to figure out how to run Hyper V on your laptop. Inside Microsoft Dynamics GP has the full announcement in their post Microsoft Dynamics GP 2010 RTM "CoreMR" VPC is NOW AVAILABLE!!

Dynamics GP Service Pack 5 for Advanced HR, Payroll, Integration Manager and PDK

Amy Walsh looks at new additions to Service Pack 5 beyond the core that are now available. Specifically:

• Advanced Human Resources and Advanced Payroll Functionality
• Integration Manager
• Personal Data Keeper

Dynamics GP SDT Essential Series

Jivtesh gets in on Support Debugging Tool week with a look at changing the colors of company backgrounds in his Dynamics GP SDT Essential Series post.

Using the Support Debugging Tool to automatically start logging

When I formalized Mariano’s declaring this Support Debugging Tool week I didn’t realize what power I had. It’s actually become Support Debugging Tool week. In support of that, David Musgrave has a new post up on Using the Support Debugging Tool to automatically start logging - Developing for Dynamics GP.

I’m trying to figure out how to use my newfound powers for good. Maybe next I should declare, “Free ice cream for everyone week”. Hmm… I’ll have to think about this.

SQL view for Payables invoices originating from POP in Dynamics GP

Victoria Yudin has a new SQL view for Payables invoices originating from POP in Dynamics GP up on her website

Weekly Review: Excel Reports

The new Excel reports in Dynamics GP are really pretty cool and you don't need MOSS 2007 to play with them. You can use a network share to let your organization do a little Excel reporting.

To setup the default reports you need to do 2 things, deploy the connector and deploy the reports. Here's how:
In GP 10 pick Microsoft Dynamics GP-Tools-Setup-System-Reporting Tools Setup. Enter the system password if required.
Pick the Data Connections Tab

In the System Level Data connections box enter a shared network location to deploy the connectors to.
Do the same thing for the User Level Data connections. This can be a local directory.

Check Enable Data Connection Deployment. Check Deploy Data Connections for all existing companies if you want to run Excel reports off all your companies. Otherwise, when you deploy, you'll have to pick a company.

Click Run Deployment



Print or Cancel any reports and move to the Reports Library Tab.

Fill out the same type of information, Network location to deploy shared reports, local location for user reports, check the enable box and if you want to deploy for all companies, check the Deploy box.

Click the Run Deployment button. Print or cancel any reports.



You're done, now what?

You can navigate to the shared location from the Reports Library Tab and open one of the Excel reports. Even better from within Dynamics GP, go to the Navigation Pane on the lower left and pick Administration or the Administration tab. Click on Other Reports and wait for them to load.



Pick a report and double click it. The report opens nicely (and quickly in Excel). You may need to enable data connections. If a box pops up, enable data connections and go on.

In Excel 2007 the report shades every other row and provides filter handles on each column.

That's enough to let you play with it a little. I'll have more on GP 10's Excel reports and the cool things you can do with the connectors later.

Originally Posted by Mark at 3/25/2008 08:43:00 PM

Blog Background Change – Teal to fight Ovarian Cancer

I’m changing the blog background early this week. The background is going teal in support of my sister in law who is fighting ovarian cancer. Friday, September 3 is National Tea Time in support of the fight against ovarian cancer so the blog will be wearing teal for the next 10 days or so. To find out more about my sister in law Melissa and her fight, visit her Facebook page.

August Newsletter

The August DynamicAccounting.net newsletter went out last week. If you missed it you can see it, follow the link to catch it on the web. If you didn’t get yours, check your spam filter or sign up on the main page at DynamicAccounting.net.

Five Questions You Need to Answer When Creating a Microsoft Dynamics GP Report Specification

It’s nice to see Victoria Yudin writing again for MSDynamicsWorld.com. Her new article Five Questions You Need to Answer When Creating a Microsoft Dynamics GP Report Specification is up now. Make sure to check it out.

Dynamics GP 2010 – Fixed Assets Low Assets Pool

Amy Walsh shows us new GP 2010 functionality around Fixed Assets Low Assets Pools. This is great for companies with Australia, New Zealand or German operations among others. Also, courtesy of IFRS this may be coming to you too.

Enabling DEXSQL logs with Support Debugging Tool in Dynamics GP

Mariano says this must be Support Debugging Tool week in his new post Enabling DEXSQL logs with Support Debugging Tool. I agree. With all the powers I don’t really have I hereby declare this to be Support Debugging Tool week.

Also, if you want more support debugging tool info, check out chapter 10 of the Microsoft Dynamics GP 2010 Cookbook. There is a ton of information about using the Support Debugging Tool in there.