CAC Manufacturing Variance

Description

Categories
Enginatics
Repository
GitHub
Report your summary or detail manufacturing variances for open and closed WIP jobs. If the job is open the Report Type column displays "Valuation", as this WIP job and potential variances are still in your WIP inventory balances. If the job has been closed during the reporting period, the Report Type column displays "Variance", as this WIP job was written off on a WIP Job Close Variance transaction. You can report prior periods and the report will automatically adjust the assembly completion, assembly scrap, component issue and resource quantities to reflect the reported accounting period, as well as report only jobs which were open or closed during that prior period.

Closed, Pending Close, Cancelled, Complete and Complete No Charges WIP job statuses use the completion quantities. All other WIP jobs use the parameter "Use Completion Quantities". And if you use Standard Costing, for standard discrete jobs this report also shows your configuration and method variances; the difference between your WIP BOM/routing and your standard BOM/routing. Non-standard jobs usually do not have configuration variances, as they are "non-standard" without standard BOM or routing requirements.

-- | Copyright 2011-25 Douglas Volz Consulting, Inc.
-- | Version Modified on Modified by Description
-- | ======= =========== =============== =========================================
-- | 1.36 21 Dec 2024 Douglas Volz Fixes for Configuration and Method Variances.
-- | 1.37 02 Jan 2025 Douglas Volz Add Scrap Variance column, to avoid double-counting assy scrap.
-- | 1.38 04 Feb 2025 Douglas Volz Consolidate Summary and Detail reports into one report.
-- | 1.39 24 Oct 2026 Andy Haack Rebuilt to the Blitz Report SQL standards.

SQL 1429 lines

Parameters 24