Stock valuation is executed based on the received stock (goods received notes), inventory, or products created by using work orders. There are certain cases when stock cannot be evaluated. Example:
- Company decided to not implement inventory management in MetaKocka and, therefore, will not add any receiving documents.
- For a certain period of time, the sales of particular supplies were negative. However, the inventory management was established again afterwards.
- Shift to inventory management after the particular date. For instance, from 1.3.2023., the company decided to manage inventory and such was conducted. However, after that particular date, the supplies are still returned to the warehouse due to return of goods. Such goods were issued before 1.3.2023 and have no purchase value
- When evaluating a set or service, the service purchasing price should be also taken into account
Note: this feature is not available to all companies. Before applying it, please double-check with our support whether your company has the following enabled:
- warehouse V4
- devRole reportRVCpurchasePricelist
Establishing valuation
The following should be done:
1. Add the purchase price list which contains purchase prices for products and services. A price list can be added manually or it can be imported from Excel, via the API interface, or other methods.
2. Enabling the functionality in Additional settings.
Entering multiple price-lists
It is possible to add multiple price lists which can be used for:
- separate price lists for a certain set of products
- separate purchase values depending on the date range
Example: Purchase price for ''3-year warranty'' was 1 EUR until 31.12.2023. From that date onward, it was increased to 2 EUR. Bearing that in mind, the following price lists will be created: one valid until 31.12.2023 in which products priced at 1 EUR will be added, and another one valid from 1.1.2024 containing products priced at 2 EUR.
Evaluation method
The following evaluation methods are supported:
- No - The price list is not used for evaluation and operates like the functionality is not enabled.
- Only services are evaluated, even if they are part of the set.
- No price (material and service) - Only products and services with no price are evaluated. This means that no price has been given, for example, for goods received note added without price.
- Null price or no price (material and service) - the same as above, however, the price from the price list is also used for products with purchase price of 0.
- All - The price list will be used in any case. The stock value through receiving will not be considered.
Evaluating sets
Depending on the settings, sets can be evaluated as other products on the document.
For instance, a set comprised of "1x iPhone + 3-year warranty", contains 1x iPhone as a product and 3-year warranty as a service. The price of an iPhone and 3-year warranty should be added to the purchase price list.
If the option ''Only services'' is selected, the price for the 3-year warranty service will be found in the price list, while the iPhone price will be determined based on the value in the warehouse. Therefore, the purchase price of the sales product represents the sum of both purchase prices.
In-app usage
RVC report
Evaluation method is taken into account when printing RVC report. In this case, at the right-hand side an additional ''Source'' column will be displayed in which the price source can be found.
Note: evaluation by FIFO method is possible only for invoices older than today.
REST interface reading orders
If REST interface is used to read orders, requesting the return of FIFO/last price from the price list for the product is possible. More information are available at the following link - https://github.com/metakocka/metakocka_api_base/blob/master/docs/documents_get_document_sales_order.md#get_document---sales-order-purchase-prices