---
title: "Inventory Valuation - Technical info & FAQs"
canonical: "https://wiki.soft1.eu/space/SS5EN/189268995/Inventory%20Valuation%20-%20Technical%20info%20%26%20FAQs"
format: markdown
---
| <span style="color: #ffffff">**Questions**</span> | <span style="color: #ffffff">**Answers**</span> |
| --- | --- |
| **At Item Transactions, which is the difference between the  fields "Inv. [In] qty" & "Invoiced [In] qty"?** | Quantities imported in the Warehouse, e.g. from Purchases Documents, do not necessarily need to be invoiced.<br>More specifically,<br>- a Delivery Note from a Supplier will increase the Inventory [In] Quantity & Inventory [In] Value in Warehouse.
- a Delivery Note - Invoice from Supplier will increase the Inventory [In] Quantity & Inventory [In] Value in Warehouse. At the same time, the specific Quantity & Value will affect the Invoiced Quantities & Values regarding Valuation.<br>In SOFT1 ERP, the default configuration for Inventory Transactions has been designed targeting the correct presentation of results (quantity & value) in the Warehouse.     
Specific aggregates/ fields *(Inv. In quantity etc) *are taken into account to calculate the inventory valuation, which does not mean that you have to modify the transactions suggested by the SOFT1 ERP default configuration.  See at Valuation Methods tab - Examples, which aggregates are used to calculate the cost prices. |
| **Can I change the Valuation Method during a fiscal year?** | <span style="color: #172b4d">It is not recommended to change the valuation method in SOFT1 ERP if any transactions have been made during the fiscal year.  Once you have determined the stock items value at the end of the fiscal year, then you can change the valuation method for the next one. </span> |
| **At Item "Financial Data", which is the difference between the "Current" and "Last" cost prices?** | If you select "Last" you will see how the cost has been modified according to the most recent calculations.<br>If you select "Current" you will see how the cost has been modified according to the transactions made in SOFT1 ERP in case another valuation method had been used.<br>![image]() |
| **Which is the table in the database that includes the cost prices calculated by SOFT1 ERP?** | In MTRCPRICES table you will find the cost prices per valuation method.<br>In MTRBALSHEET table, the aggregates affected by the inventory transactions are included by company, fiscal year, period and warehouse.<br>In MTRTRN table the data, based on transactions made in SOFT1 ERP, are included. |
| **Which methods are calculated at months/periods level (e. g.  February, March etc. ) and which methods are calculated based on transactions/documents saved in SOFT1 ERP? ** | At months/ periods level & according to transactions/ documents created in SOFT1 ERP(MTRBALSHEET table): Annual Weighted Avg, Monthly Avg & Quarter Avg,<br>Exclusively based on transactions/ documents created in SOFT1 ERP: Last Purchase Price, Moving Avg. |
| **How can I manage Discount Credit and Return Notes?** | Based on the selected valuation method, the Credit Notes should update the proper aggregates.<br>For example, if you have selected the Annual Avg as a valuation method, then the Credit Note should reduce the Invoiced Value and Quantity of Imports. |
| **If I have Delivery Notes which include quantities of items not yet Invoiced, how can I calculate the stock items cost including the specific quantities * values?** | If you wish the items' data (quantity, value), which participate in Delivery Notes, to be included in the calculation of stock items then you should save/ post Forecast Documents.<br>Once the Invoicing of items (quantity, value) which participate in Delivery Notes, results, then you can cancel/delete the Forecast Documents. |
| **How is the cost price modified upon the beginning/ opening of the Fiscal Year?** | At the beginning/ opening of a Fiscal Year, at the Op. Balance period, the cost modified according to the transactions made during the previous fiscal year, will be displayed. The Op. Balance is considered as an autonomous operation/ action.<br>To calculate the cost in January, SOFT1 ERP does not transfer the cost prices from the Op.  Balance period, but it is modified according to the values and quantities within the Op.  Balance period. |