Viewing the rate and value details
This page displays the rate and value of a part. Tell me more
Select the “View Rate Details” link in the “View Opening Balance” page.
The “View Rate & Value Details” page appears.
The system displays the following in the “Opening Balance Identification Details” group box:
Opening Balance # |
The opening balance document number for which the details are displayed. |
Status |
The status of the opening balance document, which could be “Draft”, “Fresh”, “Canceled” or “Authorized”. |
Warehouse # |
The number identifying the warehouse in which the stock is stored. |
Warehouse Description |
The textual description of the warehouse. |
Base Currency |
The code identifying the currency that is used as the base currency by the company. This is the currency in which the company reports to the statutory authority. |
The system displays the following “Rate Information” multiline:
Part # |
The part number for which the costing method, rate and value are displayed. |
Manufacturer Lot # |
The lot number of the part issued by the manufacturer. |
Stock UOM |
The unit of measurement in which the part is stocked in the warehouse. |
Total Quantity |
The total quantity of the part. |
Valuation Method |
The costing method of the part, which could be LIFO, FIFO, Average or Actual cost. |
Rate |
The rate per quantity of the part. Rate is calculated as “Value/ Quantity”. |
Value |
The value of the part. Value is calculated as “Rate x Quantity”. |
Entry Type |
The type of entry, which could be “Single“, “Multiple” or blank. |
Ref Document # |
The reference document for the opening balance. |
To proceed, carry out the following
Select “View LFIO/FIFO/Computed Rates” link at the bottom of the page, to view the rate details.
Viewing the rate and value details - An overview
This page displays the rate and value of a part. For parts that are valued using weighted average cost, and Actual Lot Cost methods. For parts that are valued using the actual cost method, the system displays the rate and value associated to the lot number.
The entry type indicates the method in which you can enter the rate details. If the entry type is ”Single” then for a Weighted Average valuated part rate needs to be specified as a single entry. If the entry type is “Multiple” then you can split the quantity for a Weighted Average part and specify the sequence in which the stock came into the warehouse.