how will you find out check no's for a particular invoice
Answers were Sorted based on User's Feedback
Answer / srinivask
Payment 'document numbers' displaying in the payment window.
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / egyprogramer
In the invoice form > go to tab 4 View Payment and here you
will find all Payments for this invoice
Is This Answer Correct ? | 2 Yes | 1 No |
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 |
why we use segment and flex field qualifier what is the difference between flexfield and segment qualifiers
Trial balance can run which level, legal entity level or operating unit level.
Tell me steps for Period closing Process in AP?
What are the important setup in cash management for reconciled the payment ?
what is the difference between balance, account, none (automatic offset methods)?
what is the diffrence between 11i and R12 ?
hi friends i am a B.com Commerce Graduate, completed in the year 2006. i have good knowledge in oracle General Ledger, Accounts Payable, Cash Management. i have basic Knowledge in Accounts Receivables and Fixed Assets, i dont have experience in oracle financials, but i have 3 years of experience in Accounts. After learning oracle i am very much confused that will i be eligible to get job in oracle or not. i got adviced from many consultancies and councellors about this matter , few of them advice me to search oracle job and few are'nt . please advice me to what to do .
What is the difference between 11I AND R12?
How is the GL Date derived by AutoInvoice process? Any set-ups?
what is MOAC?
2 Answers ABC, Ness Technologies,
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 difference between position hierarchy and employee hierarchy in purchasing module?