how will you find out check no's for a particular invoice
Answer Posted / muneer
in front end:
Payment 'document numbers' displaying in the payment window.
in back end:
> select ac.check_num
from ap_invoices_all aia
,ap_invoice_payments_all aip
,ap_checks_all ac
where aia.invoice_id=aip.invoice_id
and aip.check_id=ac.check_id
and aia.invoice_number='xxxxxxxx';
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Write Test Scripts for a telecummunication project on the basis of priority with some examples with regard to AP,GL,FA.
What is the use of hr: user type, while configure multiorg?
what is the use of hr: security profile, while configure multiorg?
Explain Customer Creation and Maintenance Process. Provide samples of customer master records with Payment Terms.
can we define 2 different currency revaluation at a time??
Re: what are the Issue that we face in Gl,PO and AP while Supporting
What is meaning of deprecation?
There is employee X and employee Y (who is supervisor of X); when Y submits expenses how will the system ensures that this should not go to X even if he has the approval authority.
Define the activities of the Configuration Manager (AP,GL,FA) in the team. Give examples
What is the Invoicing System in Oracle R12
While assigning the security by book in oracle assets..i am unable ot get the asset org in security profile form.This asset org was already defined in org description window.
HI, once we create the standard invoice then we can get journal entry item expense a/c-dr to liability a.c then item it will reflect through inventory, but liability a/c . it will reflect from GL , it is possible .
What are register in India localisation?
I am created credit memo in at but while trying to complete it showing error message-hz_party_location
SLA usage ans how to define setups?