Draycir Support

If Invoices have been archived into a logical folder structure on a file server, whether using Spindle Document Distribution's PDF archive functionality or using any other method, they can be attached to the email when the statements are sent out. 

For example, let's imagine the invoices are archived via Spindle Document Distribution to a folder such as : 

\\server\archives\AB001\Invoices\Inv 0000234.pdf

(where AB001 is the account number and 0000234 is the invoice number)

To attach these files to the Statement, we need to specify the attachment directory in the statement header:

##ATTACHDIR \\server\archives\[Account.Reference]\Invoices ##  

note: We have to specify the account reference using the ERP's report designer syntax. 

In Sage 200's report writer we need to double any backslashes as a single backslash is interpreted by the report designer as a command to interpret the next character as a literal. The Sage 200 Expression would look as follows:

"##ATTACHDIR \\\\server\\archives\\" + SLCustomerAccounts.Reference + "\\Invoices ##" 

Then, in the transaction detail section, we add the ##ATTACH...## command

##ATTACH INV [Reference].pdf##

Sage 200 commands

Of course, we want to set this label to as small a font size as we can (2pt) and close up the detail band:

Finally set the text foreground colour to white (note: NOT Transparent).