duplicate record problem with additionalnotesdetail table

This topic contains 11 replies, has 3 voices, and was last updated by Raymond 4 months ago.

Viewing 12 posts - 1 through 12 (of 12 total)

Author
Posts
September 19, 2018 at 1:24 pm #64236

Raymond
Participant
The additionalnotesdetail table is a mess. I have one customer with 10 notes (NoteID values of 0 through 9) but OpenSync has created 5,208 records with those same 10 NoteID numbers repeated hundreds of times each. To be clear, the problem is with all customers, not just one customer.
My guess is that the problem is due to the fact that the table doesn’t have a primary key. Each customer (IDKEY) should only have one entry in the table for each NoteID value.
Perhaps if you used a composite primary key from NoteID and IDKEY fields?
September 28, 2018 at 2:50 pm #64277

Yudel Rosales
Keymaster
Which version of OpenSync and QuickBooks are you using?
September 28, 2018 at 3:08 pm #64283

Raymond
Participant
QuickBooks Enterprise 18 and OpenSync 3.0.18.
I did see that version 3.0.19 is available but it appears to be a minor upgrade with just 2 bug fixes—unrelated to my problem.
October 9, 2018 at 12:46 pm #64333

Raymond
Participant
I hate to be a pest but this seems like a pretty easy fix—add a primary key to the table to avoid creating duplicate records.
Thanks.
October 19, 2018 at 12:12 pm #64392

Raymond
Participant
This same customer has now grown to 6,308 records in the additionalnotesdetail table despite having only 10 unique Notes!
The table has nearly 60,000 records in total which exceeds the size of any other table and just keeps growing.
November 2, 2018 at 1:38 pm #64493

Raymond
Participant
Is anyone looking into this problem?
December 3, 2018 at 1:42 pm #64670

Raymond
Participant
Can I get an update on this problem? Thanks.
January 8, 2019 at 5:14 am #64764

Yair
Participant
All this “Addional” tables are a mess i never used them.
If I was you I would remove it from the list of table syncs and use other fields that are more reliable.
like Memo field. seem to work well.
January 8, 2019 at 12:51 pm #64767

Raymond
Participant
I have to use it because my users have notes in the QuickBooks additionalnotesdetail table that they want me to access.
January 12, 2019 at 10:48 am #64824

Yudel Rosales
Keymaster
We will work on that for the next version. Sorry for the trouble on this table.
January 14, 2019 at 2:45 pm #64832

Raymond
Participant
Great. Looking forward to the fix.
Thank you.
July 9, 2019 at 6:12 pm #65563

Raymond
Participant
Hello, Yudel.
It’s been almost six months. Any update?
Thanks.
Ray
Author
Posts

Viewing 12 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic.

OpenSync