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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Dex Row Time Stamp on PM30200

(0) ShareShare
ReportReport
Posted on by

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

I have the same question (0)
  • Verified answer
    Lucas Miller Profile Picture
    Microsoft Employee on at

    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.

  • Suggested answer
    MG-16101311-0 Profile Picture
    26,225 on at

    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

  • Community Member Profile Picture
    on at

    My apologies, I meant to type DEX_ROW_TS

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
HP-11021721-0 Profile Picture

HP-11021721-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans