CAC AP Accrual IR ISO Match Analysis

➜ Back to Library
XMLXML import file

Description

Categories
Enginatics, R12 only
Repository
GitHub
Use this report to match the A/P Accrual entries for internal order inventory receipts with the internal order payables invoices, by the internal sale order and line number. If run in Detail Mode, shows inventory receipts and payables invoices on separate lines with detailed information, if run in Summary Mode, the sales order line is summarized into one row.

/* +=============================================================================+
-- | Copyright 2016 - 2025 Douglas Volz Consulting, Inc.
-- | All rights reserved.
-- | Permission to use this code is granted provided the original author is
-- | acknowledged.09o warranties, express or otherwise is included in this permission.
-- +=============================================================================+
-- |
-- | Original Author: Douglas Volz ([email protected])
-- |
-- | Version Modified on Modified by Description
-- | ======= =========== ============== =========================================
-- | 1.0 23 Nov 2016 Douglas Volz Initial Coding
-- | 1.1 15 Dec 2016 Douglas Volz Added Customer Name for A/P Invoice
-- | 1.2 20 Dec 2016 Douglas Volz Fixed calculation bug for Net Amount
-- | 1.3 10 Jan 2017 Douglas Volz Added Transaction Type Code 61 and Transaction
-- | Source Type 7 in order to report internal
-- | order receipts for txn type Int Req Intr Rcpt
-- | and corrected SIGN of net quantity.
-- | 1.4 17 Jan 2017 Douglas Volz Added Int Req Intr Rcpt to the Inventory Queries
-- | corrected the transaction type code for material
-- | transactions, truncated the transaction date
-- | and corrected the report sort by order number and
-- | transaction type (receipts first).
-- | 1.5 18 Jan 2017 Douglas Volz Added Vendor Name and Transaction Source.
-- | 1.6 19 Jan 2017 Douglas Volz Commented out the customer type indicator, was
-- | preventing A/P invoices from being reported.
-- | 1.7 09 Jun 2017 Douglas Volz Added new section to report Intransit Shipments
-- | for FOB Shipment with the order booked in one
-- | OU but shipped from another OU
-- | 1.8 11 Jun 2017 Douglas Volz Added Transaction Date and Operating Unit
-- | Parameters. Added new section 5 for Payables
-- | invoices which are unmatched to POs or for IR/ISOs.
-- | 1.9 26 Feb 2025 Douglas Volz Removed tabs, cleaned up for Blitz Report.
-- | 1.10 23 Oct 2026 Andy Haack Rebuilt to the Blitz Report SQL standards.
-- +=============================================================================+*/

SQL 240 lines

Parameters 11

ParameterTypeList of values SQL
Report ModeLOV
Transaction Date FromDate
cmr.transaction_date>=:p_trx_date_from
Transaction Date ToDate
cmr.transaction_date<:p_trx_date_to+1
Transaction TypeLOV
cmr.transaction_type_code=:p_trx_type
Item NumberLOV
msiv.concatenated_segments=:p_item_number
Category Set 1LOV
select xxen_util.item_category_columns(p_category_set_name=>'<parameter_value>') sql_text from dual
Category Set 2LOV
select xxen_util.item_category_columns(p_category_set_name=>'<parameter_value>') sql_text from dual
Category Set 3LOV
select xxen_util.item_category_columns(p_category_set_name=>'<parameter_value>') sql_text from dual
Organization CodeLOV
mp.organization_code=:p_org_code
Operating UnitLOV
haouv.name=:p_operating_unit
LedgerLOV
gl.name=:p_ledger