Tuesday, 15 July 2014

AP invoice cycle

Text Box: When Invoice Validated : (AP_INVOICE_DISTRIBUTIONS_ALL) Text Box: When Invoice Booked and Saved (AP_INVOICES_ALL)                                                                                                                                                                                                                                                                                                                                                                                                                                                         
                                                                                                         
 


                                         Invoice_id                                             

Text Box: ap_accounting_events_all one row created at the time of validation of invoice 1.EVENT_STATUS_CODE='CREATED' 2.SOURCE_TABLE='AP_INVOICES' 3.SOURCE_ID = apa.invoice_id                                                                                     
                                                                                    accounting_event_id                     
Text Box: ap_accounting_events_all EVENT_STATUS_CODE='ACCOUNTED'
 









                                                                      accounting_event_id
 



                                                                                      accounting_event_id
 





                                                                                                                              AE_HEADER_ID
Text Box: ap_ae_lines_all (Two Rows are CREATED) AE_LINE_TYPE_CODE SOURCE_TABLE CHARGE à AP_INVOICE_DISTRIBUTIONS LIABILITY à AP_INVOICES
 









Invoice_id
 





                   Check_id
Text Box: one row is created in ap_accounting_events_all EVENT_STATUS_CODE='ACCOUNTED'. When payment got accounted the one row created with ap_accounting_events_all.source_id=AP_INVOICE_PAYMENTS_ALL.check_id and AP_INVOICE_PAYMENTS_ALL.source_table='AP_CHECKS'
Text Box: When Payment Accounted (AP_invoice_payments_all) After Doing the Payment (paid) of invoice with Created Payment Document(payment_status_flag='Y) It creates the linking between ap_invoices_all and ap_checks_all by AP_INVOICE_PAYMENTS_ALL.one row created in AP_INVOICE_PAYMENTS_ALL with reference of invoice id.
 


Text Box: Create Invoice (AP_INVOICES_ALL)                                                                  accounting_event_id                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  Text Box: After Clearing Check from cash management open payment document and create accounting for it. after successfull accounting of the document: one line is created in AP_PAYMENT_HISTORY_all with new accounting _event_id. AP_PAYMENT_HISTORY_all.accounting_event_id= ap_accounting_events_all.accounting_event_id one new line created in ap_accounting_events_all with EVENT_TYPE_CODE='PAYMENT CLEARING' and AP_INVOICE_PAYMENTS_ALL.source_table='AP_CHECKS' ap_accounting_events_all.source_id=AP_INVOICE_PAYMENTS_ALL.check_id and AP_PAYMENT_HISTORY_all.accounting_event_id= ap_accounting_events_all.accounting_event_id one row created in AP_AE_HEADERS_ALL with new accounting_event_id and two rows in this case created in ap_ae_lines_all with AE_LINE_TYPE_CODE='CASH CLEARING ' AND 'CASH',SOURCE_TABLE='AP_CHECKS'.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 Text Box: AP_INVOICE_DISTRIBUTIONS_ALL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 Text Box: Invoice link to XLA (xla_distribution_links)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 Text Box: AP_INVOICES_ALL                                                                                                                                                                                                                                                invoice_id                                                                        applied_to_source_id_num_1                                                                                                                                                                                                                                                   source_distribution_id_num_1                                                                                                                                                                                                                                                                                                          invoice_distribution_id            

XLA to GL  
 ========
apps.xla_ae_lines.gl_sl_link_id = gl_import_references.gl_sl_link_id



When Posted in GL (GL_POSTING)
===============================
after running the request "Payables Transfer to General Ledger".The ap_ae_lines_all.GL_SL_LINK_ID populates.AP_AE_HEADERS_ALL.GL_TRANSFER_FLAG='Y'AP_AE_HEADERS_ALL.
GL_TRANSFER_RUN_ID IS NOT NULL AP_AE_HEADERS_ALL.TRIAL_BALANCE_FLAG='Y'
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

CREATING A SUPPLIER IN R12 (Functional and SUPPLIERS IN TCA)

Who is a Supplier? Let us now understand who is a Supplier with the help of a simple example: We consider us as a business, who sell...