TODO: Change the footer's content in Project Settings : HTML (CHM) Export : Setup HTML Template and Layout
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.
