Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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.

2280


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

2367


How to Reconciliation AP to CM ? How to Reconciliation AR to CM ?

1854


encumbrence set ups?

2545


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

2390


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.

1618


What are register in India localisation?

2006


Do you track and record relationships between customers e.g. franchises, subsidiaries etc.?

2108


What is the db number of a particular customer TCA?

1350


What is the use of gl set of books name, while configure multiorg?

1092


what is the meaning of purchase default and what are the types

2223


SLA usage ans how to define setups?

2701


Explain about Localization (IND & US ) in Oracle Apps ?

3141


Provide an overview of AR cash receipt processing.

2609


What is the Invoicing System in Oracle R12

1409