Vijay Akumalla

• Dec 8th, 2006

 

AutoInvoice is the interface where Customer Invoices are generated. Source of Invoices is Order Management, PA.

Interface tables: ra_interface_lines_all. Table stores Invoice Line level details.

Ra_interface_distributions_all. Accounting distribution of each invoice.

Once records are inserted into ra_interface_lines_all, run the Autoinvoice interface from AR. If any errors occur, it can be found in ra_interface_errors_all table. The concurrent has 2 stages. First the Master program fires which intern kicks of Import Program. Once this is completed, data is inserted into the following tables.

1) ra_customer_trx_all (Invoice Header Info)

2) ra_customer_trx_lines_all (Invoice Line Level Info)

3) ra_cust_trx_line_gl_dist_all (Accounting Info. One record for each Account Type is inserted into this.. ex. Receivable, Revenue, Tax, Freight etc)

4) ar_payment_schedules_all (All Payment related info)

gsrikanthvarma

 Profile Answers by gsrikanthvarma 

• Jun 4th, 2008

 

this is the standard program through which the data from interface table RA_interface_lines_all will be pulled into oracle receivables on making the validations on various feilds.batch source will play major role in this transferring of records. the pulled records will be reflected in
1. ra_customer_trx_all(invoice header)
2. ra_customer_trx_lines_all(invoice line)
3. ra_cust_trx_line_gl_dist_all (Accounting Info)
4. ar_payment_schedules_all (payment)

nilanjanthacker

 Profile Answers by nilanjanthacker 

• Jun 21st, 2010

 

The two interface tables needed to be populated for running the auto invoices are
RA_INTERFACE_LINES_ALL and
RA_INTERFACE_DISTRIBUTIONS_ALL

Later, the auto invoices will hit the following tables
RA_CUSTOMER_TRX_ALL  -- CUSTOMER_TRX_ID*
RA_CUSTOMER_TRX_LINES_ALL  -- CUSTOMER_TRX_LINE_ID*
RA_CUST_TRX_LINE_GL_DIST_ALL  --  PAYMENT_SHEDULE_ID*
RA_BATCHES_ALL  --BATCH_ID
RA_CUST_TRX_LINE_SALESREPS_ALL  --
AR_RECEIVABLE_APPLICATIONS_ALL  --  RECEIVABLE_APPLICATION_ID*
AR_PAYMENT_SCHEDULES_ALL    --  PAYMENT_SCHEDULE_ID*
RA_INTERFACE_ERRORS_ALL  --

* indicate primary keys