Short Description
This report shows the stock value based on the historical supplier price of the items.
The supplier price is determined using the First-In-First-Out (FiFo) method based on the item’s goods receipts as of the selected key date. These goods receipts are listed in the report along with their goods receipt number and date.
The historical supplier price (Hist EK Net) is the price from the corresponding goods receipt document.
To access the report, navigate to Controlling > Reporting and create a report profile (the report Stock Value FiFo – Details is located in the Logistics report group). Then, generate the report (Procedure: Report_StockValue_Hist).
Available Parameters
The following parameters are available in this report:
Date: Defines the cut-off date for the evaluation.
Location: Allows you to select a specific location for the evaluation. If no location is selected, all locations are included in the report.
Category: Allows you to filter by a specific category. If no category is selected, all categories are included.
Supplier: Allows you to filter by a specific supplier. If no supplier is selected, all suppliers are included.
Results
Goods Receipt No.: Displays the goods receipt number of the item.
Date: Displays the date of the goods receipt.
Quantity: Shows the quantity of stock items on the selected key date.
Currency: Displays the item’s currency.
Net Sales Price (per item): Displays the sales price per item excluding VAT.
Net Sales Total: Displays the total sales price of all stocked items excluding VAT.
Hist EK Net: Displays the historical supplier price excluding VAT.
Hist EK Total: Displays the total historical supplier price excluding VAT.
Additional Information
The values in the Hist EK Net column are based on the historical FiFo supplier price and are derived from the Final Price field in the goods receipt. The standard supplier price is not used—only the discounted final price is applied.