2.7.2.5. AIM PaperClip

 
How are attachments stored in Sage 300 CRE?
 
There is a single field in every ‘attachable’ record in Sage 300 CRE.
 
 
 
This one field stores a list of the file paths of all attachments.  Each member of the list (path) is separated from the next member by the ‘pipe’ character:  |
 
 
 
Why do we Need Paperclip?
 
  • The Invoice_File_Links field is quite large and can accommodate an almost infinite number of files when written to within Sage 300 CRE.
  • HOWEVER, when written to via ODBC, there is a max limit of 1000 characters.
  • With the power of AIM, we saw fairly quickly that clients were bumping up against the 1000 character limit and getting attachment errors.
  • We needed a way to get around that limit.
  • What we write now is a separate link to the AIM Paperclip viewer which opens in a new window.
 
 
 

The help manual was created with Dr.Explain