| Query for Invoice price [message #486262] |
Tue, 14 December 2010 09:31  |
mahendraabc
Messages: 12
Registered: October 2000
|
Junior Member |
|
|
What's query to check amount/invoice price for a particular transaction ?say for ex :I'ce created order and with a line item with unit price of $300 and tax :$11 so total amount is $311.once invoice is created I want to check invoice quantity and invoice price for the same order(1 each,$311).What's the query to get that?
Thanks,
Mahender
|
|
|
|
| Re: Query for Invoice price [message #486566 is a reply to message #486262] |
Thu, 16 December 2010 14:58  |
 |
Alien
Messages: 292
Registered: June 1999
|
Senior Member |
|
|
Hi,
I assume you're talking about procurement (AP and PO). In that case you're describing the standard 2 way matching process. eBS does that for you already.
If you want to do it yourself, I'll give you a hint. The tables are PO_LINES_ALL, PO_DISTRIBUTIONS_ALL, AP_INVOICES_ALL and AP_INVOICE_DISTRIBUTIONS_ALL.
Regards,
Arian
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
