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

Report Designer / Prevent Sage from printing statements for customers with an email address

Sage 50 general help forum - Free help and support for all general issues
Post Reply
andygeorge80
User
User
Posts: 4
Joined: 05 Nov 2015, 12:25
Sage Version: Other

Report Designer / Prevent Sage from printing statements for customers with an email address

Post by andygeorge80 » 05 Nov 2015, 12:29

Please help,
I have two statement designs saved, one which I have formatted to only send to customers with an email address. However the other one is for printing statements and I can't find a way of preventing it printing statements to customers who have an email address. I'm sure this is something simple to do but I don't know how to, can anyone help me please. Thanks in advance Andy.
Top
andygeorge80
User
User
Posts: 4
Joined: 05 Nov 2015, 12:25
Sage Version: Other

Re: Report Designer / Prevent Sage from printing statements for customers with an email address

Post by andygeorge80 » 05 Nov 2015, 13:31

Version 20.04.09.364
Top
User avatar
brucedenney
Site Admin
Site Admin
Posts: 4664
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Re: Report Designer / Prevent Sage from printing statements for customers with an email address

Post by brucedenney » 05 Nov 2015, 13:31

It is the antithesis of filtering to print only if there is an email address.

Typically the filter expression would be

SALES_LEDGER.E_MAIL = ""
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.
Top
andygeorge80
User
User
Posts: 4
Joined: 05 Nov 2015, 12:25
Sage Version: Other

Re: Report Designer / Prevent Sage from printing statements for customers with an email address

Post by andygeorge80 » 05 Nov 2015, 13:55

Thanks, but I want to print if there isn't an email address
Top
Rufus1983
User
User
Posts: 12
Joined: 08 May 2014, 11:55
Sage Version: v2013 19 UK/Europe/Africa

Re: Report Designer / Prevent Sage from printing statements for customers with an email address

Post by Rufus1983 » 05 Nov 2015, 14:39

The filter expression given by Bruce looks for any record which does not have a value in the SALES_LEDGER.EMAIL field on the customer record, so should pick out any customers which do not have an email address recorded.

You can also use the following filter expression, which I use for my statements:

SALES_LEDGER.E_MAIL NOT LIKE "%@%"
Top
andygeorge80
User
User
Posts: 4
Joined: 05 Nov 2015, 12:25
Sage Version: Other

Re: Report Designer / Prevent Sage from printing statements for customers with an email address

Post by andygeorge80 » 05 Nov 2015, 14:44

YOU ARE AMAZING!!! Thank you so much for your time.
Top
Post Reply

Return to “Sage 50 UK version General Help”

Who is online

Users browsing this forum: No registered users and 1 guest