Pickware ERP offers you three valuation methods for your stock:

In the Plugin Configuration of Pickware ERP, you can set the desired valuation method for your shop. By default, the LIFO principle is preset. You'll find details on the individual methods and the general calculation of valuated stock further below in this article.

Note: Non-stock-managed products are not taken into account in the valuation.

Under Products (Artikel) → Warehouse (Lager) → Valuated Stock (Bewerteter Warenbestand), you can view, save, and export your valuated stock as a CSV file.

With the Generate Preview button, you can value your stock at any time for the selected reference date. Whether the data displayed is a preview or a saved report is shown at the top in the header.

To permanently save the report in your database, click Save as Report. Saved reports remain accessible even if the products they contain are later deleted. That's why we recommend saving the preview as a report at the end of a reporting period, for example at the end of the fiscal year.

Valuation can be carried out using LIFO, FIFO, or the average purchase price of the period. All valuation methods have in common that, at the end of a reporting period, the existing stock, including its valuation, is transferred to the next reporting period ("carry-over") and booked there as goods receipt. Since all goods receipts require a purchase price, the plugin uses the average valuations from the previous period for this purpose.

In principle, the valuation is based on the stock currently held in the warehouse and all goods receipts within a valuation period. The carry-over from the previous period mentioned above (if available) also counts as a goods receipt. Accordingly, in the first valuation period, all goods receipts before the reference date are taken into account.

Depending on the valuation method, the calculation results as follows:

LIFO:

Here, the newest goods received (= last in) are removed from the warehouse first (= first out). The older goods receipts thus remain in the warehouse and are added up for the calculation of the valuated stock until the current stock level is reached.

FIFO:

Here, the oldest goods received (= first in) are removed from the warehouse first (= first out). The newer goods receipts thus remain in the warehouse and are added up until the current stock level is reached.

Average Purchase Price:

The current stock is multiplied by the average purchase price of the period. The average purchase price is calculated as follows:

To illustrate this, here's a concrete example.
​

Depending on which method was chosen, the calculation results as follows: