This content has been marked as final. Show 3 replies
The best way to check the same from front is as below..
If you know the PO number...Please query the PO in PO summary form.. Open the PO...Go to Shipment .... You will get Shippment form with 3 tabs (Shipment, More & Status)... click on status... here you will able get a clue how much qty you ordered, How much u have received, how much qty you cancelled and how much qty is billed...
Let me know if this approach is fine with you or not?
N.B : you can use below query as well
select a.segment1, a.type_lookup_code PO_type, b.line_num PO_line, c.quantity_ordered,
(c.quantity_ordered - c.quantity_delivered) Pending, c.quantity_billed Billed,
c.quantity_cancelled Cancelled, c.amount_billed Billed_amount, b.closed_code Status
from po_headers_all a, po_lines_all b, PO_distributions_all c
where a.org_id = &org_id
and a.segment1= &PO_Number
order by a.segment1, b.line_num
thanks for your reply. yes, i see in that way, but i need to see all the PO's which have incomplete receiving transactions at once like a report.
the column i need are as follows,
po number, receipt number, received quantity, accepted quantity, delivered quantity
can you provide me any query that can help me?
data in received quantity, accepted quantity, delivered quantity should be correct. can you pls suggest me what should be the consideration of return issues (return to receiving, and return to supplier)?
Edited by: Lisan on Nov 6, 2009 7:53 PM
I think you can try this report Receiving Value Report which is a standard report provided by oracle, which gives the items which are not delivered.