Call Us Today
1.877.838.9273

• How to Buy
• Contact Us
• Member Login

Home AVImark Forum Newbies Running specific report

	AVImark Forum :: Newbies
	Board Index Latest Posts Welcome Guest
	Subject :Running specific report.. 07-26-2010 09:28:57
	PattiGoldenview New User Joined: 07-22-2010 05:34:02 Posts: 4 Location:  Is it an option to run a report to see the $$ generated on a specific day of the week for the entire year? As we are trying to decide about shortening/lengthening hours, it would be helpful to see how much is generated on each day of the week (can we do ACT by the day of the week?). thanks. IP Logged
	Subject :Re:Running specific report.. 07-26-2010 19:19:17
	Jeremy-AVImark Advanced User Joined: 02-11-2009 12:49:44 Posts: 693 Location:  Patti, If you are on version 2010.4, you can go to Work With, Information Search, click Cancel on the Search Library, click View, Code Editor, delete any information in the window, copy the text below, paste it into the Code Editor Window, and click OK. I have it set up to search for Wednesday, but you can change the value in Date, Day of the Week, on the Search Criteria tab to any day you want (1-Monday and 5=Friday.) search [Client] code 'M$JSB013' name 'Amount per Day of the Week' category 'MSS Searches' ( [Account-Date] datecalc day of the week equals '3' and [Account-Account Type] equals 's,t' and [Account-Date] is greater than 't-365' ) report ( [Account-Amount] summary (sum), [Account-Date] summary (distinct) ) If you are on an older version, you can still get a Sum by Day of the Week, and it would be best to give technical support a call to walk you through the search. IP Logged This posting has been authorized by McAllister Software Systems, LLC and was written by Jeremy Bennett, Client Relations Manager
Page # 5101520253050100All

Mss rewards