This article describes the calculation of the historical and FiFo supplier price.

Calculation of the historical Supplier Price

In pixi* reports the historical supplier price is calculated as follows:

You want to check the supplier price of an item from 01.01.2013.

If there is a supplier order in status "ordered" or "closed" for this item before the chosen date, then the supplier price of this supplier order is taken for the reports.
If there is no supplier order for this item, the item's historical data is checked for a supplier price before the chosen date.
If there is also no supplier price, the current supplier price is used, which is assigned to the item.
If none of the above mentioned cases apply, then 0.00 is shown.

Reports

The following reports show the historical supplier price:

Stock Value
Gross Profit
Stock Movements

Calculation of the historical FiFo Supplier Price

For the calculation of the historical FiFo supplier price, the supplier price, which is set for deliveries (final price incl. discount), is used. If there is no delivery, another supplier's price is taken.

You want to see the stock value of a certain date based on the FiFo supplier price.

First, the historical stock for this date is loaded. The exact time for which the stock is loaded is 23:59:29.
Then, all deliveries before this date are considered until the predetermined historical stock for the item is reached.
In the next step, the delivery supplier prices (final price incl. discount) are averaged and shown.
If there are no deliveries for an item, the item's current supplier price is used.

An Example:

You want to check the stock value for the item "Videotext Marker" from February 1st.
On this date (February 1st, 23:59:59), the stock quantity of this item was 8.
There are 2 deliveries for this item before February 1st:
- January 30 - 5 pieces for 10 Euro each
- January 15 - 10 pieces for 5 Euro each
Following the “First in, First out” principle, first the supplier prices of the delivery from January 30, with prices of 10 Euro, are considered and then the remaining 3 pieces of the delivery from January 15
- 5 x 10 € + 3 x 5 € = 65 €
- 65 € / 8 = 8.125 € (rounded: 8.13 €)

In case a return is created, the supplier price of the next older delivery (from January 15) is used, because the quantities of the latest delivery are "used-up" already. This means, if a return was created on February 2nd (stock is increased by 1), the item is put to stock with a supplier price of 5 €. The average supplier price then drops to 7.78 € (70/9).

Info: The calculation of the supplier price is based on paragraph 256 of the German Commercial Code (HGB § 256) to evaluate the inventory. pixi* calculates the supplier price based on the FiFo principle - calculation based on LiFo is not possible.

Reports

The following reports show the historical FiFo supplier price:

Stock Value Hist
Gross Profit Hist