CAC Margin Analysis Summary

➜ Back to Library
Description
Categories: Cost Accounting - Assessment, Cost Accounting - Transactions, Enginatics, OATUG Public
Repository: Github Columns: Ledger, Operating Unit, Org Code, Customer Class Code, Customer, Customer Number, Order Number, Order Line, Order Type, Transaction Date ...
Report for the margin from the customer invoices and shipments, based on the standard Oracle Margin table, cst_margin_summary. (If you want to show the COGS and Sales Accounts use report CAC Margin Analysis Account Summary.) You first need to run the Margin Analysis Build request, to populate this table.
/* +=============================================================================+
--  ...  Report for the margin from the customer invoices and shipments, based on the standard Oracle Margin table, cst_margin_summary. (If you want to show the COGS and Sales Accounts use report CAC Margin Analysis Account Summary.) You first need to run the Margin Analysis Build request, to populate this table.
/* +=============================================================================+
-- | Copyright 2006 - 2020 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])
-- |
-- | Parameters:
-- | p_trx_date_from -- Starting transaction date for the customer shipments
-- | p_trx_date_to -- Ending transaction date for the customer shipments
-- | p_category_set1 -- The first item category set to report, typically the
-- | Cost or Product Line Category Set
-- | p_category_set2 -- The second item category set to report, typically the
-- | Inventory Category Set
-- | p_customer_name -- Enter the specific customer name you wish to report (optional)
-- | p_item_number -- Enter the specific item number you wish to report (optional)
-- | p_org_code -- Specific inventory organization you wish to report (optional)
-- | p_operating_unit -- Operating Unit you wish to report, leave blank for all
-- | operating units (optional)
-- | p_ledger -- General ledger you wish to report, leave blank for all
-- | ledgers (optional)
-- |
-- | Description:
-- | Report for the margin from the customer invoices and shipments, based
-- | on the standard Oracle Margin table, cst_margin_summary. You first need
-- | to run the Margin Analysis Build request, to populate this table.
-- |
-- | Version Modified on Modified by Description
-- | ======= =========== ============== =========================================
-- | 1.0 18 APR 2006 Douglas Volz Initial Coding
-- | 1.1 15 MAY 2006 Douglas Volz Working version
-- | 1.2 17 MAY 2006 Douglas