June 20, 2012

Excel Paste for “Any Screen” in Microsoft Dynamics GP

Check out Mohammad Daoud's latest blog post - it could revolutionize how we copy/paste data into GP.

Excel Paste for “Any Screen” in Microsoft Dynamics

Click on the link above and Enjoy!

Microsoft Dynamics GP 2013 Features and Enhancements

Wondering what's coming up in GP 2013?  Here's a partial list of feature enhancements we have to look forward to when GP 2013 is released later this year.  A couple of my long-wished-for items appear on the list, such as PO Receipt Tolerance and the ability to record a prepayment on a Purchase Order.
  • Excel Export Using Open XML
  • Enable printing of SSRS report from forms
  • Navigation Lists for Web Client (BA Functionality)
  • Re-architect home pages to WPF
  • New SSRS reports to support Web Client templated forms
  • Business Analyzer WPF upgrade
  • Additional Word Templates for SOP
  • Single Email with multiple attachments
  • SRS Reports
  • Print Customer Items option
  • Select invoice on one-off Email window
  • Notes on Credit Documents
  • Document Attach
  • Item Standard Cost adjustment post to GL
  • Multi-S/N select
  • Inactivate a Site and Item Site
  • Reason Codes for stock movements/adjustments
  • Inactive Items - Inventory Status enhancements
  • Bin Transfer History
  • Tolerance Handling
  • Track Serial Numbers for Drop Ship items
  • Allow prepayments on a PO
  • Prevent PO close prior to Invoice Match
  • Print Button on Pick List Shortage Inquiry
  • Ship to Address has different Company Name
  • Relate / Link Items for suggestions on Sales
  • Integrate AA with Copier Series SOP/POP and GL Copy
  • Add Field Service Allocations to Item Allocation Inquiry Window
  • Update Back Order Quantity in Item Maintenance
  • RMA Entry - Update Contact & Address ID
  • Consolidate Revenue Recognition
  • Item Description from RMA Credit
  • Multi-User check in RMA Entry
  • Equipment Super Session
  • Hotline Update
  • RMA Return Quantity and Type
  • Ship to Address Integration to SOP
  • Cross Ship RMA consolidation
  • Honor Discontinued Item Status
  • Auto Populate Customer ID
  • Add a Contract Number search in Revenue recognition window
  • Allow contract line to be moved to another contract even if on an open service call
  • Option to have an equipment card created when manufacturing receives a serialized item into inventory
  • Contract Workflow
  • Add BAI2 format support to eReconcile
  • FA Calendar Setup
  • FA Intercompany Asset Transfer
  • FA Historical Depreciation Report
  • Lock Current FA Year and Mass Backout
  • FA to GL posting process updates
  • FA Updates for MACRS
  • Integrate Fixed Assets with AA
  • GL Journal Entry Inquiry for History
  • Reconcile Bank Reconciliation with GL
  • Year End Close Options
  • Subledger Reconcile IV to GL
  • Calculate Average Exchange Rate for Currency Translation
  • Integrate GL with encumbrance
  • Enable Enc to assign Multiple GL Budgets for Fiscal Year
  • Encumbrance Cost Diff Notification
  • Restrict Void of reconciled check, display reconcile status in Check Inquiry
  • Void of check returns applied Credits
  • Void credit card payment vendor invoice - void to original vendor
  • EFT add settlement date option
  • EFT Field Length and Delimitation Options
  • Edit Payables Transactions: Remit to Address, 1099 information, Edit Description
  • PM Reprint Checks/Remittance forms
  • Need a 1096 Form
  • Allow renaming of user-defined fields on Customer Address
  • Multicurrency apply in cash entry
  • Database multi-tenancy (named system database)
  • Application multi-tenancy
  • Report deployment and retrieval for multi-tenant
  • Multi-tenant Applications - tenant service
  • Multi-tenant Integration Manager
  • Multi-tenant web service
  • Life Insurance enhancements
  • Check Build Exception Report
  • Stop Duplicate Checks
  • Paycode History Edit
  • Paycode, Deduction, Benefit Modifier
  • FICA TSA Deductions
  • Customer Fields
  • Advanced Warning Notice and Delete History Records
  • Mandatory Arrears Template and Reminders
  • DIA Reporting
  • Voucher Description and Voucher Document Number
  • Voucher Consolidation
  • HR Calendar
  • Negative Carryover
  • PTO Detail and History
  • PTO Manual Checks
  • Year End PTO
  • Office Presence in Advanced HR, Advanced Payroll, Payroll Extensions & PTO Manager
  • HR Requisition List View
  • Consolidated Invoicing
  • Additional String Resources (Dex)
  • Key Relations tracked in index file for source control(Dex)
  • Update VBA Components
  • Enhance the AltMod windows with a mark all/unmark all functionality
  • 64 Bit Support for Email (Dex)
  • Default sort for Customer and Vendor lookups
  • Email Indicators in Transaction lists
  • Save batch approval information
  • Select Printer at time of print AND Support for http:// on the Report Destination window
  • Adding support for the Business Analyzer to NLB
  • Grouped Reports
  • SmartList Builder - remove dependency on having an Admin login after new install
  • Extender Window export/import to include Smartlist integrations
  • Add Extender & SmartList Builder Default Security

June 19, 2012

Dynamic Future - Vote - Auto deposit of Cash Receipts in Bank

This week's installment of Dynamic Future Vote features the automatic deposit of Cash Receipts.  Sounds like a brilliant idea to me!

Dynamic Future - Vote - Auto deposit of Cash Receipts in Bank


Click the link above to view Mark's article.  Click the image in his article to register your vote! 

May 30, 2012

Dynamic Future - Vote - Debits before Credits in SmartList!

Mark must stay up late at night remembering all these little annoyances that we all experience.  Here's this week's installment.  Vote early and vote often!

* click image to vote

May 1, 2012

Vote for your favorite GP enhancements

Over at DynamicAccounting.net, fellow MVP Mark Polino has hit on a great idea - again!  Every Tuesday, he's going to post a link and a short description of a GP enhancement request that appears on Microsoft Connect that he deems to be worthy.


For those of you not familiar with Connect, this is a Microsoft site that allows users to make suggestions for improvements to the software.  Users vote for the improvements they'd like to see incorporated in future releases.  The more votes a suggestion gets, the more attention it gets from GP developers.  So, here's the link to this week's installment - http://msdynamicsgp.blogspot.com/2012/05/dynamic-futurevote-unit-account-should.html.

This is your opportunity to influence the design of the product so vote early and vote often!!

April 25, 2012

4 GP MVP's Re-awarded

Congratulations to four of our esteemed colleagues for having been re-awarded MVP status for another year!
  

Andrew Anatol Karasev
Ian Stewart
Mohammad R. Daoud
Monzer Osama

Your contributions to the GP community are invaluable.

March 9, 2012

Convergence 2012 Sessions I'm Presenting


This year at Convergence, I'll be presenting three sessions, two on GPUG's DayOne and one at Convergence on both Monday and Tuesday.  Here are the links to and descriptions of the sessions in the Convergence Session Catalog -

DayOne - 13 Classic Underused Features in GP

 
DayOne - Word Up! Using Word Templates and Email in GP 2010


Ask the Experts: Financials for Dynamics GP


Hope to see you there!

February 10, 2012

Microsoft Dynamics Mayhem!!

Packt Publishing is crowning February, Microsoft Dynamics Mayhem, and celebrating its range of Dynamics books/e-books with exciting discounts.

As the leading publisher of Microsoft Dynamics books/e-books and a multitude of bestsellers on NAV, AX, GP and Sure Step, not only do these titles excel in terms of quantity, but in quality, with each book garnering numerous positive reviews. 
To celebrate this achievement, Packt has slashed cover prices by up to 30%, so go mad, go crazy and make the most of this mayhem.
Recent Dynamics publications include:

  • Microsoft Dynamics CRM 2011 New Features
  • Microsoft Dynamics CRM 2011 Dashboards Cookbook
  • Microsoft Dynamics NAV 2009 Professional Reporting

Throughout 2012, Packt will continue to build-upon this success, with a focus on branching into different forms and formats such as a Dynamics Certification series.

For further information on Microsoft Dynamics Mayhem in February, visit:

February 3, 2012

GL Trial Balance in FRx

For those of us on GP2010, Reporting Services reports provides a nice GL Trial Balance that is easy to export to Excel.  For the rest of us, we still have to print the Report Writer version to a text file, open it in Excel, then start the cleanup and reformatting.  There is an easier way using FRx.  Victoria Yudin has a great article on doing just this here - http://victoriayudin.com/2009/07/17/dynamics-gp-trial-balance-in-excel-using-frx/

 *click image to enlarge

Now, to take this one more step, if you need more of the transaction detail in your FRx GLTB, look at the additional Column Types available, such as TDESC, TJDESC, TDOC, TBAT, etc.  You can build a really sweet GLTB using FRx that easily exports to Excel.  That will make you and your auditors happy.

January 8, 2012

Convergence 2012 Early Registration Ends in 17 Days

If you plan on attending Convergence 2012 in Houston, TX this year, register now at discounted rates!  Click on the image below to register.