View Full Version : Date order of invoices on Statements
irbrenda
02-23-2007, 06:13 AM
Am I doing something wrong? When I print a statement for a customer, the dates of the invoices in the DATE column are mixed up. I need them in chronological order, from earliest to latest date. i.e. I have the first outstanding invoice dated 6/26/06, then 2/13/2007, then back to early '06, back to '05, and then it ends with 8/22/06. Is there a way to change the print order? Customers are very confused when the look at the statement and I agree, it is odd. Thank you.
NancysBL
02-24-2007, 04:11 AM
It should run in date order...I would run a rebuild and see what happens. There is no other "reset" of sorts.
Joe Williams
02-24-2007, 04:57 AM
If you run a Custom Transaction Detail report filtered for Account=AR and Name=the customer, do they apper in date order, The report may be better if you are trying to gert a list of transactions for a year or longet period.
irbrenda
02-24-2007, 09:09 AM
It should run in date order...I would run a rebuild and see what happens. There is no other "reset" of sorts.
I thought it's odd not to run in date order, but after doing some research on another forum where the same question was asked, it was said that QB lists things in transaction order and then date order and that's the reason it is not chronological. I can't believe that it's hard enough to give my customer an invoice that lacks details they are looking for, but it's worse to give them a disordered statement along with their current invoice.
I will try to run a rebuild but I'm curious as to whether others who use the statements which lists several outstanding invoices for a customer have the same date order problem.
Thank you and I'll let you know the results of the rebuild.
irbrenda
02-24-2007, 09:31 AM
that causes the dates to print out of order. It does this on 3 computers that run QB Pro 2004, so a rebuild will not make a difference.
I'm not a bookkeeper by any means but I do the best I can for my husband's electrical contracting business.
Let's say I have one main customer with many jobs that I do for him in various buildings. I first set up the main customer, and then for each job he gives me regardless of the building, I do "Add Job". So for argument's sake I now have Customer A with 10 jobs in different buildings, I see those 10 jobs listed under Customer A. I go to create one statement for Customer A which now shows all 10 buildings with their outstanding invoices, but those dates are all out of order on the statement, just as I detailed in my original post above. Why is that happening? Or is that the way it's supposed to show up?
If I create a statement for EACH building with its respective outstanding invoices, those invoices ARE in date order.
Any thoughts? Thanks again.
vBulletin® v3.8.4, Copyright ©2000-2013, Jelsoft Enterprises Ltd.