Hi to all
I am going to create invoice and save it, then validate it, then perform accounting, and then Transfer to GL, after this it does not show the data in the table of Account Payable Like;
<b>AP_ACCOUNTING_EVENTS_ALL
AP_AE_HEADERS_ALL
AP_AE_LINES_ALL</b>
i cant resolve this problem
Please tell me the Problem why the data is not populated in these tables and how it is possible to populate data in these table
Can any body help me out of this problem
subledger accounting setup is set as standard accrual.
Data is not showing in AP_ACCOUNTING_EVENTS_ALL
-
- Posts: 114
- Joined: Fri Feb 29, 2008 12:35 am
- Location: Pakistan
-
- Posts: 615
- Joined: Mon Sep 18, 2006 1:32 am
- Location: United Arab Emirates
- Contact:
<b>Use following Query You can Get Accounting For Invoices</b>
SELECT xal.ae_header_id, xal.ae_line_num, xal.displayed_line_number,
xah.event_id, xah.completion_acct_seq_value,
NVL (xte.source_id_int_1, -99), xal.accounted_cr, xal.accounted_dr,
xal.accounting_date
FROM xla.xla_transaction_entities xte, xla_ae_headers xah, xla_ae_lines xal
WHERE xte.entity_id = xah.entity_id
AND xte.application_id = xah.application_id
AND xah.ae_header_id = xal.ae_header_id
AND xah.application_id = xal.application_id
AND NVL (xte.source_id_int_1, -99) = &invoice_id
AND xte.application_id = 200
AND xte.ledger_id = '2021'
AND xte.entity_code = 'AP_INVOICES'
AND xal.accounting_class_code = 'LIABILITY'
SELECT xal.ae_header_id, xal.ae_line_num, xal.displayed_line_number,
xah.event_id, xah.completion_acct_seq_value,
NVL (xte.source_id_int_1, -99), xal.accounted_cr, xal.accounted_dr,
xal.accounting_date
FROM xla.xla_transaction_entities xte, xla_ae_headers xah, xla_ae_lines xal
WHERE xte.entity_id = xah.entity_id
AND xte.application_id = xah.application_id
AND xah.ae_header_id = xal.ae_header_id
AND xah.application_id = xal.application_id
AND NVL (xte.source_id_int_1, -99) = &invoice_id
AND xte.application_id = 200
AND xte.ledger_id = '2021'
AND xte.entity_code = 'AP_INVOICES'
AND xal.accounting_class_code = 'LIABILITY'
Who is online
Users browsing this forum: No registered users and 34 guests