how will you find out check no's for a particular invoice
- 3 Answers
- 7222 Views
- UST, I also Faced
- E-Mail Answers
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
what is the meaning of purchase default and what are the types
What is Difference between Auto Copy Journal and recurring journal?
How to support projects life cycles details?
Difference between header level tax calculation and line level tax calculation
What is the use of operating unit, while configure multiorg?
Hi I'm new in ERP - Oracle Application i appriciate if any one help me in this issue i need SQL to get badeget balance Acutal Balance Encumbrance Balance fund Avalable thanx ahmed
How to Reconciliation AP to CM ? How to Reconciliation AR to CM ?
what is the use of hr: security profile, while configure multiorg?
Explain about Localization (IND & US ) in Oracle Apps ?
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.
Recurring Problem Posting i have Journals for sep 2018 that i approved but they are not available to post even though the period is open in Oracle R12 Issues
can any one tell me what exactly functional consultant do on daily basis? client requirements?
Explain Customization process?
I have created an invoice and made the payment in Accounts payable. Now the payment status is Negotiable and accounting status is processed. I reconciled the transaction in Cash Mgmt, The status changed from negotiable to Reconciled in CM. I checked the payment status for the invoice in payment window(AP), the payment status changed to RECONCILED UNACCOUNTED i.e correct but the accounting status is remain processed which is not the correct. I hope the transaction will be correct if the accounting status would have changed to PERTIAL . Please suggest any solution for the above query.
What is the Process of Reconciliation Between AP to GL
