In the GL30000 table all the records have duplicated, and the table contains exactly 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. I know we can get the records out, remove the dupes and re-import the table, but looking for a better way. Is there a way to do this through a SQL statement?
Thanks in advance for the help!
We need to remove the duplicates. I know we can get the records out, remove the dupes and re-import the table, but looking for a better way. Is there a way to do this through a SQL statement?
Thanks in advance for the help!