Posts

Showing posts from March, 2021

Query to find supplier that not having site in oracle r12

Image
 query to find supplier that not having site in oracle r12 select ASU.vendor_name from AP_SUppliers ASU                         --AP_SUPPLIER_SITES_ALL ASSA                         where ASU.VENDOR_TYPE_LOOKUP_CODE='VENDOR'                          and ASU.vendor_id NOT in (select vendor_id from ap_supplier_sites_all)

Type of Prepayment in Oracle Apps R12

Image
 Prepayment Invoice In Oracle R12:- It's an advance amount paid by the Organization to supplier on purchasing of any item. Later it will adjust against purchase invoice. A prepayment is a type of AP invoice you can enter to make an advance payment to a supplier or employee. Example:- You need to pay a deposit on a lease, or pay an employee an advance for medical or travel expanse. You can later apply the prepayment to one or more AP invoice or expanse reports you receive form suppliers or employees to offset the amount paid to them. Pre-Payment Types in R12 Payables:- There are two types of Prepayments        1. Temporary Prepayment         2. Permanent Prepayment 1.  Temporary Prepayment:- Temporary Prepayment can be applied to invoice or expanse reports you receive. suppose we have make advance payment to supplier for some good after receive goods and its AP invoice  from supplier, we have to applies the prepayment to AP invo...