Sunday, June 24, 2012

What do you expect from Dynamics GP 2013??


I been looking around the blogosphere an noticed an awesome article by Frank Hamelly simply summarizing new features of Dynamics GP 2013, I am sure that you are very much excited to check what that could be therefore I have copied them all, sorry Frank for the infringe of your copyrights! but I wanted to bold features that is useful for customers in my region, blow is the list:

  • 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

Mohammad R. Daoud MVP - MCT
+962 - 79 - 999 65 85

Microsoft Dynamics GP Excel Paste is now Online


Production version of Microsoft Dynamics GP Excel Paste is now released and the development team has updated the website to integrate PayPal!

Download Fabrikam copy now or purchase your company version now from the below link:

Below is the pricing table for the tool:

Core Financial Modules (GL, CM, DTA) 350$
Accounts Payables and Receivables (AR, AP) 300$
Sales Order Processing (SOP) 400$
Purchase Order Processing (POP, POR, POE) 400$
Inventory Control (IV, IVC) 300$
Payroll (UPR) 300$
Full Package – All Modules 1,300 $


Mohammad R. Daoud MVP - MCT
+962 - 79 - 999 65 85

Wednesday, June 20, 2012

Excel Paste for “Any Screen” in Microsoft Dynamics GP


Last few days, we have released a tool to paste data from Excel into Dynamics GP GL Transaction Entry form and published the tool for all users with no charge.

From that day, the development team in DI has decided to go further with this and tried to enhance the dynamicity of the tool to go beyond what we have developed and develop a tool for sale but worth payment, so end users can define the paste path and how to paste columns in Dynamics GP.

In addition they wanted to make this for all GP forms not only GL Transaction Entry, and going from there below what we have developed.

If you would like to watch this live on what we have done using excel paste for forms with scrolling windows, please take a look into the following video:

Purchase Order Excel Paste

So what if you do not have scrolling window and you want to paste from excel into “Cards”? We have included this we well! Check below video on how to paste customers:

Customer Card Excel Paste

Initially, users will need to analyze what fields need to be included in the paste operation, for example let us take the purchase order screen as an example:


I have picked the integration path that I need on the screen and been ready to setup my Excel Paste using the following setup screen:


End user will be able to define what they just analyzed using the above screen, they just select Form Name, Window Name and start selecting fields one by one.

Once finalizing the setup, copy data from an excel like the below:


And just paste on the purchase order screen:



Mohammad R. Daoud MVP - MCT
+962 - 79 - 999 65 85

Saturday, June 16, 2012

Dynamics GP Journal Entry: Paste From Excel–Free Add-in

This morning, I been in my company with the team and been discussing what kind of innovations we should think of next, specially after delivering the first version of data level security for partners out of the kitchen for Quality Assurance and testing!

While reviewing articles published by the community leaders, we have noticed an article by Mark Polino discussing a product enhancement to have the ability to paste from excel into General Transaction Entry form, and we liked the idea and started the development!

Below is our outcome:

Paste from Excel

And in writing, you will need to request a DLL from Dynamics Innovations by sending a mail to me (temporary until publishing the file) you just need to click on the below link and download the tool, then place the DLLs in your AddIns folder:

Go to excel and create a new excel to look as the below:


Copy data from this excel and get back to Transaction Entry window of Dynamics GP, go to additional >> Paste From Excel, or press on CTRL + F and enjoy!

Update: While testing the tool we have noticed the below:

1. Distribution reference column is required, you will need include the column while copying even if the column was empty.

2. Tool was not accepting empty cells in credit and debit columns, it was modified to work.

3. Tool has been merged with paid version and published over the company website.

Mohammad R. Daoud MVP - MCT
+962 - 79 - 999 65 85

Related Posts:

Related Posts with Thumbnails