R12 - AP Auto Invoice Creation

Hi friends,

Today we will see how to allow system to create invoice automatically upon reciept.

1. By Using Self Billing :

By Using selg Billing tab in supplier form, we can create standard invoice upon receipt.

Navigation : Payable responsibility --> Suppliers --> Entry

Query with supplier name . Ex : Supplier Name : Consolidated Supplies

After query with supplier, clisk on purchasing  --> Self Billing Tab

Select Pay On = Reciept  --  This means upon completion of reciepts , system automatically create the STANDARD Invoice.

System will create standard invoice automaticaly 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 : 6047  --  Quantity = 9

Step 2 : Reciepts

Navigation : Purchasing responsibility --> recieving --> Reciepts

Query with PO Number and create reciept.

Receipt Nimber : 8462

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.

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_numFROM
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 aidWHERE ai.invoice_id = aid.invoice_idAND aid.po_distribution_id = pd.po_distribution_idAND pd.po_line_id = pl.po_line_idAND pl.po_header_id = ph.po_header_idAND rl.po_header_id = ph.po_header_idAND rh.shipment_header_id = rl.shipment_header_idAND rl.po_distribution_id = pd.po_distribution_idAND ph.segment1 = '6047';