inventory register changes from month to month

Highlighted
Experienced Cover User
66 Posts
Experienced Cover User
Australia
Experienced Cover User

66Posts

12Kudos

0Solutions

Solved: Go to Solution

inventory register changes from month to month

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.

 

1 REPLY 1
Highlighted
MYOB Moderator
38,219 Posts
MYOB Moderator
New Zealand
MYOB Moderator

38,219Posts

5,195Kudos

5,611Solutions

Accepted Solution Solved

Re: inventory register changes from month to month

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.

Kind regards,
Steven

MYOB Community Support

Online Help| Forum Search| my.MYOB| Download Page

Did my answer help?

Mark it as a SolutionHelpful? Leave a to tell others

Didn't find your answer here?

Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post