This content has been marked as final. Show 4 replies
You can use following query to find out such cases . Hope it helps
select RSH.RECEIPT_NUM,RCV.INVOICE_STATUS_CODE from rcv_shipment_headers rsh,
AND RSH.receipt_num in(
FROM ap_invoices_all ai,
WHERE ai.org_id="enter org_id"
AND ai.invoice_date >'enter date'
AND NOT EXISTS
FROM ap_invoice_distributions_all adi
But i think, we dont need to join ap_inoices_all with ap_batches. Also your query is eliminating the invoices which has disributions(in our case all invoices will have distributions)
But thanks a lot for sharing this query. I Made some modifications in that to work for me.
I have developed this query for one of my requirement . My Purpose is to give u the details of tables that should use to find out such cases ,
We have issue with Uninvoiced Receipts Report for 2 period some POs are not included in Oct period but those are included in Nov period. i have to fine the reason.
can you send me the Uninvoices invoice which developed and aslo advice me on this issue.