Go Directly To
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
Get Started Guide
Join the world’s largest interactive community dedicated to Oracle technologies.
Learn from thousands of community experts
Get answers to your technical questions
Share your knowledge with peers
Please enter a title.
You can not post a blank message. Please type your message and try again.
Enterprise Resource Planning (ERP)
This discussion is archived
on Nov 3, 2009 1:20 PM by SachinAhuja
Invoice Interface- Amount remaining on a PO
Nov 2, 2009 9:39 PM
Hi- I am doing a small AP interface for invoices. Before I bring invoices in, I want to check if the line amounts exceed the amount remaining on the PO.
Where do I get the amount remaining on a PO? Is this in a column somewhere? I would think on the header, but there doesn't seem to be info on this.
Can anyone help?
I have the same question
Show 0 Likes
This content has been marked as final.
Show 1 reply
Re: Invoice Interface- Amount remaining on a PO
Nov 3, 2009 1:20 PM
in response to
Can't columns QUANTITY_ORDERED, QUANTITY_DELIVERED & QUANTITY_CANCELLED from PO_DISTRIBUTIONS_ALL Table help you.