Tag: sql server
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
Technorati Tags: gp 2013 , upgrade , cursor error Recently I did an upgrade from GP2010 to GP 2013 R2 (build 1745) and ran into a variety of problems.
A while ago I had a case where the customer was storing data in the DUOS (Dynamic User Object Store) table from a VBA (Visual Basic for Applications) customisation.
This week’s Tech Tuesday article is from our Support Guru, David Youngquist, who will walk you through how to perform a SQL trace to debug eConnect errors. 1. Find out what user the eConnect service is running under
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”.