Everything Dynamics GP #35

The MVPs share their thoughts on GP 12, Silverlight and Windows 12

Mariano Gomez - Jumping on the Windows 8 van wagon

Mark Polino - Microsoft Dynamics GP 12 and Silverlight

And I am off for my week long vacation!

GP

• Year-to-year Inventory Margin Report using the PIVOT operator in T-SQL (Mariano Gomez)
• Year-to-year Inventory Margin Report using the PIVOT operator in T-SQL - Follow up! (Mariano Gomez)
• Add Item chunk works fine with GP10 and GP2010 R2 (Ian Stewart) – shares that the “Add Item” functionality works fine on GP 10 and GP 2010
• Description of the support of Microsoft Dynamics GP in a virtual environment – Somebody was asking about this recently.

Troubleshooting

• Error Message "Cannot access this report (or form) because the dictionary containing it is not loaded." when Printing a Report in Microsoft Dynamics GP (MBS)
• Steps to reconcile bank statement with no activity in Bank Reconciliation using Microsoft Dynamics GP (MBS)
• Error message when attempting to import a Canadian Payroll import file in Dynamics GP: "Imported file must end with _BCH.csv when File Type Selected is CSV" (MBS)

eConnect

• Leveraging the changes in eConnect for Microsoft Dynamics GP 2010 (Chris Roehrich)
• Integrations Via eConnect Disappearing (Ian)
• Serializing eConnect XML – Properly (Steve Endow)
• eConnect 2010 Error: The transaction has aborted (Steve Endow)

Other Interesting Stuff

• Windows 8 on Acer Iconia Tab (I am eyeing one, oh, what fun we will have together)
• Microsoft Dynamics Operations Ordering Month-End Timelines – Sept to Nov 2011 (Kevin Machayya )
• What is and isn’t dead in Windows 8 – Arsanth

Jivtesh (Microsoft Dynamics GP MVP)
Microsoft Dynamics Certified Technology Specialist: GP 2010
Have any GP related questions ? Feel free to email me at Jivtesh AT gmail.com
Blog : www.jivtesh.com
GP Help Website : www.gpwindow.com (Over 10,000 Dynamics GP Resources)

Dynamics GP Web Client - Update

Jay Manley at the Inside GP Blog, very articulately, explains the selection of Silverlight as the technology for GP web client. As he says – "

What is great about the Windows 8 operating system is that it supports multiple styles of applications, and we are making a conscious decision to develop on the one we feel is best suited for business applications.

I wrote about this briefly yesterday as well -  In Windows 8 you have two modes: metro and classic.  Metro is for exciting responsive new apps that you can use while sitting on a designer couch. Classic is the Windows of spreadsheets and complex applications that we've used in our day jobs for years.

To clear things up further, I have this diagram from BUILD

 

Here,  it is an updated image - The part in GREEN is the metro style apps, and the part in BLUE is for most enterprise apps. 

 

On the green side there will be the casual apps (games, social networking, content/media apps), and on the blue side will be all the enterprise apps. This might change in a few years, but that’s how it probably will be for the next 3-4 years.

Just like no complete ERP apps fit in on the iPad App Store or the Android Store, ERP apps will probably not fit into the Metro mode. Of course stripped down versions can exist, however, a complete ERP app requires a different platform. 

As of today, Silverlight gives you – a rich presentation platform + the deployment/update story of an HTML application. You also have a clean logical separation – pure data is coming from the server and a presentation layer that is built on top of that data. Add to that the fact that Silverlight lets you easily integrate your existing .NET codebases (or even native code via PInvoke) and it makes it the best choice for business applications.

Here’s a quote from the Telerik Blog

At Telerik we still believe in Silverlight, and we are betting on it. We are not only continuing to sell our existing Silverlight controls, but we are also continuing to invest in the ongoing development of new controls for Silverlight.

I think the Dynamics GP team is on the best track ahead in architecting the web client.

Hope that helps!

More resources :

Where do LOB / productivity apps fit into Windows 8?

--
Thanks,
Jivtesh (Microsoft Dynamics GP MVP)
Microsoft Dynamics Certified Technology Specialist: GP 2010
Blog : www.jivtesh.com
GP Help Website : www.gpwindow.com (Over 10,000 Dynamics GP Resources)

Everything Dynamics GP #34

Microsoft Dynamics GP 12's Silverlight Plans Unchanged Despite Windows 8 Plug-In Limitations - MSDynamicsWorld has the update from Errol Schoenfish. I think Metro will rock, but as Leon wrote  -

In Windows 8 you have two modes: metro and classic.  Metro is for exciting responsive new apps that you can use while sitting on a designer couch. Classic is the Windows of spreadsheets and complex applications that we've used in our day jobs for years.

You can subscribe to Everything Dynamics GP via email

GP

• DynDeveloper.com – The new website by Steve Gray to help our GP Developers
• Little Tricks With Report Writer Package Files (Christina Phillips)
• Creating a view of CRM Data in Dynamics GP (Great Plains) (Robert Houdeshell)
• Upgrade Your Outdated SQL Server to Unlock the Potential of Your Microsoft Dynamics GP 2010 R2. (ERP Software Blog)

GP Add-On Products/ ISVs

• Problem Solved: Centralized Payment Processing in a Multi-Entity Environment (Binary Stream)
• Reduce Audit Risk Through Seamless Automation of Sales Tax Compliance with Avalara (Summit Group)

Troubleshooting

• Get Change Next operation on table GL_Account_Master Invalid Key - Ian Stewart, is back!
• Mea Culpa: Fixing A Corrupt Sales Invoice (Ian Grieve)
• Aged Debtors Report Problem(Ian Grieve)
• Error Message "Cannot access this report (or form) because the dictionary containing it is not loaded." when Printing a Report in Microsoft Dynamics GP (KB)

Other Interesting Stuff

• Robocup Junior WA 2011 Rescue Premier State Champions (David Musgrave) – Jimmy a year later, has grown smaller and faster. :)
• Who is to blame for problems with the tax authorities? – Funny

Jivtesh (Microsoft Dynamics GP MVP)
Microsoft Dynamics Certified Technology Specialist: GP 2010
Have any GP related questions ? Feel free to email me at Jivtesh AT gmail.com
Blog : www.jivtesh.com
GP Help Website : www.gpwindow.com (Over 10,000 Dynamics GP Resources)

Everything Dynamics GP #33

Mariano Gomez has an awesome post up - Running Fixed Assets Depreciation causes Microsoft Dynamics GP to "hang" . Mariano takes out his valuable time to document in details his troubleshooting steps while resolving a complicated issue, it makes a great read!

Now you can subscribe to Everything Dynamics GP via email

GP

• Workstation Level Settings Lost during Upgrade (David Musgrave) – looks at the dex.ini settings you need to keep in mind after an upgrade. As David mentions, its always a good idea to backup the dex.ini before the upgrade and review the settings. You can read a lot more posts about dex.ini settings at GPWindow.com - Dynamics GP- SUPPORT (TECHNICAL) > Dex.ini Settings
• Email option is unavailable for SOP transactions - Rhonda S. reminds us that the email option will only work on the blank format.
• Dynamics GP Land: Using Custom Icons to Differentate GP Versions (Steve Endow) Smart stuff, as Steve points out this would be helpful if you have a few GP Installs and use your system tray shortcuts.
• Custom Splash in Microsoft Dynamics GP- Ian looks at a custom screen and points to the original retro post by David Musgrave - Customise the Microsoft Dynamics GP Splash Screen
• Account Level Security and Creating New GL Accounts - Sivakumar Venkataraman looks at creating new accounts when you have Account Level Security turned on.
• Managing Grants with Microsoft Dynamics GP - James Meyer, Maner Costerisan
• A Voice from the Field: Extending Microsoft Dynamics GP with the Right Tools and Careful Choices (Jack Boyer)

Downloads

• Management Reporter - Service Pack 2 Regional Installs Released! (Jill Carter)

News/Events 

• Microsoft Dynamics September 2011 News & Highlights - Kevin Machayya is back with his monthly video update.
• Grow Your Business with Microsoft Dynamics GP (Inside GP Blog)
• Don't Miss the Upcoming Microsoft Dynamics ERP Webcast Series (Inside GP Blog)
• Looking to connect with other GP Partners? (GP Partner Connections)

Reporting

• Copying Report Writer Report Packages - Christina Phillips shares some very cool report writer tips. Read this, it will save you a ton of time someday.
• SQL Reporting Services Error- Maximum request length exceeded – iSolutionPartners Blog
• Indicator to specify single page or multi page customer statements - Sivakumar Venkataraman

Other Interesting Stuff

• Windows BUILD Developer Conference and Windows 8 Preview (David Musgrave) – 8 seconds to boot-up, awesome!

Dynamics GP Videos of the Day

• Microsoft Dynamics GP Sales Order Processing Deposits (Belinda Allen)

Jivtesh (Microsoft Dynamics GP MVP)
Microsoft Dynamics Certified Technology Specialist: GP 2010

Blog : www.jivtesh.com
GP Help Website : www.gpwindow.com (Over 10,000 Dynamics GP Resources)

Everything Dynamics GP #32

The healthy competition between IE, Chrome and Firefox has made life extremely complicated. Today I had a website, which would only work in Firefox, a website which would only work in IE and a website which would only work in Chrome!

Now you can subscribe to Everything Dynamics GP via email

GP

• Microsoft Dynamics GP 2010 R2 On Windows 8 Developer Preview - Ian saves me some time this weekend. This was one of the top things in my weekend list!
• Streamlining Sales Processes with Process Holds - Christina Phillips
• Bank Reconciliation and Voided Checks - Sivakumar Venkataraman
• Mythbusting: Yes MACRS depreciation works just fine in Dynamics GP  - Mark Polino
• Home Screen Connect Error – Server Error in ‘/lus’ Application.’ – Ian Grieve
• Congrats to the Accounting Today VAR 100 - Mark Polino
• Fix It Solutions for Microsoft Dynamics – Automated Solutions for Dynamics GP 
• Can Microsoft Kinect Bring Motion Control to Your ERP Software System? | ERP Software Blog 
• What is Microsoft Dynamics GP Localization and Translation? | ERP Software Blog 

Events 

• GPUG Summit - Meet Me there – Now this is creativity!
• Join Us at GPUG Summit 2011 (Nov 8-11 in Las Vegas)
• Microsoft Dynamics Partners Await Details on Impact of the Master VAR Program – Sept 27

Reporting/SQL Scripts 

• SQL Scripts–Vendor Invoice Pricing Discrepancy – Ron

Windows 8 Stuff

• Windows BUILD Developer Conference and Windows 8 Preview - David Musgrave – Woooooosh (Thats how long it takes for Windows 8 to boot up)
• Windows 8 Developer Preview First Impressions
• Sorry Apple, Windows 8 ushers in the post-post-PC era 
• First Look at What's New in Windows 8
• Windows 8 Has Finally Updated the Blue Screen of Death

Other Interesting Stuff

• From the Microsoft Garage to you: Mouse Without Borders - David Musgrave
• Microsoft Dynamics Surestep Online  - Sivakumar Venkataraman

Dynamics GP Videos of the Day

• Kinect gestures and Business Analyzer for Dynamics GP | Coding4Fun Kinect Projects | Channel 9 –Channel 9 picked up the video, reaching an even bigger audience !

Jivtesh (Microsoft Dynamics GP MVP)
Have any GP related questions ? Feel free to email me at Jivtesh AT gmail.com
Blog : www.jivtesh.com
GP Help Website : www.gpwindow.com (Over 10,000 Dynamics GP Resources)

Everything Dynamics GP #31

Microsoft has unveiled a new Windows 8 preview at BUILD – it looks smashing! App Store, Metro Apps, designed for touch based interfaces, the near future looks very promising.

Now you can subscribe to Everything Dynamics GP via email

GP

• More free bullets for PSTL (Dan Edwards) – discusses some of the other free PSTL tools. Read his first post here - PSTL - The often overlooked weapon for Dynamics GP 
• Quick Tip: Using substring() with a text field datatype (David Musgrave) – This guy is awesome! David review a cool sample from Sivakumar and updates it for longer snippets.
• Weekly Dynamic: POP Reference (Mark Polino)
• Field List button missing in Word Templates (Andy Sather) – explains what you need to do if your Field List button is missing.
• Dynamics GP Blog Interviews Planned (Jack Boyer)
• Buy 2 get 1 free | Packt Publishing Technical & IT Book and eBook Store

Reporting

• SQL Scripts–Invoices Coming Due Next Week (Ron)
• SQL view for user activity in Dynamics GP (Victoria Yudin)
• Manually changing SysData location (Joseph Tews) tackles this FRx task
• Error message when you start Microsoft FRx after applying a service pack: “Runtime Error 32797: Application Defined or Object Defined Error” (Joseph Tews)
• Failed to start service SPSearchServiceInstance on this server after completing upgrade. Please start it manually. (Joseph Tews)

Windows 8

• Guide to Installing and Booting Windows 8 Developer Preview off a VHD (Virtual Hard Disk) (Scott Hanselman)
• Welcome to Windows 8 – The Developer Preview (Steven Sinofsky)
• BUILDing the Future with Visual Studio (Somasegar)
• Microsoft BUILD – Keynote summary (Dennis Delimarsky)
• I_See_What_You_Did_There (Anonymous)
• Microsoft's Windows 8 by the numbers | ZDNet

Other Interesting Stuff

• MSDN Forum Assistant – If you use the forums often, this should be handy!
• Other Microsoft Dynamics Customer Support Changes

Jivtesh (Microsoft Dynamics GP MVP)
Have any GP related questions ? Feel free to email me at Jivtesh AT gmail.com
Blog : www.jivtesh.com
GP Help Website : www.gpwindow.com (Over 10,000 Dynamics GP Resources)

Everything Dynamics GP #30

Microsoft Dynamics ERP Business Ready Licensing Module Offer (Kevin Machayya) - Effective September 1, 2011 through the end of the business day on December 22, 2011, qualifying Microsoft Dynamics GP, Microsoft Dynamics SL and Microsoft Dynamics NAV customers in the United States can purchase a la carte user license modules for up to 15% off of Microsoft’s Dynamics standard list price.

Now you can subscribe to Everything Dynamics GP via email

GP

• Creating a Support Debugging Tool Non-Logging Trigger to run after login (David Musgrave)
• Weekly Review: Internet User Defined Fields (Mark Polino)
• Credit Limits and Sales Process Holds (Christina Phillips)
• Warning “Sales Order Processing and Invoicing are both installed” in Microsoft Dynamics GP (Rubal)
• Microsoft Dynamics GP, the next generation of end-user customization tools? (Mariano Gomez) – points to the resources related to his excellent post.
• Key Keyboard Shortcuts for Dynamics GP (Mike Urbom) – You can find more here http://www.gpwindow.com/GP_USER_INTERFACE/Shortcuts/
• How to display more than 80 characters of an Extender Long String field in reports using the Support Debugging Tool (David Musgrave)
• Analytical Accounting is Hidden Gem for NonProfits
• New functionality – ‘Negative Cash Receipts’ – great addition, however…

GP Troubleshooting

• Fixing A Corrupt Sales Invoice (Ian Grieve)

Reporting

• How To Use All Account User Defined Fields On SmartLists – Step By Step(Ian Grieve)
• Management Reporter: “Cannot connect to the Management Reporter Server. Do you want to specify a different server address?” Dani Richardson has some troubleshooting steps when you run into MR problems

Database/SQL

• New LOGICAL functions in SQL Server Denali - SQL Server Notes from the Field - SQLServerCentral.com

Other Interesting Stuff

• Microsoft Dynamics AX 2012 Launches Worldwide
• Microsoft Dynamics Master VAR Program: What it Means for You
• DigMyData - get it. | 47 Hats – Looks like a useful service, if you are selling things online.
• Delivering fast boot times in Windows 8 - Building Windows 8 - Site Home - MSDN Blogs

Dynamics GP Videos of the Day

• Microsoft Dynamics GP Sales Order Processing Allocation (Belinda Allen) This video reviews multiple options for allocating in Microsoft Dynamics GP Sales Order Processing. I allocate by line, by document, by batch and by transferring. I also show the Mass Document allocation window.  

Jivtesh (Microsoft Dynamics GP MVP)
Have any GP related questions ? Feel free to email me at Jivtesh AT gmail.com
Blog : www.jivtesh.com
GP Help Website : www.gpwindow.com (Over 10,000 Dynamics GP Resources)