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

Setting Up a Report to E-Mail Invoices (Grouped by Client)

Report design issues and solutions.
Post Reply
iStevie
User
User
Posts: 19
Joined: 17 Jun 2011, 07:51
Sage Version: v2013 19 UK/Europe/Africa

Setting Up a Report to E-Mail Invoices (Grouped by Client)

Post by iStevie » 27 Mar 2012, 13:21

Hi,

I had read a previous post from April last year and read the guide that Bruce posted on how to set-up emailing of reports from Sage. I already e-mail reports so i know how to set it up to send but at present i am only able to send reports by manually clicking on the ones i want to be exported and repeating that process for each customer.

I have learnt from Bruces guide how to change it from "entire report" to "Invoice Number" so that it created a new e-mail for each invoice number being exported which is great but i often send upto 20 invoices at a time to each customer so i don't really want to send 20 different e-mails to each customer.

What seems like the obvious solution is to group the report by customer account reference in the same way it is setup to be grouped by invoice number? The questions is how is this done?

Any help would be very much appreciated.

Cheers,

Steve.
- Sage 50 Accounts Professional 2016 Subscription
- Sage 50 Payroll
- Sage 50 HR 2010
- Sage 50 Forecasting 2007

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

Re: Setting Up a Report to E-Mail Invoices (Grouped by Clien

Post by brucedenney » 28 Mar 2012, 10:41

You can do that, what you need to do is to alter the layout so that it has an extra account_ref grouping in addition to the invoice number grouping

This will create headers and footers , you need to move these to the very top and bottom outside the invoice header and footer. You can hide these headers and footers as the grouping will only be used for sending emails.

Not that when you print invoices using this layout rather than being printed in invoice number order, they will be printed in groups for each customer in invoice number order.
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 24 guests