web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Dynamics GP table recr...
Microsoft Dynamics GP (Archived)

Dynamics GP table recreate without affecting the data

(0) ShareShare
ReportReport
Posted on by Community Member

In Dynamics GP (RM_Customer_MSTR) table is there i want to add new field and recreate the table but without affecting existing data how could i do this once i add the new field that should be added as blank column. plz tell the solution (I am new for Dynamics GP)

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Tim Wappat Profile Picture
    Tim Wappat 5,711 on at

    From your question I think you are asking if it is possible to add a new column to the RM00101 table (customer master) that will be for your use, and how to do this without corruption of the exiting data in the table?

    It is not normal practice or advisable to alter the default Dynamics GP schema. This can end up with no end of problems when running upgrades or damaging performance.

    Instead create another table with the same key to keep your custom information in. You can also use the DUOS table that is used for ad-hoc extra data.

    blogs.msdn.microsoft.com/.../creating-sql-views-of-duos-data

    Tim.

  • Andrew Hall Profile Picture
    Andrew Hall 190 on at

    Hi Like Tim says, you should not be creating extra columns in the tables. this will cause the upgrade process to fall over and will make your system unsupportable. you can store the extra data in Duos tables as Tim suggests however depending on what data you wish to store against the customer master it might be simpler to use one of the user defined fields, if not already in use, these have the added advantage of being able to be referenced in the filters in the system and reports without the need for extra coding.

  • sandipdjadhav Profile Picture
    sandipdjadhav 18,306 on at

    If user defined fields are not enough and need more fields then create custom table and use to store your additional data.

  • Tim Wappat Profile Picture
    Tim Wappat 5,711 on at

    And then there is always our friend, the product extender that makes the adding of extra fields very easy and a power user driven task.

    Tim.

  • Community Member Profile Picture
    Community Member on at

    thanks for replay me Tim Wappat. I saw the table which u suggest (SY_User_Object_Store (SY90000)) in SSMS its empty. can u proper guide me how to use that table.

  • Suggested answer
    Tim Wappat Profile Picture
    Tim Wappat 5,711 on at

    Hi,

    The link I provided in the previous post is to an article that explains the schema, its essentially a property bag.

    You just need to give your object a name of your choosing for ObjectType, Object ID is the key to the record you want to link to -such as Sales order number, customer number etc

    Property name is a name of your choosing for the item you want to store, then the PropertyValue is a string version of the property value you wish to store. 

    Column   Description   Example Values  
    ObjectType Used to describe what the Collection of data relates to   Prospect Information  
    ObjectID Stores the Key field value(s) for the object in the Collection  APASUPPLY0001
    PropertyName Used to describe the Property being stored  ProspectLevel
    Email 
    PropertyValue String representation of the data being stored  3
    Test@test.com 

    Tim.

  • Suggested answer
    David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 14,095 Most Valuable Professional on at

    You cannot change an existing table definition. While it is technically possible to do it in SQL, it is not supported by Dexterity and will cause issues especially when doing upgrades.

    You need to either use an existing field (like a user defined field), or store your data in a separate table. You can either use a parallel table (table with same primary key and your additional fields), or the DUOS (Dynamic User Object Store SY90000) table.

    You can also use a tool like eOne's Extender, but this will put the additional fields in a separate window.

    What tool are you planning to use to make your customisation as this can influence which method is best to use.

    David

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans