Multiple Cost Comparison
For instance: comparison between a revised standard cost for a given year and another revised standard cost for any basic product, or for products in a selection.
Prerequisite
Refer to documentation Implementation
Screen management
General principle
First cost - Second cost
These two fields are used to enter the information relating to the two costs to be compared.
Start/End ranges
This block is used to enter the start and end selection criteria.
Variances
The criteria selected in this field are used to filter the submitted products based on variances (in percentage or amount) between the two costs. For instance, it is possible to only display on the report material variances larger than or equal to 5%
If these fields are left blank, the system will not filter the results and it will display all the information found.
Display
The selected criteria in this field are used to specify whether the cost sub-groups should be displayed or not.
Entry screen
First cost
Storage site (field STOFCY1) |
Enter or select the storage site where the selected product is active. The Selection icon (magnifying glass) only suggests products that are referenced in the products-sites table. |
Cost type (field CSTTYP1) |
Cost type to choose from "Standard", "Revised", "Budget", "Simulated". |
Validity start date (field DAT1) |
This field is used to enter the validity start date. |
Second cost
Storage site (field STOFCY2) |
Enter or select the storage site where the selected product is active. The Selection icon (magnifying glass) only suggests products that are referenced in the products-sites table. |
Cost type (field CSTTYP2) |
Cost type to choose from 'Standard', 'Revised', 'Budget', 'Simulated'. |
Validity start date (field DAT2) |
This field is used to enter the validity start date. |
Start - end range
Category Start: (field TCLCODSTR) |
The product categories are used to classify and filter the products according to their use. This step makes it possible to refine the selection prior to carrying out the adjustment process. This code is used in the Product record to enable selections. |
Category end: (field TCLCODEND) |
From product (field ITMREFSTR) |
Enter the selection start product number. The product ranges limit the report to these products only. |
To product (field ITMREFEND) |
Enter the ending product number for the selection. Product ranges are used to restrict the report to these products only. |
From valuation method (field VLTSTR) |
Filter for results within a range of valuation methods. For a single valuation methods, enter the same valuation method code in the From valuation method and To valuation method fields. You can leave the From valuation method field blank to search all valuation methods. |
To valuation method (field VLTEND) |
End range of the valuation methods that must be applied to the products to be selected for the report. |
From user (field BUYSTR) |
Filter for results within a range of buyers. For a single buyer, enter the same code in the Start/from buyer and To/end buyer fields. These fields are not available for entry when the Accounting date check box is selected, and the Costing mode is set to Primary issue method or Secondary issue method. |
To user (field BUYEND) |
Enter the ending buyer to select entries to be processed. This option is not available when the Accounting date check box is selected and the Costing mode is Primary issue method or Secondary issue method. |
field TSICODSTR |
Code of the product statistical group, comprised of three alphanumerical characters, to be entered for the chosen group. It is associated with a meaningful label. |
field TSICODEND |
Grid Variances
Description (field LINE) |
Filter (field SELFLG) |
Percentage (field VARPER) |
Amount (field VARAMT) |
Display
Material (field MATFLG) |
When these boxes are ticked, they are used to view the variances on material, machine, workforce, sub-contracting and overheads. |
Machine (field MACFLG) |
Labor (field LABFLG) |
Subcontract (field SCOFLG) |
Overhead (field OVEFLG) |
When these boxes are ticked, they are used to view the variances on material, machine, workforce, sub-contracting and overheads. |
Detail (field DETFLG) |
When checked, this box activates the display of the cost sub-categories (material, machine, ...). |