another blog

Icon

About Microsoft Dynamics GP :-)

This datatype name is already in use.

Few days back I got a small task of increasing length of field Dependent SSN of window Employee Dependents.User could only enter 9 characters on this field although the storage size of this field is 16 characters.After checking field properties I just realized that the format assigned to the field is actually not allowing it to enter 15 characters. I just opened the window in modifier and tried to change the format to new one so could allow max of 15 characters, but got the error “This datatype name is already in use”.ddn1

So I checked the dictionary from which this window originates and found it in Human Resources. So I checked the field which is using this data type.

dssn

And then check other fields in Employee Maintenance window, there I found social security number and check that in modifier. and check the field definition. So it has the same data type which the other field from HR module is using.

ssn

ssn1

So I went back to Dynamics GP, and instead of going to modifier by selecting the option ‘Modify current window’, I go to modifier by Tools>>Customize>>Modifier and  then selected the product ‘Microsoft Dynamics’.

Then from Resources selected the Data Type and then open ‘STR15_Social_Security_Number. And change the format of datatype, this time it’s allow me to save the change without any warning. 🙂

final

Filed under: Dynamics GP, dynamics-gp, Modifier, , , ,

Enter your email address to follow this blog and receive notifications of new posts by email.

Enter your email address to follow this blog and receive notifications of new posts by email.

3rd party database access 3180 adding CR in text field Adding NULL values in dropdown Adding Sample Company Data Adding Symbol to Currency fields Alternate Window Analytical Accounting Attachments cancel button Can I ... Carriage Return chunk CH_SPACE CMMTTEXT Cross Dictionary Dexterity Development Cross Dictionary Triggers Currency Symbol in Dynamics GP windows Damo Data for Dynamics sample company Datatype dex DEX.DIC dexterity Dexterity Currency field Dexterity Dropdown Dexterity finditem() Dexterity Triggers DEX_ROW_TS Dict_GetPathname() Dynamics GP Dynamics GP Posting Issues Finding GP Field finding specific field in tables Finding Table Focus Trigger FP: Script not found errors GETUTCDATE() great plains Grid How to identified product related to error. hyperspace Hyperspace property of dexterity field. Increasing Field Size of Dynamics GP Table INFORMATION_SCHEMA.COLUMNS Link Format Selector Microsoft Dynamics Error Modified Reports Modifier MOP_Order_MSTR Path_MakeNative() Path_SelectPathname() Posted receipts not showing on Enter Match Invoice window.Enter Match Invoice window. Project Accounting For Dynamics GP Reading Folder Redisplay Refill Report Destination Sales Transaction Entry Scroll Sanscript Saving Images Script Error Script Not Found Session access denied SmartList Favourites SQL Script to Find column in tables SQL_Execute SUSER_SNAME() TextFile_ReadLine() TextFile_WriteLine() The SELECT permission was denied on the object "XXX" transaction entry User access Using SQL in Dexterity VBA for Dynamics GP You may not edit this document . it is being edited by another user.

Enter your email address to follow this blog and receive notifications of new posts by email.

Freddys blog

Learn something new... - then Teach someone!

حلقۂ دام خیال

عالم تمام حلقۂ دام خیال ہے

M@ria

~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*

Ghostriver Studios Blog

Sculptural stained glass of Andrew Kosorok

Dynamics GP Builders & Reporting

How to use MS Dynamics SmartList Builder, Excel Report Builder and other Reporting tools to get the data and analysis you need.