You, Me and Dynamics GP
The premier information site for Microsoft Dynamics GP
30 August 2012
Dynamics Online Services – New Features in Microsoft Dynamics GP 2010 SP3 (11.00.2044)
Dynamics Online Services get some new features with GP 2010 SP3 and Kelly Youells has the details.
Competing Against NetSuite - Inside Microsoft Dynamics GP
Jay Manley talks about Competing Against NetSuite and the confusion they spread around the Cloud. According to a Slashdot story that popped up right after I saw Jay's post, 51% people in a recent survey thought that stormy weather interferes with cloud computing.
Clearly we all have a lot of work to do.
[To pontificate briefly, accounting is accounting. we did it for 500 years on paper, by hand, apparently wearing little green eye shades. We can automate the rote pieces with computers just as engineers can automate calculations when designing a bridge and doctors no longer have to wait weeks for lab results. However, like Engineering and Medicine, Accounting remains a profession and no amount of automation (on premise, in the cloud or up someone's behind) can replace the judgment and expertise required to ensure proper control, accuracy, timeliness and usefulness of financial information. If anyone tell you differently, run. I've cleaned up too many messes created by someone playing accounting.]
Clearly we all have a lot of work to do.
[To pontificate briefly, accounting is accounting. we did it for 500 years on paper, by hand, apparently wearing little green eye shades. We can automate the rote pieces with computers just as engineers can automate calculations when designing a bridge and doctors no longer have to wait weeks for lab results. However, like Engineering and Medicine, Accounting remains a profession and no amount of automation (on premise, in the cloud or up someone's behind) can replace the judgment and expertise required to ensure proper control, accuracy, timeliness and usefulness of financial information. If anyone tell you differently, run. I've cleaned up too many messes created by someone playing accounting.]
Feature of the Day: Fixed Asset Calendars - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs
I like the idea of this Feature of the Day: Fixed Asset Calendars. I understand the concept of why you would want different fixed asset calendars for different books. Frankly though, I've screwed up fixed assets with a bad calendar and it was not pretty to fix. Multiple calendars won't help that.
Feature fo the Day: Mass Depreciation - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs
I'm doing a happy dance for this Feature fo the Day: Mass Depreciation backout! This shouldn't be needed very often but when it's needed it's really needed.
Creating a Dynamics GP Backup Plan | Dynamics GP Insights
Nathan Hayden looks at Creating a Dynamics GP Backup Plan. I've become a fan of Restore plans and that's the one thing missing from Nathan's otherwise great advice. Regularly scheduled test restores. At lease annually, preferrably quarterly.
Real Life vs. House of Lies « The Death of Reason
Dwight is back a with a look at Real Life vs. House of Lies. As usual, his intense jealousy of my hair causes him to take an unwarranted swipe at me.
[For those of you who don't know, Dwight and I have worked together on and off for the last 13 years. I've foolishly signed up to report up through him twice so ultimately the jokes on me.]
[For those of you who don't know, Dwight and I have worked together on and off for the last 13 years. I've foolishly signed up to report up through him twice so ultimately the jokes on me.]
Weekly Review: Dynamics GP Passwords, Case Sensitive Logins and ODBC Connections
Yeah, the title is a little weird. Here is
the background. A client was moving terminal servers. Old server and new server
were both pointed to the same Dynamics GP source. Users would log in to one
terminal server and everything worked fine. When they logged into the other
terminal server, GP would lock and their password needed to be reset. It didn't
matter which terminal server a user logged in to, the first one they logged into
worked fine, the second one hung and required a password reset to use that
terminal server.
I know, what does the terminal server have to do with a GP password?
Well Dynamics GP uses the User ID and the server name in the ODBC connection as part of the hash when encrypting the user password for the first time. In our case, one of the terminal servers had the SQL Server as a fully qualified domain name and one just had the server name. So the weren't exactly the same and it broke the ability to decrypt the password.
This is also why user logins are case sensitive. The ASCII characters are different for upper and lower case letters so different information is passed when encrypting upper case vs. lower case passwords for the first time.
To solve our little problem we made both server names identical in the ODBC setup and then we reset the passwords of the affected users.
Huge thanks to Rob Mitchell of I.B.I.S. for the background behind this. He is the one who actually solved this issue.
Originally Posted by Mark Polino
at 1/17/2011
09:00:00 AM
29 August 2012
Perpetual Pricing Top Tips - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs
Pam offers some GP 2013 licencing clarification with Perpetual Pricing Top Tips
Entering expiration dates for lot-tracked items in Purchase Order Processing for Microsoft Dynamics GP 2010
Kelly Dettmann answers questions around Entering expiration dates for lot-tracked items in Purchase Order Processing for Microsoft Dynamics GP 2010
How To Install The GP Web Services – Configure Management Tools | azurecurve
Continuing his deep dive, Ian Grieve looks at How To Install The GP Web Services – Configure Management Tools
Buckle Up, Here Comes Windows 8, Excel 2013 and GP 2013
My look at what's coming, Buckle Up, Here Comes Windows 8, Excel 2013 and GP 2013, is up at Mad Mark the GP Road Warrior.
28 August 2012
Microsoft Dynamics Sure Step Methodology Revisited - The Microsoft MVP Award Program Blog - Site Home - MSDN Blogs
In Microsoft Dynamics Sure Step Methodology Revisited, Sure Step gets some love from a CRM MVP but let's face it, his points apply to ERP too including Dynamics GP.
Windows 8: One Week or So « The Death of Reason
Dwight's been playing with Windows 8: One Week or So He comes to basically the same conclusions I did...more than a month ago.
Feature of the Day: Password Protecting Word Forms - Inside Microsoft Dynamics GP
Microsoft's new Feature of the Day: Password Protecting Word Forms adds to security in GP.
SQL view for rolling 12 months of sales by item in Dynamics GP | Victoria Yudin
Victoria Yuding has a new SQL view for rolling 12 months of sales by item in Dynamics GP
The Dynamics GP Blogster: How to add a "Cover Letter" page to a Microsoft Dynamics GP Word Template document
Mariano shows How to add a "Cover Letter" page to a Microsoft Dynamics GP Word Template document over at the Dynamics GP Blogster.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-6cQKKPyjudsY966JOAz5Zs0AIQ_WEaJ9Wbp_Zn8xmo55aOKOGHZvK3uoWNFyc4LhXqOCXOW_A7y8FAE1U5IIUIjCBdGnP511o8lwUbUEOmvHHH6kZjkisIaotD0vf89zxGfjUQ/s400/WordTemplate01.png)
Dynamic Future - Vote - Dependent Address Rolldown
This is a nice HR/Payroll suggestion, dependent addresses should roll down by defaul from the employee's address. Yes this won't always be the case but I'm willing to bet that it's the case more than half the time so there really should be an option to handle this better than retyping the addresses.
Apparently I left off the link. You can vote at: https://connect.microsoft.com/dynamicssuggestions/feedback/details/567286/gp-dependent-address
27 August 2012
About Dynamics, Development and Life: Importing/Exporting a Dynamics GP Transaction to Excel
Jivtesh reviews a couple of tools for Importing/Exporting a Dynamics GP Transaction to Excel
Feature of the Day: Intercompany Asset Transfer - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs
I've mentioned that Fixed Assets is getting an overhaul in GP 2013 and here is one of the new features: Intercompany Asset Transfer
How To Install The GP Web Services – Management Tools Installation | azurecurve
Continuting his comrehensive look at How To Install The GP Web Services – Management Tools Installation is Ian Grieve at Azurecurve.
Dynamics GP Land: Life as a Consultant: My Brain Hurts
From Steve Endow, Life as a Consultant: My Brain Hurts. As he was writing this, I was finishing three days of locked away meetings covering proof of concept/design for a batch manufacturing solution for a client so I have no idea what he's talking about.
Please Read: Official Risk Management Suite Transition Update - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs
Please Read: Official Risk Management Suite Transition Update
This sounds like someone, somewhere got their feathers ruffled. It's probably a good thing that some of the auditor comments I've heard didn't make it back to MS, or maybe they did.
This sounds like someone, somewhere got their feathers ruffled. It's probably a good thing that some of the auditor comments I've heard didn't make it back to MS, or maybe they did.
Microsoft Dynamics Corporate Performance Management, Management Reporter & BI Blogger: Budgeting in Management Reporter
Over at Microsoft Dynamics Corporate Performance Management, Management Reporter & BI Blogger
(Phew that's a long title), Les looks at Budgeting in Management Reporter and doesn't find any. That's part of why I prefer deFacto as an alternative.
(Phew that's a long title), Les looks at Budgeting in Management Reporter and doesn't find any. That's part of why I prefer deFacto as an alternative.
Understanding the Microsoft Access Database Engine Prerequisite - Dynamics Corporate Performance Management - Site Home - MSDN Blogs
From Dynamics Corporate Performance Management come Understanding the Microsoft Access Database Engine Prerequisite for Management Reporter.
Feature of the Day: 64-Bit Microsoft Office Compatibility - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs
A new Feature of the Day looks at 64-Bit Microsoft Office Compatibility. I'm definitely looking forward to this one.
SQL view for Variable Allocation Accounts in Dynamics GP | Victoria Yudin
Victoria Yuding gives us a SQL view for Variable Allocation Accounts in Dynamics GP
How To Install The GP Web Services – Security Configuration | azurecurve
Azurecurve continues the series on How To Install The GP Web Services – Security Configuration |
Clearing the Reporting Clutter - GPUG Magazine
The Fall 2012 edition of GPUG magazine is out. I've got an article on Clearing the Reporting Clutter in there starting on page 14. Make sure you check out this edition's other great articles too.
Weekly Dynamic: Fiscal Period Modifier Danger
Now that the Professional Services Tools Library (PSTL) is free, more people will be using them. However, the PSTL tools are powerful and this also makes them potentially dangerous.
Here is an example:
If you open PSTL tools, check Fiscal Period Modifier and click next you get some options to change the companies fiscal periods. So far, so good.
If you hit Setup Periods in Step 1 you will wipe out your current fiscal periods without warning.
Oops. Yeah. When I did this it was a pain in neck to fix the TWO company. I can't imagine doing it accidentally to a production company.
Here is an example:
If you open PSTL tools, check Fiscal Period Modifier and click next you get some options to change the companies fiscal periods. So far, so good.
If you hit Setup Periods in Step 1 you will wipe out your current fiscal periods without warning.
Oops. Yeah. When I did this it was a pain in neck to fix the TWO company. I can't imagine doing it accidentally to a production company.
26 August 2012
Business Portal and 64 Bit Web Browser
Sarah Purdy looks at issues with Business Portal and 64 Bit Web Browsers.
23 August 2012
Feature of the Day: Reconcile Bank Reconciliation to General Ledger - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs
Microsoft is showing off another great Feature of the Day: Reconcile Bank Reconciliation to General Ledger
For those of you complaining because you're still running PowerPoint 2003 and can't open these, get the free PowerPoint Viewer from Microsoft at http://www.microsoft.com/en-us/download/details.aspx?id=13
For those of you complaining because you're still running PowerPoint 2003 and can't open these, get the free PowerPoint Viewer from Microsoft at http://www.microsoft.com/en-us/download/details.aspx?id=13
iSolutions’ Blog - Dynamics GP Multi-Currency Exchange function to convert to USD
iSolutions is showing off a SQL based Dynamics GP Multi-Currency Exchange function to convert to USD
The Dynamics GP Blogster: GPUG Georgia Regional Chapter August Meeting
It looks like everyone had fun at the GPUG Georgia Regional Chapter August Meeting. Kudos to I.B.I.S.' Chris Liley for showing off SSRS.
Microsoft Dynamics GP Home Page is dependent on Short File Names - Developing for Dynamics GP
David Musgrave discovered that the Microsoft Dynamics GP Home Page is dependent on Short File Names
Weekly ReviewFixed Asset Impairment
There is no Fixed Asset Impairment feature
in Dynamics GP per se but that doesn't mean that it can't be done. The simplest
way to accomplish a full or partial Fixed Asset impairment is do a full or
partial retirement of the asset in GP and create a retirement code to identify
impairments. Since GP supports partial retirement by cost or % this will work
for assets that contain multiple quantities in GP.
For example, a $100,000 assets is impaired and is now only worth $60,000. The company can partially retire 40% of the asset (or specifically retire $40,000) and take a loss.
The nice thing about this is that it's easy to un-retire an asset. While Generally Accepted Accounting Principles (GAAP) won't allow you to un-impair an asset, International Financial Reporting Standards (IFRS) will. As the world moves toward IFRS, the ability to un-retire an asset and recapture the impairment becomes more important. It's also nice if you goof when retiring the asset.
For reporting purposes, using an impairment retirement code makes it easy to separate out impairment transactions from true retirements.
For example, a $100,000 assets is impaired and is now only worth $60,000. The company can partially retire 40% of the asset (or specifically retire $40,000) and take a loss.
The nice thing about this is that it's easy to un-retire an asset. While Generally Accepted Accounting Principles (GAAP) won't allow you to un-impair an asset, International Financial Reporting Standards (IFRS) will. As the world moves toward IFRS, the ability to un-retire an asset and recapture the impairment becomes more important. It's also nice if you goof when retiring the asset.
For reporting purposes, using an impairment retirement code makes it easy to separate out impairment transactions from true retirements.
Originally Posted by Mark Polino
at 1/10/2011
09:00:00 AM
22 August 2012
Feature of the Day: Consolidated Invoicing - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs
In a new Feature of the Day, Jay Manley shows off Consolidated Invoicing GP 2013 will now let you combine several shipments / fulfillment orders into a single invoice.
You have to Read and Never Stop Learning!
John Lowther found out the hard way that You have to Read and Never Stop Learning!
Yes, Dynamics GP 2010 is Compatible with Microsoft SQL Server 2012
Judy Hirst reminds us that Yes, Dynamics GP 2010 is Compatible with Microsoft SQL Server 2012
Update: Adding Window Size and Position Memory using the Support Debugging Tool - Developing for Dynamics GP - Site Home - MSDN Blogs
Update: Adding Window Size and Position Memory using the Support Debugging Tool from David Musgrave
How To Install The GP Web Services – Verification | azurecurve
Azuecure coninues their look at How To Install The GP Web Services – Verification
21 August 2012
Microsoft Support Response Times – Mysteries Revealed | Dynamics University
From Dynamics University comes details of Microsoft Support Response Times – Mysteries Revealed
Cleaning up after a Payroll Error
John Lowther is quickly becoming an expert at Cleaning up after a Payroll Error.
Feature of the Day: Requisition List - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs
Over at Inside Microsoft Dynamics GP, they've got a new Feature of the Day: Requisition List . The list of requisitions looks cool.
How To Install The GP Web Services – Configuration | azurecurve
Update: Encrypting Table Data Fields using the Support Debugging Tool - Developing for Dynamics GP - Site Home - MSDN Blogs
Developing for Dynamics GP deliver an Update: Encrypting Table Data Fields using the Support Debugging Tool
Dynamic Future - Vote -
John Lowther wants additional payroll account options. If you want that too, go vote.
For any Payroll Account Type you only have the options for Department, Position, and Code to map that to a specific posting account.
But I need other items from the Employee Maintenance window like Division, Location, and Class ID, even one of these would solve my problem but all three would be great. Additionally, for existing customers that do not need these extra columns the "All" entry in that column would work fine for them.
20 August 2012
Feature of the Day: Deductions In Arrears Templates
From Friday comes a look at Deductions In Arrears Templates coming for Dynamics GP 2013.
Multiple Users Sending Emails from a Single Email Account.
John Lowther explains Multiple Users Sending Emails from a Single Email Account.
Feature of the Day: Select Printer at time of Print - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs
This has been a long time comin. In a Feature of the day Microsft looks at Select Printer at time of Print
I Will Kill the Next Person That Says “Incentivize” « The Death of Reason
Dwight's all wound up. Find out why he says "I Will Kill the Next Person That Says “Incentivize” "
How to restrict the options for Accounts, Items, Sites and Vendors available when creating a Requisition in Requisition Management
Lucas Miller shows off How to restrict the options for Accounts, Items, Sites and Vendors available when creating a Requisition in Requisition Management
Weekly Dynamic: Solve for Values - Bank Rec Example
Let's say for example that someone has done a poor job of entering deposits in Dynamics GP. Instead of selecting appropriate receipts and processing a deposit, they selected receipts that don't match the way the physical deposit was made. Now you have a mess trying to balance the bank account. Having to add multiple items to match a single number commonly comes up in Bank Rec. (I don't just mean GP bank rec either. I've seen cases where you have to combine items differently for bank recs by hand, with Quickbooks, Peachtree and Oracle financials. It's a bank rec thing.)
Excel can be a big help when trying to combine transactions to match so we're going to work through an example. One caveat, this method finds one match. It may not be the only combination that can match. You'll need the Solver add in that comes with Excel. Use File-Options-Add Ins to see if it's turned on and activate it if it's not.
1. Key amounts into Excel that look like this:
The Amounts column contains the amounts that you will ultimately use to try to find a match. Indicator is just the number 1 all the way down. We use it in the calculation.
2. In cell C1 type SumProduct(A2:A7,B2:B7). This will show the sum of A x B.
3. In cell D1 type 27.62. This is the amount we are trying to combine items to find. It's here just for reference.
Excel is going to add up the items in multiple combinations until it finds a combination that matches 27.62.
4. Click the Solver icon
5. In Set Objective enter or select $C$2
6. Check Value Of and enter the amount you want to find - 27.62
7. Set By Changing Value of Cells to $B$2:$B$7
8. Click Add. Set Cell Reference equal to $B$2:$B$7 and the middle field to bin.
9. Click OK. Click Solve.
Excel changes the 1's to 0's except for the lines that add up to $27.62.
To reset to search for another number, change column B back to all 1's, click the Solver icon and change the amount.
Many times when working through a bank statement there is a pattern. Items are off by a day for example. These are pretty easy to find by hand. Sometimes it's a lot harder an you a tool like this.
Excel can be a big help when trying to combine transactions to match so we're going to work through an example. One caveat, this method finds one match. It may not be the only combination that can match. You'll need the Solver add in that comes with Excel. Use File-Options-Add Ins to see if it's turned on and activate it if it's not.
1. Key amounts into Excel that look like this:
2. In cell C1 type SumProduct(A2:A7,B2:B7). This will show the sum of A x B.
3. In cell D1 type 27.62. This is the amount we are trying to combine items to find. It's here just for reference.
Excel is going to add up the items in multiple combinations until it finds a combination that matches 27.62.
4. Click the Solver icon
5. In Set Objective enter or select $C$2
6. Check Value Of and enter the amount you want to find - 27.62
7. Set By Changing Value of Cells to $B$2:$B$7
8. Click Add. Set Cell Reference equal to $B$2:$B$7 and the middle field to bin.
9. Click OK. Click Solve.
Excel changes the 1's to 0's except for the lines that add up to $27.62.
To reset to search for another number, change column B back to all 1's, click the Solver icon and change the amount.
Many times when working through a bank statement there is a pattern. Items are off by a day for example. These are pretty easy to find by hand. Sometimes it's a lot harder an you a tool like this.
16 August 2012
Tracking Payroll Master Record Changes | Dynamics GP Insights
Alternative Income Statement format -- how did you do that? - Dynamics Corporate Performance Management - Site Home - MSDN Blogs
Dynamics Corporate Performance manaement asks: Alternative Income Statement format -- how did you do that?
![](http://blogs.msdn.com/resized-image.ashx/__size/550x0/__key/communityserver-blogs-components-weblogfiles/00-00-01-21-64/7888.1.png)
How To Install The GP Web Services – Installation | azurecurve
Could not load file or assembly 'Microsoft.Dynamics.GP.BusinessIntelligence.Homepage.dll' - Developing for Dynamics GP - Site Home - MSDN Blogs
David Musgrave tackles the error: Could not load file or assembly 'Microsoft.Dynamics.GP.BusinessIntelligence.Homepage.dll'
It's been a good couple of months for Fastpath
If I were Fastpath, I'd be wondering where all the free marketing was coming from and how I could get more. The last several months have seen a number of unrelated items all point to Fastpath's products for users of a Microsoft Dynamics ERP system.
For those of you not familiar, Fastpath makes security related products for all of the options in the Microsoft Dynamics line. For Dynamics GP specifically they offer:
Config AD - Single sign on and security management tied to active directory. Yes you can log in to GP using AD.
Audit Trail - Transaction auditing.
Assure - Separation of Duties evaluator for Dynamics GP. This doesn't get enough airtime but for risk junkies it's pretty cool.
Audit View - Audit/Security report scheduling and delivery.
It all started with the July issue of Journal of Accountancy which profiled ten years of Sarbanes-Oxley. I thought, hey, SOX generates plenty of Audit Trail and Assure work for Fastpath. Thought drifted away into the ether.
Then my much anticipated August J of A arrived (they are all much anticipated, don't read anything to the August part) . Lo and behold, it's all about fraud and we're back talking about security control, auditing and separation of duties.
[Sidebar: For fun, checkout this this fraud, described at CFO.com, that included the CEO colluding with the HR manager because the CFO “always demanded proper documentation”.]
Finally, MSDynamicsWorld.com is reporting that Microsoft is killing the native Audit Trail module in Dynamics GP. Frankly, MS bought this functionality and doesn't appear to have ever spent a dime improving it. I think they got tired of trying to support it.
So in a couple of months span, Fastpath has two J of A issues, not just articles, dedicated to needs and problems that their products help solve and a major competitor exits the business. (By major competitor I really mean inertia and the idea that "It's included so let's try to use it".)
Yep, they've had a couple of good months. If they are smart, they'll leverage these marketing gems for a long time to come and hope for September J of A hat trick.
For those of you not familiar, Fastpath makes security related products for all of the options in the Microsoft Dynamics line. For Dynamics GP specifically they offer:
Config AD - Single sign on and security management tied to active directory. Yes you can log in to GP using AD.
Audit Trail - Transaction auditing.
Assure - Separation of Duties evaluator for Dynamics GP. This doesn't get enough airtime but for risk junkies it's pretty cool.
Audit View - Audit/Security report scheduling and delivery.
It all started with the July issue of Journal of Accountancy which profiled ten years of Sarbanes-Oxley. I thought, hey, SOX generates plenty of Audit Trail and Assure work for Fastpath. Thought drifted away into the ether.
Then my much anticipated August J of A arrived (they are all much anticipated, don't read anything to the August part) . Lo and behold, it's all about fraud and we're back talking about security control, auditing and separation of duties.
[Sidebar: For fun, checkout this this fraud, described at CFO.com, that included the CEO colluding with the HR manager because the CFO “always demanded proper documentation”.]
Finally, MSDynamicsWorld.com is reporting that Microsoft is killing the native Audit Trail module in Dynamics GP. Frankly, MS bought this functionality and doesn't appear to have ever spent a dime improving it. I think they got tired of trying to support it.
So in a couple of months span, Fastpath has two J of A issues, not just articles, dedicated to needs and problems that their products help solve and a major competitor exits the business. (By major competitor I really mean inertia and the idea that "It's included so let's try to use it".)
Yep, they've had a couple of good months. If they are smart, they'll leverage these marketing gems for a long time to come and hope for September J of A hat trick.
Weekly Review: Exporting to Other Systems
Recently I’ve had a number of requests for regular processes to get data out of Dynamics GP for integration to other systems. The export formats were all over the place including CSV, fixed length and pipe delimited (|).
In all cases there have been common elements to the exports, they want them to be user initiated. There have also been common elements to the solution, Microsoft Excel.
In one case I used SmartList Builder to create a SmartList with everything we needed to export, then I used a SmartList Export Solution to provide a button for the user to export the data to Excel and activate an Excel macro to format and save the file.
In another case, the client didn’t own SmartList Builder so I used a refreshable Excel report to get the data we needed an then used a macro to format the export.
With the power of Excel, getting data out to other systems becomes easy.
Originally Posted by Mark Polino at 12/13/2010 09:00:00 AM
In all cases there have been common elements to the exports, they want them to be user initiated. There have also been common elements to the solution, Microsoft Excel.
In one case I used SmartList Builder to create a SmartList with everything we needed to export, then I used a SmartList Export Solution to provide a button for the user to export the data to Excel and activate an Excel macro to format and save the file.
In another case, the client didn’t own SmartList Builder so I used a refreshable Excel report to get the data we needed an then used a macro to format the export.
With the power of Excel, getting data out to other systems becomes easy.
Originally Posted by Mark Polino at 12/13/2010 09:00:00 AM
15 August 2012
How to reconcile the Checkbook Balance to the GL Cash Account in Microsoft Dynamics GP
Dynamics GP Support and Services details How to reconcile the Checkbook Balance to the GL Cash Account in Microsoft Dynamics GP
This was timely. The question came up just as this post went up.
This was timely. The question came up just as this post went up.
Bug 64711: Year End Close Report is not balanced
Francisco Hillyer ran smack into Bug 64711: Year End Close Report is not balanced
Feature of the Day: Certification, Licensing and Training Management - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs
In a new Feature of the Day, Inside Microsoft Dynamics GP explores Certification, Licensing and Training Management
Customizing My Reports Lists in GP 2010 | onza blog
Amanda Wong looks at Customizing My Reports Lists in GP 2010
14 August 2012
Energized Accounting: What Keeps You Up at Night? Accounts Payable
Recently Metafile was kind enough to help out with our GPUG CFO Special Interest Group (SIG) and help folks understand more about document management software selection. Now Energized Accounting has a great new post up on What Keeps You Up at Night? Accounts Payable. The post screams document management without ever mentioning the topic.
If I ran a document management software firm I would be sending this out everywhere.
If I ran a document management software firm I would be sending this out everywhere.
Feature of the Day: Relate-Link Items for Suggested Sales - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs
In a new Feature of the Day for GP 2013, Microsoft shows off Link Items for Suggested Sales. Essentially a related items box pops up to support suggestive selling, cross-selling or associated items.
I did view a while back designed to display related items. That could be used as a starting point to populating the linked items.
I did view a while back designed to display related items. That could be used as a starting point to populating the linked items.
Dynamic Future - Vote - Allow bank transactions through the intercompany module
We're going back to banking for this week's new feature that we want to see in Dynamics GP - Intercompany Bank Transactions. This is something I would really like to see in GP. If you agree, please follow the link to vote.
13 August 2012
How to Fix a Write to Setup File Aborted Error from the Support Debugging Tool - Developing for Dynamics GP - Site Home - MSDN Blogs
David Musgrave shows How to Fix a Write to Setup File Aborted Error from the Support Debugging Tool
Learning More » Richards Attic
Richard Whaley is Learning More as he starts to write about GP 2013. I'm finding the same thing. I keep learning about things that are in the current product that I either didn't know about or haven't used much so I forgot that they were there.
I think the clear lesson is that if someone professes to know everything there is to know about Dynamics GP, don't walk away, run.
I think the clear lesson is that if someone professes to know everything there is to know about Dynamics GP, don't walk away, run.
Mohammad R. Daoud: Selecting a New Microsoft Dynamics GP Partner
Mohammad Daoud has some suggestions for Selecting a New Microsoft Dynamics GP Partner. I think that there can be some differences when selecting a partner for a new implementation versus a change for an established entity but I'll let you read Mohammad's piece and draw your own conclusions.
Feature of the Day: Reconciled Indicator - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs
Microsoft is adding a Reconciled Indicator to Microsoft Dynamics GP 2013's Void Historical Payments. This should help prevent some mistakes going forward.
Dynamics GP Land: Storing Additional Data in SOP Transactions
Steve Endow has a great post on Storing Additional Data in SOP Transactions up now at Dynamics GP Land.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiPD9Z4W56cb1fRf2yfow9PaquBh4lXSsuyq0XS7GtUnmYFt3LaV5RrQrOVtKBKCdmZqKLsOwjnBWEKAsSreh0JGJX6h6N8mJ3Q-im7_IC5LDxRQ4uNUytDn_08xwutB-8mNRuMhw/s400/SOPAdditionalFields.jpg)
Do's and Don'ts of Microsoft Dynamics GP Forums: More Real World Lessons | MSDynamicsWorld.com
Victoria Yudin updates a previous MSDynamicsWorld article of mine with her own Do's and Don'ts of Microsoft Dynamics GP Forums: More Real World Lessons.
She offers some great advice that's worth following.
She offers some great advice that's worth following.
Weekly Dynamic: Override AR Writeoff
In Dynamics GP you can set a maximum write off amount for a customer on the Customer Maintenance Options card. (Cards | Customer, click options). This works great for controlling small writeoffs, little short pays, etc.
At some point though you'll need to write off something larger. A great way to do this is to add a password to exceed the maximum write off. This is set in Receivables Setup.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgefrlYEZmit-_K1o3csJU-PyX5mqJyh4b9xEH2qoP-2T-aLGmFxwOfHXlzVJ2psksV7yqwu751EYCYbAqJnMqaTArGyXZJ-8cVzA5wTTvSeDxLlu_aQrr0anQkIPc1cJAHg4g/s400/Capture1.JPG)
At one time or another you'll have write off's and GP gives you lots of options.
At some point though you'll need to write off something larger. A great way to do this is to add a password to exceed the maximum write off. This is set in Receivables Setup.
At one time or another you'll have write off's and GP gives you lots of options.
09 August 2012
Feature of the Day: Item Standard Cost Adjustment - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs
The funny thing is I was just talking Standard Cost with a customer day and we covered this item. Now Item Standard Cost Adjustment is getting improved in GP 2013.
Viewing your GP Security in SmartList using a SmartList Builder setup
From the Dynamics GP Support and Services blog comes information about Viewing your GP Security in SmartList using a SmartList Builder setup. This includes 3 new SmartList Builder based security reports that you can import into your system.
Of course, you could always use PowerPivot and Excel to create a pivot table on the security tables or the Security Profiler in the Support Debugging Tool find and fix denied access or FastPath's Assure to identify separation of duties conflicts.
Now you have another tool.
Of course, you could always use PowerPivot and Excel to create a pivot table on the security tables or the Security Profiler in the Support Debugging Tool find and fix denied access or FastPath's Assure to identify separation of duties conflicts.
Now you have another tool.
Does Microsoft Dynamics GP Scale? | MSDynamicsWorld.com
My new article is up at MSDynamicsWorld.com. In it I ask Does Microsoft Dynamics GP Scale?
Weekly Review: Options for Controlling GL Posting
There are a couple of different options for controlling posting to the GL in
Dynamics GP. One option is to add a password for posting GL batches in
Tools->Setup>Posting. On the plus side, this lets anyone create a GL
transactions but only those with the password can post. The downside is that
transactions that would otherwise post through from a subledger, won’t.
Another option that is often over-looked is to control who can post to the GL with security. This will still let anyone create GL entry but only those with proper posting permission can actually post a batch or transaction.
![image image](http://lh4.ggpht.com/_BFj0p8giN1k/TOmgVMtK_fI/AAAAAAAAAwE/5hi_Cs7eHL4/image_thumb.png?imgmax=800)
Another option that is often over-looked is to control who can post to the GL with security. This will still let anyone create GL entry but only those with proper posting permission can actually post a batch or transaction.
![image image](http://lh4.ggpht.com/_BFj0p8giN1k/TOmgVMtK_fI/AAAAAAAAAwE/5hi_Cs7eHL4/image_thumb.png?imgmax=800)
Originally Posted by Mark Polino
at 11/22/2010
09:00:00 AM
08 August 2012
Feature of the Day: Reconcile IV to GL - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs
A new Feature of the Day for GP 2013 that is sure to be a hit is the new Reconcile IV to GL
Using Buyer ID’s in GP 2010 | onza blog
Amanda Wong looks at alternative ideas for Using Buyer ID’s in GP 2010 , assuming that you don't have buyers of course.
Feature of the Day: Email Indicators - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs
From last week comes a Feature of the Day: Email Indicators This is a nice way to see if a transaction has been emailed.
Feature of the Day: SRS Reports on Forms - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs
One more Feature of the Day to catch up with: SRS Reports on Forms. This pretty cool. Now if we can just get posting reports too we can make Report Writer go away...maybe...sort of. It's still the source for Word Forms.
Canadian Payroll & US Payroll in the same environment - Blog - Kuntz Consulting
Kuntz Consulting looks at what happens when you try to use Canadian Payroll & US Payroll in the same environment
Tuning Up Project Accounting in Dynamics GP
Printing the Header on the First Page Only in Word Templates
Andy Sather looks at the pros and cons of Printing the Header on the First Page Only in Word Templates.
Determine Company_Options from DYNAMICS.dbo.SY01500 (Reading a Multi-Select List Box) - Developing for Dynamics GP - Site Home - MSDN Blogs
David Musgrave explains how to Determine Company_Options from DYNAMICS.dbo.SY01500 (Reading a Multi-Select List Box)
Dynamic Future - Vote - Multicurrency Cash Flow Forecast
Yes, I'm a day late with this. Deal with it, my schedule is a mess.
In this weeks Connect feature, we suggest adding Multicurrency Cash Flow Forecast into Dynamics GP.
It's hard enough to get cash flow forecasts right. I don't even want to think about doing it in other currencies.
06 August 2012
Dynamics GP Excel Paste
Copy and Pasting into GP from Excel keeps getting better. First from Mohammad R. Daoud: Dynamics GP Excel Paste – New Features has been Added!
Next comes word from TitaniumGP, another tool that can copy/paste into GP.
Next comes word from TitaniumGP, another tool that can copy/paste into GP.
Feature of the Day: Fixed Assets - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs
You can put this down as my favorite Feature of the Day: Historical Fixed Asset Reporting
Hello from iSight 2012 Keynote – Greg Bustin | I.B.I.S. Inc.
We're gearing up for iSight coming to Atlanta and Charlotte September 25th and 26th. Check out Hello from iSight 2012 Keynote – Greg Bustin for more.
Why my integration is changed? Sort-wise
Francisco Hillyer asks Why my integration is changed? Sort-wise
Feature of the Day: Word Documents - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs
GP 2013 is getting additional Word Document Templates as well.
Microsoft Dynamics GP 2010 Utilities “Hanging” when Upgrading the Databases with Service Pack 3 or any Later Hotfix
Kelly Youells offers some help when Microsoft Dynamics GP 2010 Utilities “Hanging” when Upgrading the Databases with Service Pack 3 or any Later Hotfix
The time has come again to vote for the next year's GPUG All Star awards.
Please take the time to vote for your "All Star".
Each year, GPUG (The GP User Group) recognize 3 Premium Members who represent the community well by having:
- Courage – The strength to persevere, hold the talent to teach fellow GP users.
- Passion – For those who share their GP and technology passion with others.
- Resolve – Willing to take the time to help others with challenges they face.
- Advancement – The pursuit of individual and organizational growth and development.
Click on the logo or link below to vote:
The winners will be announced at the GPUG Summit 2012 in Seattle, WA, USA on the 15th to 19th of October at the Conference Center at the Washington State Convention Center.
Visit www.gpugsummit.com to see the event agenda and learn more.
If you are not registered, then REGISTER TODAY. I will be there and I'm looking forward to seeing you there too.
Weekly Dynamic: Line Numbers in SQL Server
Many of you know just enough SQL to get by. By definition that involves some trial and error to get things right. Inevitably one of your Select statements will fail and SQL will give you some hints about what's wrong including a line number.
But how do figure out what line is what? Do line numbers include spaces? There is a line number listed in the bottom right but even that is a pain to use.
In SQL Server Management Studio you can turn on line numbers with Tools | Options, expand Text Editor, Expand Transact-SQL, select General and check Line Numbers under Display.
But how do figure out what line is what? Do line numbers include spaces? There is a line number listed in the bottom right but even that is a pain to use.
In SQL Server Management Studio you can turn on line numbers with Tools | Options, expand Text Editor, Expand Transact-SQL, select General and check Line Numbers under Display.
02 August 2012
Management Reporter 2012 Doesn’t Process Reports In Queue | azurecurve
Ian Grieve ran into a problem where Management Reporter 2012 Doesn’t Process Reports In Queue | azurecurve
Feature of the Day: Tenant Services - Inside Microsoft Dynamics GP
Tenant Services is the latest Feature of the Day coming for GP 2013.
Weekly Review: Copy Distribution Reference
In GL distributions, users often want to copy a distribution reference to all
of the lines. Well, there is no magic technique to make that happen but there is
away to make it easier.
- Start by expanding the GL lines to show the Distribution Reference
- Enter the reference in the first line
- Copy the first line’s reference
- Press the down arrow to move to the distribution field on the next line
- Paste the reference
- Press the down arrow again and repeat until the reference has been copied to all of the lines.
Originally Posted by Mark Polino
at 11/15/2010
09:00:00 AM
01 August 2012
About Dynamics, Development and Life: Creating an Enterprise Data Warehouse (EDW) for Consolidated Business Intelligence (CBI) Series
Jivtesh likes John Lowther's Creating an Enterprise Data Warehouse (EDW) for Consolidated Business Intelligence (CBI) Series
New cost warning in Microsoft Dynamics GP 2010 SP3 for cost variances
On the Microsoft Dynamics GP Support Blog, Pam Peterson explains a New cost warning in Microsoft Dynamics GP 2010 SP3 for cost variances.
![image image](https://community.dynamics.com/cfs-file.ashx/__key/CommunityServer-Blogs-Components-WeblogFiles/00-00-00-05-36-metablogapi/1830.image_5F00_thumb_5F00_145E88D5.png)
Account Not Found When Posting Stock Count Variances
Feature of the Day: Alternate Modified Forms and Reports Window - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs
An improved Alternate Modified Forms and Reports Window is the latest GP2013 Feature of the Day.
New Management Reporter 2012 update available - Dynamics Corporate Performance Management - Site Home - MSDN Blogs
New Management Reporter 2012 update available. Rollup 2 includes support for SQL 2012, fixes to allow Multicurrency comparative balance sheets and a pile of bug fixes.
We can check off one Microsoft Connect item!
For AX users, this is the end of the direct connection. Users will need to move to the Data Mart provider with the next release. Why am I mentioning AX? I think the future of MR is a data mart for GP too.
We can check off one Microsoft Connect item!
For AX users, this is the end of the direct connection. Users will need to move to the Data Mart provider with the next release. Why am I mentioning AX? I think the future of MR is a data mart for GP too.
Subscribe to:
Posts (Atom)