I am afraid there is no Collection Manager on the Analysis menu in the Canadian version that I know.  You might have been reviewing features from the UK, US, South Africa, etc. version of Sage 50.

Technically you can set up a collections letter from the MS Office Documents Word or Excel documents but you would need to know something about VBA programming and the Sage 50 database to accomplish this properly.  The current customer-based Word documents do not have the amounts owing.

I would go to the Customer Statement form and look at altering it.  You can enter some standard text (as long as you don't try to put too many database fields within the text) for the letter by Adding Text fields and maintaining the fields at the bottom of the Final Page to help you identify what is still owing.

Then just print/email it as a customer statement.

There are ways to do this outside of Sage 50 but it requires add-on programs (including Excel as one option) and knowing how to interact with the data.

Hi Sarahw25,

Thanks for reaching out. Are you asking about Customer Statements related to A/R? See Reports > Receivables

Hope this helps!
Erzsi

Thank you for your reply.  Altering the customer statement form would be a good work-around.