In part 2 of the series , I delivered a brief primer on the service architecture in Microsoft Dynamics GP 2015 and how you are able to consume services natively created with Dexterity. There are two types of services that can be created: services that wrap existing windows and forms functionality, i.e., creating a customer; and services that can wrap around existing sanScript procedures, i.e, retrieving customer information.
Wednesday, October 15, 2014 After a jammed pack Academy Training day on the previous day, Summit Day 1 begins with a little stroll from my hotel down to the America’s Center Convention Complex . On the way there, I cannot help but to snap a picture of the now very famous Runner Fountain at Kiener Plaza, which happened to be running a pink to red tone in support of the Cardinals
The table below lists the various products that are commonly available on the Dynamics GP install DVD media. I got this list originally from the Dynamics GP worksheet prepared by Microsoft. Product ID Product 0 Dynamics 1 Dexterity 258 Project Accounting 309 Fixed Assets 346 Manufacturing 414 Human Resources 949 Field Service 1042 Interfund Management 1045 Revenue Expense Deferrals 1058 Cashbook (Bank Management) 1150 Scheduled Installment 1157 Collections Management 1235 Safe Pay 1428 Electronic Reconcile 1493 SmartList 1632 Cash Flow Management 1838 Technical Service Tools 1878 Excel-Based Budgeting 1911 HRM Solution Series 2150 Payment Document Management 2199 Business Activity Statement 2277 Purchase Order Enhancements 2416 Control Account Management 2547 Enhanced Commitment Management 2788 Enhanced Intrastat 2992 CopierSeries 3096 VAT Daybook 3104 Advanced Security 3180 Analytical Accounting 3258 Encumbrance Management 3278 Report Scheduler 3830 SmartList Builder 4067 ML Checks 4421 Grant Management 4522 Payroll Integration to Payable 4612 Advanced Go Tos 4621 Analysis Cubes for Excel 4933 Certification Manager 4955 Employee Health and Wellness 5597 HITB Report 5967 Fixed Assets Enhancements 5982 Export Financial Data 6499 Dynamics Online 6831 Date Effective Tax Rates 7131 Canadian Payroll 8811 Direct Debits & Refunds If you look in the ‘upgrade’ section of Customer/PartnerSource, a worksheet is available that includes the products and their various build numbers
One of the new features in GP 2013 R2 is the Microsoft ribbon command layout that we are familiar with in Microsoft Office products. It’s kinda cool that this familiar interface is now part of Dynamics GP, even though it takes up more real estate in the window and takes some time to get used to as opposed to the previous icon shapes and positioning.
The SOP Entry window pictured above has been modified to bring the Description up to the first line. This made the window quite wide, but my goal was to get as much of the description visible as possible. The expanded view looks almost the same as the original, except I added the Item Code field as can be seen below: If you would like a copy of this modified window for yourself, you can download the package file containing this window here: https://app.box.com/s/z2sujz9pu62jbybhxb4b This is a GP2013 R2 window
5 years back I have published a script that allows you to view amount in words in Arabic, what we call it “TAFQEET”, the article is published under the following link: http://mohdaoud.blogspot.com/2008/10/convert-numbers-to-arabic-words-tafqeet_5647.html I been getting many requests across the years on how to make this works for Excel and my answer was always that you cannot make it as it is an SQL based function and not a VBA. This morning I have see a comment sharing me a video that shows how to make a simple VBA script to achieve the ENGLISH amount in words and the video is below: https://www.youtube.com/watch?v=fYAxYtzBi5A Moving forward I decided to make the same for ARABIC language considering that I have a script that works on .NET does the same and all what I need to do is to make this works for Visual Basic for Applications and the result is below: 1. Download the function from the following path: http://www.di.jo/files/DI.bas If that file was viewed and not downloaded, please right click and click “Save Target AS”.