dlgoodchild Posted October 15, 2010 Share Posted October 15, 2010 Hi, On the main page (home screen) once you login there is a section at the top that shows statistics: Active Clients Unpaid Invoices Overdue Invoices Pending Transfer Domains Suspended Services Uninvoiced Billable Items Valid Quotes The unpaid Invoices, overdue invoices and others are inaccurate and are all out by 2. I.e. unpaid invoices shows 8, I click on it, and only 6 show. How can I correct this? Thanks, Dave. 0 Quote Link to comment Share on other sites More sharing options...
Vumes Posted October 30, 2010 Share Posted October 30, 2010 I have the exact same problem. Anyone? 0 Quote Link to comment Share on other sites More sharing options...
othellotech Posted October 30, 2010 Share Posted October 30, 2010 how many record does the query: select * from tblinvoices where status"Unpaid"; return ? 0 Quote Link to comment Share on other sites More sharing options...
dlgoodchild Posted November 10, 2010 Author Share Posted November 10, 2010 Turns out the results from that command showed 2 records where userid=0 ...dunno how that happened? Thanks for pointing me in the right direction! Dave. 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.