mssit
AVImark
Call Us Today
1.877.838.9273
AVImark Forum::Shared Information Searches::New Client first visit $$
Home AVImark Forum Shared Information Searches New Client first visit $$
 AVImark Forum :: Shared Information Searches
Welcome Guest   
 Subject :New Client first visit $$.. 09-20-2011 12:29:15 
aliciapetclinic
User
Joined: 09-15-2011 04:24:02
Posts: 5
Location
I am trying to figure out a way to run a search that pinpoint a specific referral source and how much income came in from their first visit.
For example.
Acount #
Referral Source: Google
Client added: 07/15/2011 to 09/15/2011
First Visit $ amount

Is this possible?
Thanks
-Josh
IP Logged
 Subject :Re:New Client first visit $$.. 09-28-2011 08:24:02 
Information Search Ideas
Advanced User
Joined: 10-11-2010 09:14:32
Posts: 72
Location
Josh

Hi

The following search should find the results that you are looking for.
The referral, account date, and added date can all be adjusted to meet your needs.
For the most consistent results, the added and the account date should be kept the same.
It will report the client's account number, full name, invoice date, and amount.
If this is not what you are looking for, or need further information, please let us know.


search [Client] code 'M$BB0549' name 'First Invoice by Referral'
category 'MSS Searches' (
[Client-Added] is between '07-15-11' '09-15-11' and
[Client-Referral] equals 'Google' and
[Account-Date] is between '07-15-11' '09-15-11' and
[Account-Account Type] equals 'i'
) report (
[Client-Account],
[Client-Full Name] width 30,
[Account-Date],
[Account-Amount]
) sort by (0 ascending, 2 ascending) summarize by (0)
IP Logged
Page # 


Powered by ccBoard


" We are very pleased with the software and its potential and use as we grow in the computer involvement to our hospital. "

Suzanne Hiler


Chat Hours:
Monday - Friday
8am - 5pm CST

Mss rewards

Sign up for a year of AVImark technical support and get additional discounts when you use these other services. Click Here to Learn More
MSS Data Vault MSS Pet ID McAllister Payment Solutions MSSITPetwise
Copyright © 2012 McAllister Software Systems, LLC. All rights reserved.