A customer had a request to merge all Service Call data into another company database and although I recommended against this they wanted it so I merged some 40+ tables. I had to provide new EQUIPID values as those values already existed in the original company along with new index links to accounts, etc.
My issue remains with the notes and attachments. I think I have most/all of the text notes properly displaying but the attachments are another story. Some of the attachments are there but when I copied the notes from the ole notes\company folder to the new company there were some duplicates. Most of the attachments that link to the Service Call are there but those linking to the Item Number appear to be missing or the link is broken.
What does the value in the Notes_Array_1, Notes_Array_2, etc field link to? I cannot find these values in the SY03900 table. I can see noteindx of 146928.00000 but then in the array_1 is see 146929.00000 and array_2 = 146930.00000.
Anyone have any ideas on this?
Thanks much,
Dave
*This post is locked for comments
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,219 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156