Tag: article

Product ID and Product Name

| 09/09/2014 | 0 Comments
Product ID and Product Name

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

Continue Reading

Issue with Integration Manager and new Window Ribbon Layout in GP 2013 R2

Issue with Integration Manager and new Window Ribbon Layout in GP 2013 R2

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.

Continue Reading

Modified SOP Entry window

| 08/20/2014 | 0 Comments

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

Continue Reading

ARABIC & ENGLISH Amount in Words for Excel

| 08/13/2014 | 0 Comments

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”.

Continue Reading

Record the Bar Code in the Item Code field in Inventory

| 08/09/2014 | 0 Comments

  We’re all looking for fields we can use for something else without bringing the system down.

Continue Reading

Modified GL Transaction Entry Window

| 08/05/2014 | 0 Comments

Forever I’ve wanted the account description on the first line of the GL Transaction Entry window. Well now I have it! It took me all day to create, but at least now it exists. I shouldn’t be the only one who benefits from my labor, so I’m going to make it available to you.

Continue Reading

Use Tax due because Inventory was used by the company

| 08/03/2014 | 0 Comments

I had a question recently asking me if there was an easy way to record Use Tax that becomes due when inventory is used by the company. There are several existing methods to record Use Tax if you know it is due at the time of purchase, but this question applied to an existing inventory item, so those techniques are not useable. Using the procedure below will allow you to record your use tax as well as tie it back to the inventory items you put in use

Continue Reading