Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Ask: List PO
11-08-2013, 02:59 PM
Post: #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?..
Find all posts by this user
Quote this message in a reply
11-11-2013, 12:38 AM
Post: #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??
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)