Wednesday, October 15, 2014

Oracle R12 - AP Auto Invoice Creation


1. By Using Self Billing :

By Using self Billing tab in supplier form, we can create standard invoice upon receipt.
Navigation : Payables, Vision Operations (USA) àSuppliers àEntry
Query with supplier name . Ex : Supplier Name : Consolidated Supplies
After query with supplier, click on purchasing  àSelf Billing Tab
Select Pay On = Receipt  à  This means upon completion of receipts , system automatically create the STANDARD Invoice.
System will create standard invoice automatically and invoice number generation is depends on the value entered in Profile :  PO: ERS Invoice Number Prefix

2. By Using  "Create Debit Memo from RTS Transaction" :
By using this option we can create DEBIT Invoice automatically after returning the material to supplier.
Step1 : Create PO against supplier : Consolidated Supplies and approve the PO
PO Number : 6706  --  Quantity = 10

Step 2 : Receipts
Navigation : Purchasing responsibility à Receiving àReceipts
Query with PO Number and create receipt.
Receipt Number : 6706




Step 3 : Return The material . Qty : 4
Navigation : Purchasing responsibility --> recieving --> Return 
Query With receipt = 8462
Enter Qty = 4 and Return To = Supplier  and save -- We are return 4 qty of material to supplier.

Step-4---  Run the request form Purchasing “Pay On Receipt AutoInvoice”. Open the Output to find                      the Invoice no. Then Query the Invoice No in Payables.
Now, Use below Query to find Invoices :

SELECT ph.segment1 PO_NUMBER,
       ai.invoice_num,
       ai.sourceai.invoice_type_lookup_code,
       ai.description,
       ai.invoice_amount,
       rh.receipt_num
  FROM po_headers_all ph,
       po_lines_all pl,
       po_distributions_all pd,
       rcv_shipment_headers rh,
       rcv_shipment_lines rl,
       ap_invoices_all ai,
       ap_invoice_distributions_all aid
WHERE     ai.invoice_id = aid.invoice_id
       AND aid.po_distribution_id = pd.po_distribution_id
       AND pd.po_line_id = pl.po_line_id
       AND pl.po_header_id = ph.po_header_id
       AND rl.po_header_id = ph.po_header_id
       AND rh.shipment_header_id = rl.shipment_header_id
       AND rl.po_distribution_id = pd.po_distribution_id
       AND ph.segment1 = '6047';

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect