Payable to GL transfer
Hi,
We have some invoices that are not transfered to GL.
I identified them with query
select distinct trunc(api.creation_date) ,api.invoice_num,aid.posted_flag,api.org_id,aid.accounting_event_id,s.request_id,cp.concurrent_program_namefrom ap.ap_invoice_distributions_all aid,ap.ap_invoices_all api,AP_AE_HEADERS_ALL s,fnd_concurrent_programs cpwhere api.invoice_id=aid.invoice_id and s.accounting_event_id = aid.accounting_event_idand s.program_id = cp.concurrent_program_idand s.period_name = 'oct-13'Now probkem is this in the table
Tagged:
1