Ap Invoice Interface

At First, We should know the Interface tables and Concurrent Program for AP.

Interface Tables:

1.   Ap_Invoices_Interface.

2.   Ap_Invoice_Lines_Interface.

3.   Ap_Interface_Rejections.

Concurrent Program:

          Payables Open Interface Import.

                   This Concurrent is used to Import a record from Interface table to Base table.

Standard Process:

1.   Ap_Invoices_Interface:

a.    This Interface table stores the values of Ap_Invoices_All like ap_invoices_interface_s.NEXTVAL (Interface Invoice Id), Invoice Number, Invoice Amount, Invoice Type (Standard, Debit Memo), Vendor Information and Invoice Source.

b.    If we want to match an Invoice with PO. Add a PO Number.

2.   Ap_Invoice_Lines_Interface:

a.    This Interface table stores the values of Ap_Invoice_Lines_All and Ap_Invoice_Distributions_All like ap_invoices_interface_s.CURRVAL (Interface Invoice Id), ap_invoice_lines_interface_s.nextval (Interface Invoice Line Id), Line Type Lookup Code, Line Amount and Dist Code Combination Id (Code combination Id).

b.    If we want to match an Invoice with PO. Add Line Number, PO Number, PO Line ID, Quantity, Receipt and Receipt Line Number.

3.   Ap_Interface_Rejections:

This table stores the information what are the record rejects after Payables Open Interface Import Ends.

Standard Invoice:

Step 1: Insert an record in Ap_Invoice_Interfaces like

Insert Into Ap_Invoices_Interface

            (Invoice_Id, Invoice_Num, Invoice_Amount,

             Invoice_Type_Lookup_Code, Vendor_Id, Source

            )

          Values (Ap_Invoices_Interface_S.Nextval, 'Standard-INV01',1000,

             'STANDARD', 24011, 'MANUAL INVOICE ENTRY'

            );

Step 2: Insert into Ap_Invoice_Lines_Interface

        Insert Into Ap_Invoice_Lines_Interface

            (Invoice_Id,Invoice_Line_Id, Line_Type_Lookup_Code, Amount,

             Dist_Code_Combination_Id

            )

     Values (Ap_Invoices_Interface_S.Currval,Ap_Invoice_Lines_Interface_S.Nextval,'ITEM',1000,

             2119);

Step 3:

          Commit;

Step 4:

          Run the Payables Open Interface Import Program.

Parameters:

After Completes the Concurrent Program. The output will come like this,

Standard Invoice with Matching Po:

Step 1: Insert an record in Ap_Invoices_interfaces

       Insert Into

Ap_Invoices_Interface        (Invoice_Id,Invoice_Num,Invoice_Type_Lookup_Code,Po_Number,Invoice_Amount,Source)

Values       (Ap_Invoices_Interface_S.Nextval,'STDINV002','STANDARD','10312500339',20,'MANUAL INVOICE ENTRY');

Step 2: Insert an line information in Ap_Invoice_lines_interface

        Insert Into

Ap_Invoice_Lines_Interface     (Invoice_Id,Invoice_Line_Id,Line_Number,Line_Type_Lookup_Code,Po_Number,Po_Line_Id,

        Amount,Quantity_Invoiced,Receipt_Number,Receipt_Line_Number)      

        Values  (Ap_Invoices_Interface_S.Currval,Ap_Invoice_Lines_Interface_S.Nextval,1,'ITEM','10312500339',295026,

        20,2,'10312600238',1);

Step 3:

         

          Commit;

Step 4:

          Run the Payables Open Interface Import Concurrent. Then see the Output like this,

Debit Memo Invoices:

a.    Same Procedure for Debit Memo Invoice also, the difference is amount should be in Negative in Both Header and Lines Information.

b.   If we want to create a Debit Memo with Matching PO. In the lines information Quantity Invoiced should be in Negative.

Insert Into Ap_Invoices_Interface (Invoice_Id,Invoice_Num,Invoice_Type_Lookup_Code,Po_Number,Invoice_Amount,Source)        Values

        (Ap_Invoices_Interface_S.Nextval,'DBINV001','DEBIT','10312500339',-10,'MANUAL INVOICE ENTRY');       

Insert Into Ap_Invoice_Lines_Interface (Invoice_Id,Invoice_Line_Id,Line_Number,Line_Type_Lookup_Code,Po_Number,Po_Line_Id,

        Amount,Quantity_Invoiced,Receipt_Number,Receipt_Line_Number)      

        Values

(Ap_Invoices_Interface_S.Currval,Ap_Invoice_Lines_Interface_S.Nextval,1,'ITEM','10312500339',295026,

        -10,-1,'10312600238',1);

Thank You.