Base Value on Balance

Under Base value on balance you can select different balance alternatives for parts, multiplied by the price that is the inventory value basis (this does not apply when using the Total/month list type). The balance types that can be selected here are:

• Current – use this option if the inventory value should be calculated based on the part's current balance.
• Inventoried – use this if the inventory value should be calculated based on the part’s last inventoried balance. This alternative is used together with selecting parts by Inventory date.
• Historical – to use this alternative, you must also enter a date for the historical balance in the date field that appears. This alternative should be selected if you want the inventory value to be calculated for a historical balance on a certain date for the parts.. If there is no reported balance in the inventory log on the date you enter, the system will apply the balance for the previous date closest in time. Also note that a selection by location, if any, will not affect the historical balance.
• Show zero balance – check this alternative if you also want to include parts that have a zero balance in your list.

Please Note! If a part has a negative balance, the system will calculate a negative inventory value for that part! There are different opinions regarding whether this principle is correct or not. Some users think that it is the right way to calculate, while others would prefer to have the inventory value set to zero (0) for parts that have a negative balance. If a part has a negative balance, it indicates that different reports, arrivals or stock withdrawals were not properly carried out, or that they are not in sync with each other. That is why it is recommended to make sure that the current balance is correct, before you perform any inventory value calculations on a balance alternative.

of