Track Invoice (AP/AR) transferred to GL

[abbas9001]

Hi All

How can I trace invoice(AP/AR) that is transferred to Gl



AP - GL

AP_INVOICES_ALL
AP_INVOICE_DSITRIBUTIONS_ALL
AP_ACCOUNTING_EVENTS_ALL
AP_AE_HEADERS_ALL
AP_AE_LINES_ALL
GL_IMPORT_REFERENCES
GL_JE_LINES


AR - GL


ra_customer_trx_all
ra_customers
AR_PAYMENT_SCHEDULES_all
ra_customer_trx_lines_all
RA_CUST_TRX_LINE_GL_DIST_all
ar_cash_receipts_all
ar_receivable_applications_all
GL_IMPORT_REFERENCES
GL_JE_LINES

Appreciate your help.

Regards,
Abbas

[karthikeyanp1981]

From the table names i can see that you are in Release 11 version.

For Payables,

You want to Find out an invoice whether it is transferred to GL or not.

The best way to find it out is by checking the table AP_AE_HEADERS_ALL where you can find a column called GL_TRANSFER_FLAG , if this has a value Y - It is transferred , E - errored , Blank or N - Not transferred

now AP_AE_HEADERS_ALL does not contain the Invoice number or the invoice id. It only has ACCOUNTING_EVENT_ID.

Since you have asked for invoice, you can get the invoice id of the accounting event id from the table AP_INVOICE_DISTRIBUTIONS_ALL.

If you want to know the invoice number, then based on the invoice id you can find it from the table AP_INVOICES_ALL


In short,
AP_AE_HEADERS_ALL = You get Accounting event ID
AP_INVOICE_DISTRIBUTIONS_ALL = Put the accounting event id and get the Invoice ID
AP_INVOICES_ALL = Put invoice id and get invoice number

[hiszaki]

Hi Abbas

You can also use the standard request in AR Un-posted items. it show the items which doesn't transfer to GL & the reason.

Thanks
Hisham