inventory register changes from month to month

Tina1959

I have a strange problem.

My average cost is way wrong and have no idea why - all purchases coming in are correct but the total value of the inventory is much more than we pay for it.

If I look at the inventory register for the period of eg Dec 2019 it give me a current on hand value on 2nd December of approx $7000. this is the opening entry for the period.

 

If I look at  the period Decmber to January - the same entry for Dec 2nd is now $8600. How can the value change like this - it is still the opening entry - it just now has the month of January added after the december entries.

 

It gtes worse - if i have negative stock on hand the value of stock instead of being negative is postive and bears no relation to anything that we pay for this stock. 

 

so I have the value of my stock being meaningless how do I fix it.

 

Steven_M

Hi @Tina1959 

 

It sounds like you are impacted by how the Item Register window generates its values. In short, it will take the current amounts and then work up the screen to determine the first line. As such, if you are updating the To date it can impact how that window will display the first line. Ideally, you want to run that window with a future date i.e. 31/12/9998. This will give you the accurate values within that window as its using the full data to determine the item amounts.