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
Re: While you are in implemenation what are u faced the issues ? tell me what some ap & GL issues?
Explain Customization process?
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.
What is gap analysis, what are the pre-requisities?
We have both consumption tax and With Holding Tax on each invoice, will there be any conflict involved?
Payables Applications Technical Reference Manual
What is the db number of a particular customer TCA?
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.??
what is the difference between before pages trigger and after parameter trigger in reports ?
How to do the analysis of discounts lost and fixing the root cause?
What is the meaning holding tax?
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.
difference between tds and income tax (India)
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.
explain your project plan with exam pal? i am preparing inter view .............