Yearly invoice total

Manager SE Reports & printing
Locked
Jimmyjon
Member
Posts: 7
Joined: Wed Mar 06, 2013 11:32 am

Yearly invoice total

Post by Jimmyjon »

I am looking for a report that singles out every invoice total excluding one customer. I need a report on every one else but the car dealer I do work for.
User avatar
MRISICH
200 Club: Major Contributor
200 Club: Major Contributor
Posts: 255
Joined: Tue Jul 18, 2006 3:49 am
Location: Chalfont, PA
Contact:

Re: Yearly invoice total

Post by MRISICH »

If you are running Manager SE and are using Report Pro (http://www.m1propack.com) you can use the query builder, that is built in to get this information very easy.
Michael Risich
Founder & CEO

BOLT ON TECHNOLOGY™

610-400-1019
http://boltontechnology.com/
User avatar
Rich
4K Ultra Amazing Contributor
4K Ultra Amazing Contributor
Posts: 4043
Joined: Tue Sep 06, 2005 10:16 am
Location: Somewhere in Michigan
Contact:

Re: Yearly invoice total

Post by Rich »

Are you wanting this listed by invoice or customer?
Rich Hays
Work 9-11 or 616-696-0020
Being able to get CAPE off a Skew T chart is important in this hobby.
User avatar
Rich
4K Ultra Amazing Contributor
4K Ultra Amazing Contributor
Posts: 4043
Joined: Tue Sep 06, 2005 10:16 am
Location: Somewhere in Michigan
Contact:

Re: Yearly invoice total

Post by Rich »

I guess look at this and see if it works.

Reports, accounting, invoice profit summary.

MAKE SURE THE BOX IN THE TOP RIGHT "report to" is set to SCREEN. or you may waste a ton of paper.

See if that works. It shows up in numerical order by invoice.
Rich Hays
Work 9-11 or 616-696-0020
Being able to get CAPE off a Skew T chart is important in this hobby.
User avatar
Rich
4K Ultra Amazing Contributor
4K Ultra Amazing Contributor
Posts: 4043
Joined: Tue Sep 06, 2005 10:16 am
Location: Somewhere in Michigan
Contact:

Re: Yearly invoice total

Post by Rich »

or try

Reports, accounting, Posted totals by invoice #
Rich Hays
Work 9-11 or 616-696-0020
Being able to get CAPE off a Skew T chart is important in this hobby.
User avatar
MRISICH
200 Club: Major Contributor
200 Club: Major Contributor
Posts: 255
Joined: Tue Jul 18, 2006 3:49 am
Location: Chalfont, PA
Contact:

Re: Yearly invoice total

Post by MRISICH »

Open Report Pro - Click on Tools Tab

Then Click Query Builder:
Report Pro - Query Builder Button
Report Pro - Query Builder Button
Report_Pro_QueryBuilder_Button.png (4.88 KiB) Viewed 3049 times
Then add a new definition; simply double click the fields that you want to add:
Report Pro - Query Builder - Year To Date Definition
Report Pro - Query Builder - Year To Date Definition
Report_Pro_QueryBuilder_CustomerYTD.png (22.97 KiB) Viewed 3049 times
Michael Risich
Founder & CEO

BOLT ON TECHNOLOGY™

610-400-1019
http://boltontechnology.com/
User avatar
Johnny5
500 Club: Champion Contributor
500 Club: Champion Contributor
Posts: 654
Joined: Wed May 26, 2004 2:03 pm
Location: John Dwulet

Re: Yearly invoice total

Post by Johnny5 »

Run the report 'Customer Activity Report' found un the Client tab. Select the date range you wish, subtract the dealer total contained in that report from the grand total.
John Dwulet AKA: Johnny5
Retired - Mitchell1
Locked

Return to “Reports + Printing”