x Want to participate? Join the group to interact
  • State Suggested Answer
  • Replies 2 replies
  • Answers 1 answer
  • Subscribers 241 subscribers
  • Views 1102 views
  • Users 0 members are here
Browse Forums
Sage 100 Contractor Announcements
119
topics
57
replies
Sage 100 Contractor General Discussion
1k
topics
4k
replies
Sage 300 CRE Announcements
168
topics
526
replies
Sage 300 CRE General Discussion
3k
topics
9k
replies
Sage Construction Management Announcements
4
topics
0
replies
Sage Construction Management General Discussion
16
topics
21
replies
Sage Estimating Announcements
39
topics
3
replies
Sage Estimating General Discussion
189
topics
448
replies
Guybor

change attachment location in AP

SUGGESTED
Posted By

We just changed our storage server and in the process "simplified" where we scan AP invoices.

The problem is, the links in AP are now pointing to a non-existent location.  Is there a way to redirect the file location?  Or, where is this info stored in the Database....I'm not opposed to going in and writing a script to change the file location link directly in the DB.  But I couldn't find which table held this info.

Thank you in advance.

Parents
  • 0
    SUGGESTED

    Guybor,

    If you did not move your Accounting Data and only moved the storage of your attachments, you could use the Migration Tool to update the paths but would require using it twice.  It's a challenge to say in this scenario which would be faster, to use the migration tool (twice), or to use MS Access with a SQL Query.

    If you want/need to use Access with a SQL Query, you can identify which tables at least a couple of ways.

    1. Open every table within your Company folder and search for the 'File Links' field at the end of the record.  Each table that contains a File Link field will have it named slightly differently.
    2. Open/Review the Data Dictionary for your Company folder (this can be accessed through Report Designer under Tools > Available Fields.  Depending on your needs, you can select specific tables (or more likely in this case all of them) and I like to save the output to a pdf file.  You can then search for "Note".  If found as the last Field on the table it should have a Links field as well (the Links field will not show in the Data Dictionary, but the Notes and Links are both tabs in the same window when accessed from within Sage 300 CRE).

    Todd Baker

    Sage 300 CRE Consultant

Reply
  • 0
    SUGGESTED

    Guybor,

    If you did not move your Accounting Data and only moved the storage of your attachments, you could use the Migration Tool to update the paths but would require using it twice.  It's a challenge to say in this scenario which would be faster, to use the migration tool (twice), or to use MS Access with a SQL Query.

    If you want/need to use Access with a SQL Query, you can identify which tables at least a couple of ways.

    1. Open every table within your Company folder and search for the 'File Links' field at the end of the record.  Each table that contains a File Link field will have it named slightly differently.
    2. Open/Review the Data Dictionary for your Company folder (this can be accessed through Report Designer under Tools > Available Fields.  Depending on your needs, you can select specific tables (or more likely in this case all of them) and I like to save the output to a pdf file.  You can then search for "Note".  If found as the last Field on the table it should have a Links field as well (the Links field will not show in the Data Dictionary, but the Notes and Links are both tabs in the same window when accessed from within Sage 300 CRE).

    Todd Baker

    Sage 300 CRE Consultant

Children
No Data

*Community Hub is the new name for Sage City