Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals

statements done in groups or individually

Sage 50 general help forum - Free help and support for all general issues
Post Reply
zonkolooney
User
User
Posts: 31
Joined: 05 Dec 2012, 17:01
Sage Version: v2009 15 UK/Europe/Africa

statements done in groups or individually

Post by zonkolooney » 04 Jan 2017, 12:29

Hi there.

I received some very valuable help in the past and was hoping somebody might help me sort a niggly problem with me emailing statements to customers. I am hoping that it may just be a simple setting that I am not aware of.

With your help I have developed my statements to what I consider a very clear and successful layout.

The one problem I am having is where I try do do the statements as a group it simply concatenates all the statements onto one email. Is there a way to send individual statements to their respective saved emails or do I need to keep doing them individually.

SORRY - I should have included the following details - Sage Version is 15.01.20.0191 Accounts Professional 2009

Thanks in advance
Peter

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4631
Joined: 28 Feb 2006, 09:56
Sage Version: v28 UK/Europe/Africa

Re: statements done in groups or individually

Post by brucedenney » 04 Jan 2017, 15:45

It is a setting in the report in the email settings.
emailsetup1.3[1].JPG
Change email should contain from "Entire Report" to whichever grouping you want to have it split into, I suspect you want "ACCOUNT_REF"
Login to access the files attached to this post.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.

zonkolooney
User
User
Posts: 31
Joined: 05 Dec 2012, 17:01
Sage Version: v2009 15 UK/Europe/Africa

Re: statements done in groups or individually

Post by zonkolooney » 04 Jan 2017, 16:06

As always - PURE GENIUS from the maestro!!

Thanks again Bruce

Best wishes for the New Year,
Peter

anidealtit
User
User
Posts: 1
Joined: 23 Jan 2017, 10:24
Sage Version: v2017 23 UK/Europe/Africa

Re: statements done in groups or individually

Post by anidealtit » 23 Jan 2017, 10:29

Hi brucedenney, I have a similar problem when sending customer invoices:

I am using Outlook 2010 and Sage 50 Accounts version 23.0.3.140. I have attached a screen grab of my email settings in report designer.

We have a customer account set up called CASH and it is for all COD customers, therefore we don't want all the invoices to be emailed to one email address. I used to click 'email' on a range of invoices and they would be in separate emails in outlook, now they are all combined into one.

Any help would be much appreciated.

Danny.
Login to access the files attached to this post.

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4631
Joined: 28 Feb 2006, 09:56
Sage Version: v28 UK/Europe/Africa

Re: statements done in groups or individually

Post by brucedenney » 24 Jan 2017, 16:17

In that case you want to group by each invoice.

The email address will be one that you have stashed in the invoice as there is only one email address on the customer record.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.

Post Reply

Who is online

Users browsing this forum: No registered users and 20 guests