pixi
Ask AI
What's an 'Ideas Portal'?
DE

Report: Stock Value



Short Descpription

This report displays the stock value of all items as of the selected date.

Go to Controlling > Reporting and create a profile (the Stock Value report is located in the Logistics report group). Then generate the report (Procedure: Report_StockValue).


Available Parameters

The following parameters are available in this report:

  • Date: Define the date for the analysis.

  • Location: Select a specific Location for the analysis. If no location is selected, all locations will be included in the report.

  • Category: Select a specific category for the analysis. If no category is selected, all categories will be shown.

  • Supplier: Select a specific Supplier for the analysis. If no supplier is selected, all suppliers will be shown.


Results

  • Location: Displays the Location of the stocked items.

  • Stock: Displays the stock quantity for this item as of the selected date.

  • Selling Price: Displays the selling price (incl. VAT) of the item.

  • Supplier Price: Displays the supplier price (excl. VAT) of the item.

  • Gross Profit I: Displays the gross profit I for the item, calculated as:
    Selling Price – Supplier Price – VAT.

  • Total Selling Price: Displays the total selling price for all stocked items.

  • Total Supplier Price: Displays the total supplier price for all stocked items.

  • VAT Rate: Displays the VAT rate applied to the item.


Additional Information

  • The Supplier Price column shows the supplier price from the most recent Purchase Order before the selected report date. It does not include VAT.

    • If the most recent Purchase Order has no valid supplier price (i.e., price = 0.00), the system searches previous Purchase Orders in chronological order until one with a valid price is found, and displays that price along with the corresponding Supplier.

    • If no Purchase Order exists for the item, the historical supplier price is displayed.

  • If an item is linked to multiple Suppliers, the supplier is determined using a method similar to that of the historical supplier price:
    When generating the report, pixi first checks for any open or completed Purchase Orders for the item with an order date on or before the selected report date.

    • If a Purchase Order is found, that Supplier is displayed.

    • If no Purchase Order exists, pixi checks for a historical Supplier entry updated before the selected date and displays that one.

    • If there is no historical entry, the currently assigned Supplier is shown.

    • If the only assigned Supplier is the default "MGS", then "MGS" is displayed.

    • Deactivated Suppliers can also be shown in the report.

    • If a Supplier that was assigned to the item during the selected period has been deleted, no Supplier is displayed for that item.

  • The values in the Selling Price column include VAT.

  • The Stock column displays the physical stock quantity.

  • Gross profit is calculated as Selling Price – Supplier Price – VAT.


Back to top