Viewing the Stock Revaluation Details
Select the “Stock Revaluation Details” tab from the “Compute Inventory Revaluation” page.
The system displays the following in the “Parts Details” multiline as applicable to the “Balance Sheet Revaluation Details” tab, based on search criteria:
Currency |
The currency of the organization unit. The system retrieves the base currency as defined in the “Create Country & Currency” activity in the “Organizational Setup” business component |
Part # |
The number identifying the part (Alphanumeric, 40). |
Warehouse # |
The number identifying the warehouse. |
Stock Correction # |
The number identifying the stock correction document. |
Serial # |
The number identifying the serial number of the part (Alphanumeric, 40) |
Lot # |
The number identifying the lot to which the part belongs (Alphanumeric, 18) |
Supplier # |
The code identifying the supplier who owns the received part. |
Supplier Name |
The name identifying the supplier. |
Supplier Pricelist Value |
Lowest of (Part Cost/Qty (provided in the Part Supplier Mapping activity against the supplier) – Highest Discount code (if multiple discount codes are mapped against the supplier then system takes the summation of highest discount codes mapped against the respective TCDs) + Lowest Charge Code (If multiple charge codes are mapped against the supplier then system takes the summation of lowest charge codes mapped against the respective TCDs). |
Part Type |
The type of the part as defined in the ”Part Administration” business component |
Stock Status |
The stock status of the part. The system lists all the stock statuses for the part number as defined in the “Create User Defined Stock Status” activity of the “User Defined Stock Status” business component with “Ownership” set as “Internal”. |
Total Qty |
The total quantity of the part available in the warehouse- zone – bin, in the specified stock status. |
Unit Rate |
The part cost maintained in the warehouse level for “Actual Cost” or at the location level for “CMAV” |
Market Rate |
The minimum among the supplier part cost for a part from different suppliers. The system retrieves supplier part cost from the “Supplier” business component. |
Current Value |
The total current value of the stock as maintained for the part number and the stock status. |
LCM Value |
The lowest among the existing part cost and the minimum of the supplier costs for a part is the “Lower of Cost or Market Value” (LCM). |
Part Account Group |
A unique code identifying the part account group (Alphanumeric, 20). |
Note: The system performs the functions applicable to the “Balance Sheet Revaluation Details” multiline.
The system retrieves the minimum part cost from different suppliers mapped to a Part # in the “Market Rate” field. For example, if there are 2 suppliers, supplier 1 and supplier 2, quoting 20 and 25 for part 1,then the Market Rate for part 1 is 20.The system retrieves the parts whose unit rate is above then the market rate.
The system displays the Total LCM Value (LCM Price * Total Qty) against the “Part #, Serial #, Lot # and Stock Status” fields.
The system displays the following in the “Stock Revaluation Summary” group box:
No. of Items Affected |
The total number of parts for which the market rate is lesser than the unit rate |
Total Change in Stock Value |
The Total Current Value - Total LCM Value. |
Enter the following in the “Other Details” group box:
Remarks |
Any additional comment pertaining to the inventory revaluation of the part |
Enter the following in the “Attachments” group box:
File Name |
The name of the file used as document reference for the inventory revaluation of the part |
To proceed, carry out the following
Select the “Balance Sheet Revaluation Details” tab to view the balance sheet details for the inventory