AP Invoice Payment Accounting Tacking

 

Select *

from ap_invoice_payments_all

where invoice_id=10033;                --CHECK_ID=10228, ACCOUNTING_EVENT_ID=51758

Select *

from ap_checks_all

where CHECK_ID=10228;            --CHECK_NUMBER=29151

Select *

from ap_payment_schedules_all

where invoice_id=10033;

Select *

from xla_ae_headers

where event_id=51758;                --AE_HEADER_ID=16698

Select *

from xla_ae_lines

where AE_HEADER_ID=16698

and ACCOUNTING_CLASS_CODE='LIABILITY';     --GL_SL_LINK_ID=25983,                      CODE_COMBINATION_ID=1015

Select *

from gl_import_references

where GL_SL_LINK_ID=25983;            --JE_HEADER_ID=8161, JE_LINE_NUM=2

Select *

from gl_je_headers

where JE_HEADER_ID=8161;

Select *

from gl_je_lines

where JE_HEADER_ID=8161

and JE_LINE_NUM=2;                --PERIOD_NAME=Feb-11

Select *

from gl_balances

where period_name='Feb-11'

and CODE_COMBINATION_ID=1015;            --5169750.52

Select sum(NVL(ACCOUNTED_DR,0))dd

from gl_je_lines

where period_name='Feb-11'

and CODE_COMBINATION_ID=1015;            --5169750.52

Sum of ACCOUNTED_DR from GL_JE_LINES should be equal to PERIOD_NET_DR of GL_BALANCES  i.e.

5169750.52          = 5169750.52