Featured Post

Dynamics GP 2019 is now Released

It is now released, Microsoft Dynamics GP 2019 which moves the system to the modern product life cycle   " Beginning with the October...

Monday, February 29, 2016

System Requirements for Microsoft Dynamics GP 2016

System Requirements for Microsoft Dynamics GP 2016 has been published on the customer source. Since Dynamics GP 2016 has not been released yet, these requirements are subject to change until the release of Microsoft Dynamics GP 2016.

Best Regards, 
Mahmoud M. AlSaadi

Wednesday, February 24, 2016

Rule of Thumb | Item Category Setup

An item card in Dynamics GP has associated user defined fields, which can; unlike other cards, have a predefined list of values to restrict the entry of any value. The item user defined fields can be found by going to Item Card > Options > Category Section

Item Maintenance Window > Options > Category

As shown above, each of the user defined fields has an associated lookup, in order to choose a specific value from a predefined list. When entering a new value, a pop up window will warn you to add this value to the original predefined list. 

Item Category Setup
Believe it or not, the original window from which the "values" for each of the user defined fields can be configured is kind of a mystery for some Dynamics GP users/ administrators. In order to setup the "values" for each user defined category, follow the steps below:

  1. Go to Microsoft Dynamics GP > Tools > Setup > Inventory > Inventory Control
  2. Under Category, place the mouse cursor on any of the user category
  3. Click on the arrow next to the User category title to open up the Item Category Setup Window
  4. The item category setup window opens up
Item Category Setup

It is worth to be mentioned that the item category setup table is IV40600, in which all the associated user defined values are stored. 

Best Regards, 
Mahmoud M. AlSaadi

Tuesday, February 23, 2016

Professional Services Tools Library PSTL - Item Number Combiner Error

When using the item number combiner feature of the PSTL, you might encounter an error indicating that there is an invalid object name which is DYNAMICS..syscolumns . As a result, the process is interrupted and will fail to deliver the required results. The encountered errors are included below:


Procedure TACallItemCombine
The stored procedure that is designed to manage the whole combine task is "TACallItemCombine", it is encrypted and can not be checked. The error is primarily due to having a static "SQL statement" within the code checking DYNAMICS..Syscolumns. Although, in certain environment the DYNAMICS db itself could have a different name due to the new feature of changing its name. As a result, this process will break up in the middle achieving no results at all.

Item Number Combiner

In my environment, I had Dynamics GP 2015 and the database names are as follows:
  • GP Company : GP15R
  • Dynamics Company: DYN15
Therefore, the procedure failed to find an object in a database which name is DYNAMICS, and eventually fail. 
In order to work this out, I have created a dummy database with the name 'DYNAMICS', just to force the procedure to proceed since it is encrypted and can not be altered.

Best Regards,
Mahmoud M. AlSaadi