Microsoft is highlighting features of the upcoming Management Reporter 2012. In their latest installment they show off Distributing reports to multiple locations - Management Reporter 2012 Feature Highlight
DynamicAccounting.net
You, Me and Dynamics GP
The premier information site for Microsoft Dynamics GP
26 January 2012
15 Spreadsheet Formatting Tips « PowerPivotPro
PowerPivotPro has 15 Spreadsheet Formatting Tips. It’s really a nice collection.
![clip_image004[4]](http://www.powerpivotpro.com/wp-content/uploads/2012/01/clip_image0044_thumb.jpg "clip_image004[4]")
Microsoft Dynamics GP 2010 Cookbook is a 2011 Best Seller for Packt Publishing
In their January newsletter, Packt Publishing put out a list of their Top Selling books for 2011.
Only two Dynamics books made the list and only one of those was a Dynamics GP book, the Microsoft Dynamics GP 2010 Cookbook.
Don’t wait for Convergence. They sold out fast last year. Buy yours now.
Weekly Review: Amortization vs. Straight Line Depreciation
Folks often have questions about the difference between Amortization and Straight Line Depreciation in the GP Fixed Assets module. This is how the various calculations work:
For Amortization:
For Amortization:
| Amortization Code | Calculation |
| Daily | Amortization Amount * 365 (or 366 if leap year) |
| Weekly | Amortization Amount * 52 |
| Monthly | Amortization Amount * 12 |
| Quarterly | Amortization Amount * 4 |
| Yearly | Yearly Depreciation Amount = Amortization Amount |
| Percentage | (Cost Basis - (LTD Depreciation - YTD Depreciation)) * Percentage |
| Rate | (Cost Basis - Salvage Value - Special Depreciation Allowance) * Rate |
For Straight Line:
| Depreciation Method | Calculation |
| Straight-line Orig Life | (Cost - Salvage Value - Special Depreciation Allowance) ÷ Original Life in Years If the Original Life includes days, the days will be converted to a fraction with days as the numerator and 365 as the denominator. For example, if the number of days is 146, the fraction would be displayed as 146/365. |
| Straight-line Rem Life | (Cost - Salvage Value - (LTD Depreciation Amount - YTD Depreciation Amount)) ÷ Remaining Life in Days This calculation determines the daily depreciation rate, which must be multiplied by the number of days in the year. This method is used when you select the Switch to Straight-Line option. |
Since Amortization doesn't consider the life of the asset, only the cost, users need to calculate the life of an asset when using amortization, unlike depreciation.
[H.T. to Xen Osorio who clarified this beyond the help documents in a Partner newsgroup post.]
25 January 2012
GP Security Tasks are not always what they are said to be! » Summit Group Software Blog
The Summit Group reminds us that GP Security Tasks are not always what they are said to be!
You have to look at the details.
Understanding Direct Deposit Fields in Dynamics GP | Dynamics GP Insights
Christina Phillips helps with Understanding Direct Deposit Fields in Dynamics GP over at Dynamics GP Insights.
The Dynamics GP Blogster: Microsoft Dynamics Convergence 2012 sessions now published
Mariano mentioned that the Microsoft Dynamics Convergence 2012 sessions now published.
I have 2 sessions on DayONE:
- 50 ways to close the Month Faster with Dynamics GP
- The Worst Mistakes you can make with Dynamics GP
And two Convergence sessions which will each get repeated.
- The Best of 50 Tips in 50 Minutes for Microsoft Dynamics GP
- Turning Data into Answers with Microsoft Dynamics GP & Microsoft Excel
Setting up Integration Manager to import Multidimensional Analysis (MDA) information - Dynamics GP Support and Services Blog - Site Home - MSDN Blogs
On the Microsoft Support and Services Blog Angela Melhus shows off Setting up Integration Manager to import Multidimensional Analysis (MDA) information
Where Do the Microsoft Dynamics GP Experts Turn for Answers? A Preamble to GPUG DayONE | MSDynamicsWorld.com
In a prelude to DayONE at Convergence, Mariano asks “Where Do the Microsoft Dynamics GP Experts Turn for Answers?” over at MSDynamicsWorld.
An Interview with Glenn McPeak of Data Masons
Data Masons provides EDI solutions for all of Microsoft’s Dynamics ERP offerings. Their products are well respected by users and partners alike, and they are big supporters of the Dynamics Community.
I had the opportunity to interview Glenn McPeak from Data Masons to talk about EDI, community and GP ‘12’. Here is the interview:
Glenn, can you give us a brief overview of what Data Masons does and what makes you special?
What makes Data Masons unique in the industry is our particular focus on EDI compliance & integration for the Microsoft Dynamics marketplace. We are the only Microsoft Dynamics ISV with a solution (Vantage Point EDI) that integrates EDI documents to each of the Microsoft Dynamics ERP platforms. As a company, you can say we are an EDI provider, but from an execution standpoint, our focus is on Microsoft Dynamics and from a technology standpoint, we can integrate EDI documents without having to customize the host ERP. This advantage gives Dynamics customers a competitive edge by putting them in a strong position of flexibility, whether it’s responding to their trading partners’ requirements or their own internal needs, such as taking advantage of the next version of their ERP. Either way, Microsoft Dynamics customers can use EDI as a business advantage.
Data Masons has been around for some time, how has EDI and its importance changed over the past few years?
EDI, which Data Masons broadly defines as the exchange and integration of common business transactions, has grown dramatically in regards to its importance and breadth in business relationships. Today it is quite common for larger organizations to mandate EDI capability as a prerequisite for new suppliers and business partner relationships. While a few years ago most companies traded only a few documents, such as purchase orders, invoices and ship notices, today there are many more documents that can drive labor efficiencies. EDI comes into play because these documents also require more flexible and comprehensive software applications.
Companies that embrace EDI successfully find that they can streamline activities with key partners. EDI technology replaces manual transaction entry, lowers the cost of doing business and eliminates many of the risks that commonly result from human error and miscommunication. Instead, they can run their business 24/7 and manage business transaction flows via exception, for example, receiving an alert when an order is received with price errors or a supplier invoice does not match the purchase order and receiver.
Are there specialty areas where Data Masons excels?
We have the largest trading partner document library for Microsoft Dynamics GP in the market today. No one has more types of documents, integrated in and out of GP, then Data Masons. Beyond that, there are industries where we have particular expertise, both from a software and personnel perspective. Most EDI providers shy away from Automotive and Industrial Equipment Industries because of the complexity of the documents that are important to these companies, but Data Masons has a competitive strength in these areas. Our integrated EDI solution, Vantage Point EDI, has out-of-the-box functionality that gives a Dynamics GP customer multiple ways to handle their 830’s and 862’s. We also have consultants that have worked in Automotive EDI for more than 20 years. Data Masons has a similar story in the Consumer Packaged Goods and Hardlines areas. If you are supplying a Big Box Retailer, then we have the expertise and solution to cover all your needs.
Microsoft is hard at work on GP ‘12’ scheduled for release sometime in 2012. Is Data Masons going to be ready for that release on time?
Yes, Data Masons will be ready shortly after the official release of GP ‘12’. Due to the way we have architected our solution, there is minimal effort on our part to become compliant with the next version of Microsoft Dynamics GP. Because we are not physically coded inside of Dynamics GP, we remain flexible enough for our customers to upgrade with little to no disruption to their current business process.
I know that Data Masons has a significant community presence in social media and working with GPUG. Will you have a presence at this year’s Convergence conference in Houston?
Data Masons is fully supportive of using Social Media to help build awareness for the Dynamics GP community, as you’ll be hearing from now until after Convergence on our Blog (http://www.datamasons.com/blog/) and Twitter Feed (@datamasons). For anyone attending the event, please stop by our expo hall booth (#445) as we’ll be attending again as a bronze sponsor.
And yes, you’re correct about our involvement with GPUG, so expect to see us at DayOne at Convergence, at chapter meetings throughout the year, on Webinars and the group’s promotions via Social Media.
Lastly, let me share a little about some exciting news… We are in the final stages of having our Blog syndicated by the Microsoft Dynamics Community - making it easier for you to follow us. This process has been in the making for months now as we had to meet various requirements before our blog could be considered, for example, not only showing expertise in EDI but with regards to Dynamics GP as well. A big win for us!
-----------------------------------------------
I want to thank Glenn again for being willing to talk about EDI, Community, GP ‘12’ and for all of the support they provide to Dynamics users.
24 January 2012
Dynamics GP Keyboard Shortcuts | WebSan Solutions Blog
WebSan reminds us of some Dynamics GP Keyboard Shortcuts
Comments - Management Reporter 2012 Feature Overview - Dynamics Corporate Performance Management
Dynamics Corporate Performance Management is starting off the march to Management Reporter 2012 with a look at the new Comments feature in Management Reporter 2012.
Microsoft Dynamics Knowledge Base Articles available from Microsoft Support - Developing for Dynamics GP
David Musgrave reminds us that the Microsoft Dynamics Knowledge Base Articles are available from Microsoft Support.
I’m reminding you that they are also available in MyGPSearch.com
At Convergence 2012, Microsoft Dynamics GP Leads the Fight Against Alien Infiltration | MSDynamicsWorld.com
MSDynamicsWorld likes my new story in their article At Convergence 2012, Microsoft Dynamics GP Leads the Fight Against Alien Infiltration
Accounting Best Practices Podcast
Episode 135 of the Accounting Best Practices podcast looks at Fine Tuning Your Control process. It’s worth a listen. You can have too many controls, to few controls or just the wrong controls. Frankly if you’re looking at controls with any of the Dynamics ERP products, listen to the podcast and then look at FastPath’s Assure product.
23 January 2012
The Dynamics GP Blogster: 1099 reports: the devil is in the details
Mariano digs deep into 1099’s and finds that with 1099 reports: the devil is in the details
How To Create A Microsoft Dynamics GP Installation Package | azurecurve
Ian Grieve shows How To Create A Microsoft Dynamics GP Installation Package over at azurecurve.
Imagine There is No Excel
A recent CFO.com headline asked us to Imagine there is No Excel. The article goes on to discuss how companies are dealing with analytics and the rise of big data.The beauty of Excel is not just it’s power and ease of use but it’s ubiquity. You can’t throw a rock in a Finance or Accounting department without hitting an Excel spreadsheet so it’s not going to go quietly into the night.
The CFO.com article touches on analysis products for big companies (Hyperion, Cognos) and for startups (QuickBooks users) but curiously leave out mid-sized companies.
I’ve been spending time lately with deFacto Performance Management and frankly, it does a great job of tackling many of the items discussed in the article for mid-sized firms.
deFacto is integrated corporate reporting, budgeting, forecasting and planning including consolidations and eliminations. The interface isn’t “Excel-Like” the interface IS Excel tied to SQL analytics for nice mix of power and simplicity. deFacto compares very nicely to the Hyperions and Cognoses of the world without the budget blowing price tag and ridiculously long project times. Plus it integrates well with Dynamics GP and Dynamics AX.
We like it so much that we’re using it in house at I.B.I.S. I expect that you’ll hear more from me about this subject soon but if you’re looking for serious Corporate Performance Management for GP or AX you need to look at deFacto.
The CFO.com article touches on analysis products for big companies (Hyperion, Cognos) and for startups (QuickBooks users) but curiously leave out mid-sized companies.
I’ve been spending time lately with deFacto Performance Management and frankly, it does a great job of tackling many of the items discussed in the article for mid-sized firms.
deFacto is integrated corporate reporting, budgeting, forecasting and planning including consolidations and eliminations. The interface isn’t “Excel-Like” the interface IS Excel tied to SQL analytics for nice mix of power and simplicity. deFacto compares very nicely to the Hyperions and Cognoses of the world without the budget blowing price tag and ridiculously long project times. Plus it integrates well with Dynamics GP and Dynamics AX.
We like it so much that we’re using it in house at I.B.I.S. I expect that you’ll hear more from me about this subject soon but if you’re looking for serious Corporate Performance Management for GP or AX you need to look at deFacto.
Weekly Dynamic: Microsoft Convergence 2012: A Space Odyssey
My new short story Microsoft Convergence 2012: A Space Odyssey has not seen the download volume I was hoping for, even though the PDF version is free. I’m thinking that’s because it’s behind a registration page. I really think you’ll like this so I’m going to make it freely available without registration.
The premise of the story is:
An alien recon ship has arrived to set the stage for the conquest of Earth. They want Earth for it's resources, slave labor and advanced accounting knowledge. As part of the recon they send a spy to infiltrate Microsoft's Convergence 2012 conference. At the conference the alien spy discovers the full reach of Microsoft Dynamics GP and the power of community. Will it be enough to save Earth?
Don’t worry you’ll get a chuckle and I’m hoping you like the twist at the end. Feel free to share it with friends.
19 January 2012
Save the World at Convergence 2012
My new Mad Mark column is up at the Dynamics Community site. It was fun writing fiction about saving the world at Convergence but there are some ways that you can truly save at least a small corner of someone’s world at Convergence 2012 in Houston. Check out the article to find out how.
The Dynamics GP Blogster: The Support Debugging Tool on Twitter!
The The Support Debugging Tool is now on Twitter with its own hashtag #MSDYNGPSDT
Also a big thanks to Mariano for including a shout out for the Social Media for Microsoft Dynamics Partners eBook.
What You Should Know About ERP Systems and SOX Compliance | 360° ERP Blog
Panorama Consulting looks at What You Should Know About ERP Systems and SOX Compliance.
If you’re looking for help with Sox compliance for any of the Dynamics ERP products look at FastPath. That’s what I used when I need Sox compliance and I was very happy.
Announcing the Convergence 2012 Closing Keynote Speaker - Microsoft Dynamics Convergence
Microsoft has announced the Convergence 2012 Closing Keynote Speaker. It’s General Colin L. Powell, USA (Ret.)
Microsoft seems to be putting more money into Convergence lately. Last year it was Malcolm Gladwell and this year it’s Daughtry and Colin Powell. It’s nice when the accountants get a little love.
Dynamics GP Payroll Processing – A Deceptively Simple Example
Steve Chapman has a quick overview of payroll in Dynamics GP Payroll Processing – A Deceptively Simple Example
Weekly Review: Picking Instructions
When using Advanced Picking in Dynamics GP, users have the option to assign picking instructions to customers, addresses and items. For example, if some items require a forklift for picking, that instruction could be setup as a picking instruction and then assigned to a specific set of items. These picking instructions will print on any sales docs used for picking as long as Print Picking Instructions was checked.
There are three key parts to picking instructions:
1) Setting up the instruction. This is set in Purchasing|Cards|Picking Instructions
2) Assign the instructions to Customers, Items, etc. from Purchasing|Cards|Process Instructions
3) Make sure that Print Picking Instructions is selected when printing picking tickets.
Picking Instructions provide a great option for improving picking by increasing picking efficiency.
Originally Posted by Mark Polino at 2/15/2010 09:00:00 AM
Subscribe to:
Posts (Atom)
