Modify Cost Details for a Specific Lot Batch Number

Explanation

Use this activity to change the inventory value and cost details of a specific lot batch part.

Prerequisites

• Parts must be lot batch tracked. This parameter is set in the Part/General tab.
• The part must have Inventory Part Cost Level set to Cost Per Lot Batch. 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 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 value is updated, in a synchronous way, for the parts with specified lot batch number. 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 site, part number, configuration ID, lot batch number and serial number:

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.

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 a lot batch part:

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 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 of the dialog box.

You can specify a new cost on 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 and right click and click Cost Details, you will be able to view the cost details including the new lines.