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

Re: While you are in implemenation what are u faced the issues ? tell me what some ap & GL issues?

1959


Explain Customization process?

1500


I have a requirement where during the consolidation into USD (from GBP books) I want use two different exchange rates for two consolidations. Child SOB is same but the Parent SOB's are different. How can this be done in Oracle Financials? Answers will be Appreciable. Thank You.

1466


What is gap analysis, what are the pre-requisities?

748


We have both consumption tax and With Holding Tax on each invoice, will there be any conflict involved?

1565






Payables Applications Technical Reference Manual

2040


What is the db number of a particular customer TCA?

932


1.what is the name of program to create invoice automatic from po.? 2.How to auto upload the bank statement? 3.PO tax has not flown to invoice . why? Debit memo not generated for return of goods.??

2971


what is the difference between before pages trigger and after parameter trigger in reports ?

1963


How to do the analysis of discounts lost and fixing the root cause?

645


What is the meaning holding tax?

671


I am currently working in reputed Org as a Oracle apps end user (AR). Learned R12 functional course, but no real time exp as in support or implementation project.Please guide. thank you.

1631


difference between tds and income tax (India)

1380


I am working on PPR process to print checks. Currently the checks are printing for each supplier, supplier site and payment method group. My requirement is the invoice level one DFF is available (like A and B are the input values). Please let me know how include this DFF at invoice grouping level.

1136


explain your project plan with exam pal? i am preparing inter view .............

1959