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:

1. Open the Inventory Part window and query for the part for which you want to enter or change the inventory value.
2. Click the Costs tab.
3. In the table area in the Inventory Value tab, select the record of interest.
4. 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.

5. 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.
6. 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.
7. Repeat step 6 and add as many new cost detail lines as required.
8. 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).
9. Click OK.
10. 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.