Finance | Project Operations, Human Resources, ...

DEX_ROW_TS updating unexpectedly for many records at once

(0) Share

Report

Posted on by DinB

3,951

What could cause DEX_ROW_TS to be updated for many records at once in IV00101 table? for example 3000 records have exactly same value in DEX_ROW_TS. The MODIFDT field has not changed. It does not seem to be due to manual editing. and it is strange they all have exactly same value in DEX_ROW_TS

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

David Musgrave MVP ... 14,095 Most Valuable Professional on at

Like (1)

Report

Did you run some sort of update statement. .... even if it updated to the same value, it would cause the trigger that updates the timestamp to run.

If performed at the SQL level it would have all been one transaction which would give everything the same datetime value.

If the update had a where clause so it only updated records that needed changing, it would not have been so heavy handed.

That's my thoughts.

David

Was this reply helpful? Yes No
Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

Din,

Agree with David, any integration that would have updated the IV00101 table in SQL would have caused to trigger the DEX_ROW_TS timestamp field, as long as the row as affected by it.

Was this reply helpful? Yes No