You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Date an Invoice is Accounted (Posted to the GL)

edited Apr 25, 2019 1:45PM in Reporting and Analytics for ERP 3 comments

Summary

Date an Invoice is Accounted (Posted to the GL)

Content

I need to build a BI Publisher report for accounted invoices that includes the date an invoice was accounted.  I'm aware that I can use AP_INVOICES_PKG.GET_POSTING_STATUS(INVOICE_ID) = 'Y' to determine if an invoice is accounted.  Is there a similar package/API to get the date an invoice is accounted?  If not, what table stores this date?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!