Check box if you "Do not want items listed with 0 inventory and no purchase history for the current year", then the standard cost will remain unchanged

Check this box if you want to  "Allow user to enter in the Weighted Average Variable".  Once this has been checked the users can then enter in the number of the most recent Purchase Orders they wish to have included in the Weighted Average Calculation. This give the user the option to eliminate the Quick Turn buys that may throw the calculations off.  

Modifications tab field definitions

 

Check All - Use calc cost for all records	If this box is checked - the system only checks the record if the calcualted cost > 0.  If this box is checked at one level, this option will carry forward as checked when users move to the next levels.
Check All - Use calc cost for calc cost not zero	if this box is checked - the system will check all records to use calculated cost no matter it's zero or not.  If this box is checked at one level, this option will carry forward as checked when users move to the next levels.

·Important Note - If accounting is installed: For all buy parts, the standard cost field must have data entered.  If this data is missing (or wrong), the Raw Materials Inventory and the Work In Process (WIP) will be incorrect for the accounting records.  All make parts which are not labor only (the customer brings you the kit and all you do is apply the labor), must have data entered in the standard cost field.  Additionally, the data entered in the standard cost field for the make part must equal the sum of the Bill of Materials components.(Please refer to Bill of Materials Reports – Bill of Material With Standard Cost.)   If the data is missing or wrong on a Make Part, the Work In Process, Cost of Goods Sold and Finished Goods Inventory will be wrong for the accounting records.  If the sum of the Bill of Materials components does not equal the standard cost per the Item Master, a configuration variance will generate.

By moving the arrows (at the bottom of the screen) to the right the following fields are also available

	If this button is depressed the costs will roll up to all of the Inventory Tables plus the records required for accounting will be created for posting to the General Ledger.  Note: Users have to have special access in order for this button to be enabled.  This access is assigned through Security/User Rights.
Date Run	This is the date of the run.
	This button is used to recalculate the total change (Delta) column.
Total	This is the total of the column “Delta” (change).

Enter Inventory Mgmt/Inventory Control Management/Standard Cost Adjustment Module

The following screen will appear:

To find a Previously created Standard Cost Adjustment where the roll costs has not yet been performed, depress the Find action button.  The following selection screen will appear:

If you select to find by Buy Parts, the following screen will appear:

Enter Inventory Mgt/Inventory Control Management/Standard Cost Adjustment Module

The following screen will appear:

Depress the Add action button (Start New Cost Roll) and the folloiwng items will become enabled:

Type in the percentage to use if the part material cost is different from the Weighted Average Price Value by Greater than or Equal to or if the assembly material cost is different from the Sum of the parts standard value by Greater than or Equal to   Or   Difference between Calculated and Current Greater or Equal to $ 

Check box if you "Do not want items listed with 0 inventory and no purchase history for the current year", then the standard cost will remain unchanged

Check this box if you want to  "Allow user to enter in the Weighted Average Variable" or you can type in the number of  PO(s) to include in the calculated weighted cost.

To roll up the Buy Parts, depress the Roll up BUY Parts button.  Upon rolling the records the system will now consider all of the Costs, and not just the material cost.

After the calculation is complete, the following message will appear:

Depress the OK button.  Depressing on the Modifications tab reveals the following:

Depress the Edit button.  To effect a change, click on either the Use Calc column or the Use Manual column.

If you choose Use Manual column, you must also enter a new manual, labor, overhead, other, or user defined cost: 

Note that the Delta column updates automatically.  This is the difference between the old Standard Cost and the New Standard Cost multiplied by the Quantity.  (Note:  The quantity may include setup scrap and/or run scrap if the box to exclude scrap from Cost Rollup is not checked in the  Kit Default Setup screen).

To Re-calculate the total change (Delta), depress Recalculate Total button.The Total will update, as illustrated:

Depress the Save record action button.

To Post the changes to the Standard Cost and generate the General Ledger entries, depress the Roll Costs button.  The system will update the "Last Change" field (within the ICM screen) for part numbers that actually had pricing information changed within the Std Cost Adjustment. 

Enter your password.   Note:  This requires a high level accounting password.

The following message will appear once the update has been completed.

Depress the OK Button.

The Level Make Parts button causes the system to find all Indented Bills of Materials.  Then the system “tags” the lowest indenture.    Users will NOT be able to add or edit any BOM during this process.  If a user is already in the process of modifying a BOM and this process is started the user will NOT be allowed to save the changes until the leveling process is complete.

Enter Inventory Mgt/Inventory Control Management/Standard Cost Adjustment Module

The following screen will appear:

Depress the Add Record (Start New Cost Roll) action button, enter password, then depress the Level MAKE Parts button. The following message will appear once the update has been completed.

Depress the OK Button. The following screen will appear:  

 

 

The Level of Levels information automatically updated to the next level that needs to be Rolled up.

 

Depress "Yes" to continue.  If a rollup already exists the following option screen will appear:

Depress "Yes" to continue. The following message will appear:

Enter into the Modification screen, only the Level 1 of 2 Levels assemblies will be displayed (sub-assemblies, etc).  Depress the Edit Record action button and select the Use Calculated or Use manual to make any changes.   If Use Manual is selected then you have to enter in the Manual Cost.

Save the changes and depress the “Roll Costs” button. The following message will appear:

Depress the OK Button, then return to the Selection screen. 

 

d)  If one of the component parts on the top level is a MAKE and MAKE_BUY the cost roll up will included the std price for the part itself and will NOT include the std costs for the subcomponents.  For an example see the Word attachment <<The Std Cost of the MAKE_BUY_081211.docx>>).

e)  If one of the component parts on the top level is a MAKE and a Phantom/Make the cost roll up will NOT include the std price for this part because the cost roll up will include the cost of this parts components.

Note:  The calculated cost will only include the costs for ACTIVE parts and subassemblies as of the date of the roll up and will NOT include any parts that may have been identified as inactive either in the item master or in the obsolete date of the part on the BOM.