Recent Posts

Hi

This area of the reporting system allows a lot of flexibility to add custom additional criteria to your reports, but this really will only be successfully used with the assistance of our support team - the SQL language is one that database developers use to build complex queries on the database.

In wrangar's case, you can achieve this with "normal" criteria selection - you can select

"Payment Date" is "Between" 01/12/2009 and 31/12/2009

this is on the normal criteria selection for the report.

Make sure that your report selection and date range includes invoices for November, and includes "paid" invoices

Hope this helps

Forum Admin

Me too!  I can't find a single example of an "SQL WHERE" statement.  SQL is pretty easy to work in, but not without an example.  Did you happen to figure it out?  Does anybody else have an example they could share with me?

Thanks!

Hi There

Just to let you know currently Bulksms are selling 1000 sms @ £44 + VAT. 2000 sms @ £86 + Vat. currently Boomsms costs £90 + VAT for 1200 sms. i am unsure on how reliable bulksms are but they do appear more cost effective, at least in my opinion.

We would like to email some of our clients with a promotion offer which is like a poster, how do I put this into the email from the activity report, does it have to be saved as a HTML as our email is just set up as standard from out outlook express.  It is a jpeg document
Thanks ever so
Lozza

I don't think there is a way to repeat each day, but once you have set up one week it is easy to repeat this week as often as you like.
so to set up future weeks, just pick a week from the past and copy / paste it, or choose to repeat.

Hope this helps
RJF

Hi,

Please does anybody know if there is a way of simply repeating the same start and finish time of each day without having to set up each day individually?

Thanks 

you can raise credits by putting a negative amount in the 'units' on the raise a charge. Trouble is you cannot allocate this!!  any ideas on that bit let me know

Thanks Kate

I realised soon after that you raised negative charges for discounts and credits, and neg payments for refunds - I think she spoke to someone about it all. I should have updated this post but only got notified a short while back 

you can raise credits by putting a negative amount in the 'units' on the raise a charge. Trouble is you cannot allocate this!!  any ideas on that bit let me know

yes - raise a charge - just type the description - put the full amount in unit cost - put a negative 20% in units ie for 20% input -.2
works but is a pain that it cannot be done automatically on the total

You need to alter the template for the invoices.  Support Line will help.