Modify Condition Cost Details
Explanation
Use this activity to change the inventory value and
cost details of a specific site, part, configuration and condition code
combination. This procedure is generally used when a condition code for a part
has been changed to a condition code for which there is no existing inventory
valuation, i.e., the condition code has never previously been used for the part.
When the condition code is changed, the existing inventory value will be carried
over to the new condition code if no inventory value exists on the new condition
code. If a inventory value exists on the condition code you change to, that will
be the new inventory value for the lot batch or serial number.
Prerequisites
- To be able to use condition code functionality, which is required for this
inventory valuation method, condition codes must be entered in the
Part Basic Data/Condition Code tab.
- Parts must be lot batch and/or serial tracked, with condition codes
enabled. Note that once condition code functionality is enabled for an
inventory part, it cannot be disabled. These parameters are set in the
Part/General
tab.
- The part must have Inventory Part Cost Level set to Cost Per Condition.
This parameter is set in the
Inventory Part/Misc Part Info tab.
- Specified parts must exist in inventory, i.e., part records must exist in
the table area of the
Inventory Part/Costs tab.
- If you want to specify cost buckets and cost sources in the cost
details, they must have already been defined in the
Cost Bucket window and
the
Cost Details Basic Data
window.
System Effects
The inventory values are updated, as a background job, for all parts that
share the combination of site, part number, configuration ID, and condition
code. Values can be viewed in the Inventory Part/Costs/Inventory
Value
tab. When the inventory value is changed, a revaluation transaction will be
created for the specific combination of part number and condition code:
The INVREVAL+ will include all details where the value has increased,
including the manually added details.
The INVREVAL- will include all details where the value has decreased, including
the lines where the new cost has been set to zero. Note: If you have parts in transit we will use INVREVTR+/-. If we have parts
owned by the supplier (Supplier Consignment Stock), the transaction CO-INVREV+/-
will be used.
Note that all
rows in the Inventory Part/Costs/Inventory Value
tab that have the same condition code will then get the new inventory value
Window
Inventory Part
Related Window Descriptions
Inventory Part
Inventory Part/Costs
Inventory Part/Costs/Inventory Value
Modify Level Cost Details
Procedure
To enter or change the inventory value and cost details of part/condition code combination:
- Open the
Inventory Part window and query for the part for which you want to enter or change the inventory value.
- Click the
Costs tab.
- In the table area in the
Inventory Value tab, select the record of interest.
- Right-click, then click Modify Level Cost Details.
The
Modify Level Cost Details dialog box opens. You can
view the part and cost level information in the header area (you cannot
change this information). The existing cost structure will be defaulted and
displayed in the table area.
You can
specify a new cost for existing cost detail lines, and/or create new lines.
- To enter a new inventory value for an existing
cost detail line, enter a value in the New Cost field. Note: If you do not enter a new cost, the cost structure will keep the cost
detail line with the old value.
- To enter a new cost detail line, click the New
button. Enter values in the Cost Bucket ID, Cost Source ID and New
Cost fields.
- Repeat step 6 and add as many new cost detail
lines as required.
- If you want a line to be removed from the old cost
detail structure, you must set the value in the New Cost field to
zero. (You can only remove new lines that you have entered, by using the
Remove button).
- Click OK.
- If desired, re-query for the part in the
Inventory Part
window header, and verify the changes in the Costs/Inventory Value
tab. If you select the line, right click and then click
Cost Details, you will be able to view the cost details including the new
lines.