PA Supplier Invoice Audit

Description

Categories
Enginatics, R12 only
Repository
GitHub
AP invoices charged to projects showing vendor, invoice, cost distribution, and GL transfer details for supplier expenditure audit.

SQL 55 lines

Parameters 5

ParameterTypeList of values SQL
Operating UnitLOV
haouv.name=:operating_unit
ProjectLOV
ppa.segment1=:project_number
VendorLOV
aps.vendor_name=:vendor_name
GL Date FromDate
pcdla.gl_date>=:gl_date_from
GL Date ToDate
pcdla.gl_date<:gl_date_to+1