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


Please Help Members By Posting Answers For Below Questions

Write Test Scripts for a telecummunication project on the basis of priority with some examples with regard to AP,GL,FA.

1736


What is the use of hr: user type, while configure multiorg?

708


what is the use of hr: security profile, while configure multiorg?

635


Explain Customer Creation and Maintenance Process. Provide samples of customer master records with Payment Terms.

1784


can we define 2 different currency revaluation at a time??

1906






Re: what are the Issue that we face in Gl,PO and AP while Supporting

1846


What is meaning of deprecation?

620


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.

4319


Define the activities of the Configuration Manager (AP,GL,FA) in the team. Give examples

2014


What is the Invoicing System in Oracle R12

945


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.

2293


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 .

1416


What are register in India localisation?

1578


I am created credit memo in at but while trying to complete it showing error message-hz_party_location

965


SLA usage ans how to define setups?

2174