Viewing the LIFO / FIFO rate details
This page allows you to view the LIFO and FIFO cost of the stock.
Select the “View LIFO/FIFO Rate Details” link in the “View Opening Balance” page.
The “View Rate Information” 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, which could be “Draft”, “Fresh” or Authorized” or “Canceled”. |
Warehouse # |
The number identifying the warehouse in which the stock is stored. |
Warehouse Description |
The textual description of the warehouse. |
Enter the following in the “Part Details” group box:
Reference # |
Use the drop-down list box and select the line numbers or part number-stock status combination of the opening balance documents. Mandatory. The system lists all the line numbers for which the Valuation Method is set to “LIFO” or “FIFO” and stock status attribute set as “Ownership-Internal”, if this page is launched from the “Edit Opening Balance” page. If this page is launched from the “Edit Weighted Avg/Actual Lot Cost Details” page, the system lists all the part number-stock status combination, for those parts with Entry Type “Multiple” and stock status attribute set as “Ownership-Internal”. |
Click the “Get details” pushbutton, to retrieve the rate information for the selected part.
The system displays the following:
Part # |
The number identifying the part. |
Part Description |
The textual description of the part. |
Total Quantity |
The total quantity of the part. |
Valuation method |
The costing method of the opening balance, which could be LIFO or FIFO. |
Stock Status |
The stock status of the part. |
Stock UOM |
The unit of measurement in which the part is stocked in 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 in the “Rate Information” multiline:
Seq # |
The number identifying the sequence in which the stock of LIFO or FIFO came into the warehouse. |
Qty. |
The total quantity of the part. |
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”. |
Ref Document # |
The reference document of the opening balance. |