Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Ask: List PO
11-08-2013, 02:59 PM,
#1
Ask: List PO
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?..



Reply
11-11-2013, 12:38 AM,
#2
RE: Ask: List PO
(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??




Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)