inventory register changes from month to month

This thread is now closed to new comments.
Some of the links and information provided in this thread may no longer be available or relevant.
If you have a question please start a new post.
Tina1959
Experienced Cover User
67 Posts
Experienced Cover User
Australia
Experienced Cover User

67Posts

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
Steven_M
MYOB Moderator
40,446 Posts
MYOB Moderator
New Zealand
MYOB Moderator

40,446Posts

5,480Kudos

5,972Solutions

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