Proposed Cost Update is a utility for setting a new standard cost on purchased items, prior to doing a Standard Cost Rollup & Revaluation. In a standard cost environment, a “rollup and revalue” process uses costs from lower levels to calculate the cost of upper level assemblies. The costs at the lowest level are purchased parts, and the routing for the assembly that uses the purchased parts.
While the Rollup & Revalue will calculate the cost of made items, Dynamics GP does not have a utility to set the standard cost on purchased parts. Usually this is done manually on a part-by-part basis. Proposed Cost Update provides several methods by which the standard cost of purchased items can be set for a large number of items automatically.
Navigation: Tools >> Setup >> Manufacturing >> MFG PowerPack Setup
Mark the box next to “Proposed Cost Update”.
Restart Dynamics GP.
Navigation: Tools >> Utilities >> Inventory >> Proposed Cost Update
Use the Proposed Cost Update window to select a range of Item Numbers or Item Classes for which you want to update the Proposed Standard Cost. Proposed Cost Update can also import a spreadsheet of new costs.
The Proposed Standard Cost is found on the Standard Cost Changes window (Cards >> Manufacturing >> Inventory >> Standard Cost Changes). Only Items with a Periodic costing method can be updated.
Update By: This drop-down list contains three options:
- Item Number
- Item Class
The labels for the fields below it will change based on the selection. For example, showing “From Item Number” when Item Number is selected or “From Item Class” when Item Class is selected.
When Import is selected, most of the fields on the window will be disabled. The Update button will be disabled, and the Import button will be enabled. See the Import Cost Update section below.
Treat EITHER as MAKE: items with a Make/Buy setting of Either will NOT be included in the update.
Treat EITHER as BUY: items with a Make/Buy setting of Either will be included in the update.
File Contains: Only enabled when Update By = Import. Mark or unmark these options to control what fields are updated by the Import. For example, since the file must contain a specific set of columns, the Material Cost column could be zero because you only want to import an update to Fixed Overhead. Unmark the Material Cost and Variable Overhead option to exclude those from the update (they will NOT be updated, so they will retain their original value after the update).
At least one option must be marked.
From: Enter a value (Item or Item Class), or select one from the Lookup.
To: Enter a value (Item or Item Class), or select one from the Lookup.
Material Cost: Select a Material Cost Source:
- Current Cost: the Current Cost from Item Maintenance, which is also the last purchase receipt cost.
- Receipt Cost – Average: the average of all purchase receipts within the specified date range.
- Receipt Cost – Mode: the most frequently occurring cost from receipts within the specified date range.
- Receipt Cost – Maximum: the maximum cost from purchase receipts during the specified date range.
- Receipt Cost – Minimum: the minimum cost from purchase receipts during the specified date range.
- Fixed Percent – calculates the new Proposed Cost as a percent increase/decrease of the Standard Cost.
The proposed cost is not updated if the method used to arrive at the new cost would result in zero dollars. The new cost might be zero, for example, if there were no receipts for the item during the selected date range.
Dates From/To: If the Material Cost Source is one of the “Receipt Cost” methods, enter the dates to use for calculating the receipt cost.
Percent: If “Fixed Percent” is selected for Material Cost Source, enter the percent by which the current Standard Cost should be increased or decreased. The calculation is:
New Cost = Standard Cost + (Standard Cost * Percent)
Fixed Overhead: Select an update method for the Fixed Overhead:
- No Change
- Percent of Material Cost
- Dollar Amount
The Percent of Material Cost calculation is:
Fixed OH = New Material Cost * Percent
Whether the update method is a dollar amount or percent, the Fixed OH amount is rounded to the correct currency decimals for the Item.
Variable Overhead: Select an update method for the Fixed Overhead:
- No Change
- Percent of Material Cost
- Dollar Amount
The Percent of Material Cost calculation:
Variable OH = New Material Cost * Percent
Whether the update method is a dollar amount or percent, the Variable OH amount is rounded to the correct currency decimals for the Item.
IMPORT Button: This button is only enabled when Import Cost is selected. Click the Import button, then select an Excel spreadsheet. You will be asked to confirm you are ready to import before the process begins (you may cancel at this point).
Proposed Cost Update can import a list of Items and New Standard Costs from an Excel spreadsheet. The spreadsheet must have this layout shown below.
Data must start in the first row. The spreadsheet can have any number of additional columns, but the first five columns must be:
A = Item Number
B = New Standard Cost
C = New Fixed Overhead
D = New Variable Overhead
E = empty (for status message)
Column E will be populated during the import with any error conditions encountered.
The following errors will be reported, and will prevent the row from being processed:
- Invalid Item Number
- New Cost <= $0.00 (only if Material Cost is being updated).
- New Cost = the current Standard Cost (only if Material Cost is being updated).
- New Cost has an incorrect number of decimal places (i.e. $0.255 but the Item is set to have 2-Currency Decimals). (Only if Material Cost is being updated).
- Fixed or Variable Overhead Amount had the incorrect number of decimals (only if Fixed or Variable Overhead is being updated).
- Item has a Manufacturing BOM and is set to be a MAKE item in Item Engineering, or it is a Make/Buy item and the Make/Buy Setting on Proposed Cost Update is to Treat as Make.
If the Fixed/Variable Overhead options are marked, you can still exclude specific items from the update. To leave the Fixed or Variable Overhead Amount unchanged, enter -1.00 in column C (Fixed Overhead) or column D (Variable Overhead). If the field contains zero, the overhead amount will be updated to $0.00.
|BM010115||BOM_Line||Bill Of Material Line File|
|IV00102||IV_Item_MSTR_QTYS||Item Quantity Master|
|IV40400||IV_Item_Class_SETP||Item Class Setup|
|IVR10015||IV_Item_ENG||Item Engineering File|