web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

database merge and note attachments

(0) ShareShare
ReportReport
Posted on by 1,141

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

I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans