Duplicate records in history table 1

[triad66]

In the history details table within Great Plains, all the records have duplicated, and the table contains twice as many records as it should. There are two identical records for every transaction. For instance, the field "journalentry" has a value of '4567' followed by another record with the same value. All the fields are the same with the exception of a numeric field called dex-id, which is different for each record.

We need to remove the duplicates. Is there a way to do this through a SQL statement?

Thanks in advance for the help!

 

[collierd]

Have a look at faq183-2682

As you have a field which is different this should help

Damian.

 

[triad66]

Thanks for the response, Damian. This appears to be exactly what we need!