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