CAC PO Price vs. Costing Method Comparison

➜ Back to Library
XLSExcel example XMLXML import file

Description

Categories
Enginatics
Repository
GitHub
Report to compare the open purchase order lines and unit prices with the costing method item cost in Oracle (Average, Standard, FIFO or LIFO). Used by the buyers and cost accounting to check the accuracy of the recently created purchase orders and run using a range of purchase order line creation dates. Foreign currency purchase orders convert to the inventory organization's currency by either using the original purchase order exchange rate, if the Invoice Match Option is "Purchase Order" or by using the latest exchange rate date if the Invoice Match Option is "Receipt".

/* +=============================================================================+
-- | Copyright 2006-2024 Douglas Volz Consulting, Inc.
-- | All rights reserved.
-- | Permission to use this code is granted provided the original author is
-- | acknowledged. No warranties, express or otherwise is included in this
-- | permission.
-- +=============================================================================+
-- |
-- | Original Author: Douglas Volz ([email protected]
-- |
-- | Version Modified on Modified by Description
-- | ======= =========== ============== =========================================
-- | 1.0 02 APR 2006 Douglas Volz Initial Coding
-- | 1.17 13 Jun 2017 Douglas Volz Added OSP Resource Code
-- | 1.18 19 Aug 2019 Douglas Volz Removed non-generic item categories
-- | 1.19 27 Jan 2020 Douglas Volz Changed to multi-language views for the item
-- | master, inventory orgs and operating units.
-- | Added project number to report.
-- | 1.20 19 Dec 2020 Douglas Volz Add these columns: PO Need By Date, PO Promise Date,
-- | PO Expected Receipt Date, Target Price (PO List Price),
-- | Customer Name (description for category set 1).
-- | And added Minimum Cost Difference parameter.
-- | 1.21 22 Dec 2020 Douglas Volz Changed the item cost "union all" to just "union",
-- | which eliminated a full table scan on cst_item_costs.
-- | 1.22 02 Nov 2023 Douglas Volz Add Cost Type as a parameter, remove tabs and
-- | add org access controls.
-- | 1.23 18 Jul 2024 Douglas Volz Fix for Percent Difference calculation.
-- | 1.24 23 Oct 2026 Andy Haack Rebuilt to the Blitz Report SQL standards.
-- | 1.25 24 Oct 2026 Andy Haack Price per primary unit of measure divided by the conversion rate.
-- +=============================================================================+*/

SQL 201 lines

Parameters 14