Description:
All accounting performed before transfer to the GL. Accounting data generated and stored in “Accounting Events” tables before transfer to GL.
Run “Create Accounting” to populate accounting events (SLA) tables. User can “View Accounting” only after “Create Accounting” is run. Create Accounting process.
– Applies accounting rules
– Loads SLA tables, GL tables
– Creates detailed data per accounting rules, stores in SLA “distribution links” table
SELECT SUM (xal.accounted_cr), SUM (xal.accounted_dr), aia.invoice_amount,
invoice_num
FROM ap_invoices_all aia,
ap_invoice_payments_all aipa,
ap_checks_all aca,
xla.xla_transaction_entities xte,
xla_ae_headers xah,
xla_ae_lines xal,
gl.gl_import_references gir,
gl_je_lines gjl,
gl_je_headers gjh
WHERE 1 = 1
AND aia.invoice_id = aipa.invoice_id
AND aipa.check_id = aca.check_id
AND aca.check_id = NVL (“SOURCE_ID_INT_1”, (-99))
AND xte.entity_code = ‘AP_PAYMENTS’
AND xte.application_id = 200
AND xte.entity_id = xah.entity_id
AND xah.ae_header_id = xal.ae_header_id
AND xal.gl_sl_link_id = gir.gl_sl_link_id
AND xal.gl_sl_link_table = gir.gl_sl_link_table
AND gir.je_header_id = gjl.je_header_id
AND gir.je_line_num = gjl.je_line_num
AND gjl.je_header_id = gjh.je_header_id
AND aia.invoice_num = ‘INVNO4567’ –Invoice Num
GROUP BY aia.invoice_num, aia.invoice_amount
Summary:
This Post explained what the steps should follow to create Query to Link AP Payments, GL, and SLA Tables: R12 AP GL XLA.
queries?
Do drop a note by writing us at doyen.ebiz@gmail.comor use the comment section below to ask your questions.
