Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Dex Row Time Stamp on PM30200

Posted on by Microsoft Employee

When does the field DEX_ROW_ID get populated or updates?

I have some transactions having DOCDATE and POSTEDDT of May 2018 but the DEX_ROW_ID has November 19, 2018.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Dex Row Time Stamp on PM30200

    My apologies, I meant to type DEX_ROW_TS

  • Suggested answer
    Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: Dex Row Time Stamp on PM30200

    The DEX_ROW_ID does not get updated as it is an identity column. Once a record is inserted in a table, the identity value is assigned and immediately increased to be used with the next record that gets inserted. You can read more about DEX_ROW_ID in my article dynamicsgpblogster.blogspot.com/.../dexrowid-column.html

  • Verified answer
    Lucas Miller Profile Picture
    Lucas Miller on at
    RE: Dex Row Time Stamp on PM30200

    Jehan,

    There is a trigger on the PM30200, called zDT_PM30200U, that sets a record's DEX_ROW_TS to the current date any time that record is updated.  

    The only time I've really seen this field used is in the Dynamics Connector, which would use it to know when a record was changed in GP so it could include or exclude it in the records being migrated to Dynamics CRM based on the date filters you've setup.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,151 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,993 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans