CAC ICP PII Material Account Detail

Description

Categories
Enginatics
Repository
GitHub
Report to get the Material accounting distributions, in detail, for each item, organization and individual transaction. Including profit in inventory amounts based on your PII cost type. With the Show SLA Accounting parameter you can choose to use the Release 12 Subledger Accounting (Create Accounting) account setups by selecting Yes. And if you have not modified your SLA accounting rules, select No to allow this report to run a bit faster. Use Show Projects to display or not display the project information (project number, name, task and project cost collection status) and use Show WIP Job to display or not display the WIP job information (WIP class, class type, WIP job, description, assembly number and assembly description). To get all positive and negative amounts above a threshold value, use the Absolute Transaction Amount parameter. For Discrete, Flow and Workorderless WIP (but not Repetitive Schedules). Both Flow and Workorderless show up as the WIP Type "Flow schedule".

Note: The SQL logic and code for this report is identical to the CAC Material Account Summary report.

Hidden Parameters:
================
Numeric Sign for PII: allows you to set the sign of the profit in inventory amounts, defaulted to "1" (mandatory).

/* +=============================================================================+
-- | Copyright 2009- 2022 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.
-- | 1.32 24 Oct 2026 Andy Haack Rebuilt to the Blitz Report SQL standards.
-- +=============================================================================+
-- |
-- | Version Modified on Modified by Description
-- | ======= =========== ============== =========================================
-- | 1.0 06 Nov 2009 Douglas Volz Initial Coding
-- | 1.30 21 Oct 2022 Douglas Volz Logic change for Internal RMA order numbers.
-- | 1.31 28 Jul 2025 Douglas Volz Added Reason Codes and GL & OU Security Profiles.

SQL 325 lines

Parameters 20