(11-08-2013, 02:59 PM)kelo Wrote: Hallo,
i have been searching about how to listing
all Purchase order that already invoiced but has not been paid without
looking into a supplier one by one but did not have a clue, any help?..
Hello,
maybe i misplaced this thread, should be on development..
i have experimented on mysql query
SELECT *
FROM purchorderdetails
INNER JOIN purchorders on purchorderdetails.orderno=purchorders.orderno
INNER JOIN supptrans on supptrans.supplierno=purchorders.supplierno
where supptrans.settled=1
group by purchorderdetails.orderno;
is this query is right to select all Purchase order that has been invoiced but not yet been paid??
how d you all think??