DynamicAccounting.net

Distributing reports to multiple locations - Management Reporter 2012 Feature Highlight - Dynamics Corporate Performance Management

noreply@blogger.com (Mark Polino) — Thu, 26 Jan 2012 10:00:02 PST

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

15 Spreadsheet Formatting Tips « PowerPivotPro

noreply@blogger.com (Mark Polino) — Thu, 26 Jan 2012 09:00:01 PST

PowerPivotPro has 15 Spreadsheet Formatting Tips. It’s really a nice collection.

Dynamics GP - Learn & Discuss: Test Company Posting Journal File Destinations

noreply@blogger.com (Mark Polino) — Thu, 26 Jan 2012 08:00:07 PST

Vaidy digs into Test Company Posting Journal File Destinations

SQL view for current Receivables aging in Dynamics GP | Victoria Yudin

noreply@blogger.com (Mark Polino) — Thu, 26 Jan 2012 07:00:09 PST

Victoria gives us a new SQL view for current Receivables aging in Dynamics GP

Microsoft Dynamics GP 2010 Cookbook is a 2011 Best Seller for Packt Publishing

noreply@blogger.com (Mark Polino) — Thu, 26 Jan 2012 06:30:03 PST

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

noreply@blogger.com (Mark Polino) — Thu, 26 Jan 2012 06:00:00 PST

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:

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.]

Originally Posted by Mark Polino at 3/01/2010 09:00:00 AM

GP Security Tasks are not always what they are said to be! » Summit Group Software Blog

noreply@blogger.com (Mark Polino) — Wed, 25 Jan 2012 12:00:03 PST

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

noreply@blogger.com (Mark Polino) — Wed, 25 Jan 2012 11:00:04 PST

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

noreply@blogger.com (Mark Polino) — Wed, 25 Jan 2012 10:00:04 PST

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

noreply@blogger.com (Mark Polino) — Wed, 25 Jan 2012 09:00:05 PST

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

noreply@blogger.com (Mark Polino) — Wed, 25 Jan 2012 08:00:01 PST

In a prelude to DayONE at Convergence, Mariano asks “Where Do the Microsoft Dynamics GP Experts Turn for Answers?” over at MSDynamicsWorld.

Dynamics GP Land: Management Reporter- Using Dimension Sets for Report Design Efficiency

noreply@blogger.com (Mark Polino) — Wed, 25 Jan 2012 07:00:07 PST

Christina Phillips looks at Management Reporter- Using Dimension Sets for Report Design Efficiency

An Interview with Glenn McPeak of Data Masons

noreply@blogger.com (Mark Polino) — Wed, 25 Jan 2012 06:00:17 PST

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.

Configuring Microsoft Word Templates in Dynamics GP | Dynamics GP Insights

noreply@blogger.com (Mark Polino) — Tue, 24 Jan 2012 12:00:04 PST

Christina Phillips shows how to Configure Microsoft Word Templates in Dynamics GP

Dynamics GP Keyboard Shortcuts | WebSan Solutions Blog

noreply@blogger.com (Mark Polino) — Tue, 24 Jan 2012 11:00:05 PST

WebSan reminds us of some Dynamics GP Keyboard Shortcuts

SQL view for sales quantities by item by year | Victoria Yudin

noreply@blogger.com (Mark Polino) — Tue, 24 Jan 2012 11:00:02 PST

Victoria Yudin offers up a SQL view for sales quantities by item by year

Comments - Management Reporter 2012 Feature Overview - Dynamics Corporate Performance Management

noreply@blogger.com (Mark Polino) — Tue, 24 Jan 2012 10:00:00 PST

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.

Why does the JE description say “Receivings Transaction Entry”? - Blog - Kuntz Consulting

noreply@blogger.com (Mark Polino) — Tue, 24 Jan 2012 09:00:06 PST

Kuntz Consulting wonders Why does the JE description say “Receivings Transaction Entry”?

Microsoft Dynamics Knowledge Base Articles available from Microsoft Support - Developing for Dynamics GP

noreply@blogger.com (Mark Polino) — Tue, 24 Jan 2012 08:00:10 PST

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

noreply@blogger.com (Mark Polino) — Tue, 24 Jan 2012 07:00:03 PST

MSDynamicsWorld likes my new story in their article At Convergence 2012, Microsoft Dynamics GP Leads the Fight Against Alien Infiltration

Accounting Best Practices Podcast

noreply@blogger.com (Mark Polino) — Tue, 24 Jan 2012 06:00:05 PST

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.

Get Connected with Connect in Microsoft Dynamics GP! - Dynamics GP Support and Services Blog

noreply@blogger.com (Mark Polino) — Mon, 23 Jan 2012 11:00:03 PST

Kelly Youells reminds us that we can Get Connected with Connect in Microsoft Dynamics GP!

The Dynamics GP Blogster: 1099 reports: the devil is in the details

noreply@blogger.com (Mark Polino) — Mon, 23 Jan 2012 10:00:01 PST

Mariano digs deep into 1099’s and finds that with 1099 reports: the devil is in the details

Report group navigation changes - Management Reporter 2012 Feature Highlight - Dynamics Corporate Performance Management

noreply@blogger.com (Mark Polino) — Mon, 23 Jan 2012 09:00:00 PST

Dynamics Corporate Performance Management looks at Report group navigation changes - Management Reporter 2012 Feature Highlight

How To Create A Microsoft Dynamics GP Installation Package | azurecurve

noreply@blogger.com (Mark Polino) — Mon, 23 Jan 2012 08:00:11 PST

Ian Grieve shows How To Create A Microsoft Dynamics GP Installation Package over at azurecurve.