Dashboard - Payables Due Sort - Printable Version +- webERP Forum (http://www.weberp.org/forum) +-- Forum: webERP Discussion (http://www.weberp.org/forum/forumdisplay.php?fid=1) +--- Forum: Problems / Bugs? (http://www.weberp.org/forum/forumdisplay.php?fid=8) +--- Thread: Dashboard - Payables Due Sort (/showthread.php?tid=8129) |
Dashboard - Payables Due Sort - VortecCPI - 03-10-2018 Not really a Bug or Problem but I changed the payables ("Supplier Invoices") due to sort by duedate prior to supplierid: ORDER BY supptrans.duedate, suppliers.supplierid This puts the first payment due at the top of the list, which I find helpful. I don't have any Overdue Customer Balances or Outstanding Orders so I can not check to see if it may also be applicable there. RE: Dashboard - Payables Due Sort - TurboPT - 03-10-2018 Change committed. RE: Dashboard - Payables Due Sort - VortecCPI - 05-09-2018 A few more small changes to this script... For the two SQL queries for Supplier Invoices Due within 1 Month I still have things shown a bit out of order. Changing SQL queries to have "ORDER BY supptrans.duedate" and not other fields seems to have squared it away. So now I have this... NOTE ONLY ONE ORDER BY FIELD! PHP Code: $Sql = "SELECT suppliers.supplierid, |