Viewing the balance sheet revaluation details

Viewing the Balance Sheet Revaluation Details

Select the “Balance Sheet Revaluation Details” tab from the “Compute Inventory Revaluation” page.

The system displays the following in the “Parts Details” multiline, 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)
Manufacturer Lot #	The number identifying the lot number of the part issued by the manufacturer.
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”

Modify the following, if required

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.

The system displays the following:

Total Stock Value	The total current value of the stock in the warehouse or location calculated by Quantity (Qty) * Unit Rate
Total Market Value	The total market value calculated by cumulative value of Qty * Market Rate

Note: Ensure that the supplier currency is the same as the base currency. If not, the system converts the supplier currency into the base currency by interacting with the “Exchange Rate” business component. The system considers the exchange rate for the supplier currency as on the end of the “Revaluation Period” and if the current date is later than on the “Revaluation Period<To Date>”.

Note: The system performs the following functions for the “Balance Sheet Revaluation Details” group box.

The currency conversion is Converted Price = Part Cost * Exchange Rate. For example, if the base currency is Rs., supplier currency is Dollars, exchange rate is 45, and part cost is 1 Dollar, then

Part Cost = Part Cost * Exchange Rate

Part Cost = 1*45 = 45

Converted Part Cost = 45 Rs.

The system considers the cost per value defined against the parts in the “Supplier” business component. If the cost per value is not equal to 1, the system calculates the part cost for each part against the supplier by Part Cost = Part Cost/ Cost Per. For example, if the part cost is 60 Euros and the cost per is 3, then the unit part cost for the part is 60/3 = 20 Euros.

Note: Ensure that the UOM conversion between the stock UOM and purchase UOM is specified for each part.

The system considers the conversion between stock UOM and the purchase UOM defined at the part level in the “Part Administration” business component or at the global level in the “UOM Administration” business component. The system calculates the part cost for each part against the supplier, if the stock UOM and the purchase UOM specified for the part is not the same by Part Cost = Part Cost/ Conversion between the stock UOM and the purchase UOM. For example, if the part cost is 20 Euros and the stock UOM is EA and the purchase UOM is BX and if the conversion between BX and EA as defined in the “UOM Administration” business component is 10, then the part cost for the part against the supplier is (20 /10) 2 Euros.

Note: The system does not consider parts with expense type “Capital”.

The system displays the following in the “Balance Sheet Revaluation Summary” group box:

Computed Value	The cumulative value of the total market value.
Revaluated Value	The cumulative value of the total market value after modifying the market rate. If the market rate is not modified, then the computed value will be the revaluated value on update.
Voucher #	The system generates the reversal journal voucher on clicking the “Update” pushbutton, which can be selected to view the reversal journal voucher.

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

Check the box in the “Select” column of the multiline, to select the part number for deletion.
Click the Delete icon in the toolbar above the multiline, to delete the part number selected in the multiline.

To proceed, carry out the following

Select the “Stock Revaluation Details” tab to view the stock details for the inventory.