Short Description
This report shows you the stock value of all items according to the FiFo principle as of the selected date. It is identical to the report Stock Value, with the only difference being that the Supplier Price is calculated historically using the FiFo principle.
Navigate to Controlling > Reporting and create a profile (the report Stock Value FiFo 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:
Reference date: Define the reference date for the analysis.
Location: Select a specific location for the analysis. If no location is selected, all locations will be included in the evaluation.
Category: Select a specific category for the analysis. If no category is selected, all categories will be shown.
Current Supplier: Select a specific Supplier for the analysis. If no Supplier is selected, all Suppliers will be shown.
Show all items related to this supplier: If this filter is enabled, pixi will display all Items associated with the selected Supplier. If disabled, pixi will only show Items for which the Supplier is set as the default.
Results
Shop Item Name: Displays the item number from the shop.
Item EAN: Displays the item's barcode.
Item Name: Displays the name of the item.
Category: Displays the item’s category.
Supplier: Displays the Supplier of the item.
Stock: Displays the stock quantity of the item.
Currency: Displays the currency for the item.
Net Supplier Price (single unit): Displays the net purchase price (excluding VAT) per item.
Historic EK: Refers to the historic Supplier Price based on the FiFo method.
Total Historic EK: Displays the total value of the historic Supplier Price.
Additional Information
The values in the column Hist EK Net are based on the historical FiFo Supplier Price and use the values from the Final Price field. The current Supplier Price is not used; instead, the discounted Final Price is applied. The following notes may appear in the report:
Goods Receipt not activated: The Goods Receipt for the item is not recorded via pixi.
Insufficient goods receipts during the selected period: Fewer Goods Receipts occurred during the selected period than the total stock level indicates.
Stock quantity insufficient for the selected period: More Goods Receipts occurred than items in stock during the selected period.
No goods receipts at all for the item, current Supplier Price used: No Goods Receipts were created for the item during the selected period, so the current Supplier Price is used.
There are goods receipts that are not in "Calculated" status; Supplier Prices may change: Some Goods Receipts in the selected period are not yet in "calculated" status. Therefore, the Supplier Prices in this report may still change.