Forum Discussion

thedannorris's avatar
thedannorris
Contributing User
2 years ago

Current value of an inventory item discrepancy between items register report and items register

Hi friends. We have a weird issue with some of our inventory. For some reason the value of certain items is overstated by thousands of dollars. If you look at this screenshot below it shows the Items Register report for an item. The first transaction on 14 March 2024 we buy 11,040 units of it for $7,838 and it correctly shows the overall value to be $7,838. However in the Items Register it shows the current value to be $12,544.90. I can't understand how (a) the value is that high when it should just be $7,838 and (b) how the Items Register could be showing one value and the Items Register report is showing another value. Any ideas?

 

 

8 Replies

  • Hi thedannorris 

     

    Unfortunately this is common in AR2024 files - there are still far too many bugs in the inventory module. Basically ignore the inventory register reports, in most cases they are wrong! The actual value for an item's on hand count and value is in the Item Profile screen and in the Inventory Value Reconciliation report. Use these as the basis for any adjustment etc, as these are the figures MYOB will use for transactions. Do an Inventory Adjustment Journal to fix item on hand count or value. This will ensure COS calculated on subsequent sales is accurate. 

     

    While tempting to edit existing transactions to try to fix an error - many find this only makes the situation worse. If you have ongoing issues in inventory that you cannot resolve, get in touch with MYOX Services, they specialise in fixing these types of things.

     

    Regards

    Gavin

    gavinw222@gmail.com

     

     

  • thedannorris's avatar
    thedannorris
    Contributing User
    2 years ago

    Wow I really hope that's not right, inventory is the only reason we use MYOB lol! I agree trying to fix it kind of broke everything, what a mess. Any idea how to fix the issue of that starting value in the item register being so far wrong? I assume that's the value that the Balance sheet uses?

  • thedannorris's avatar
    thedannorris
    Contributing User
    2 years ago

    Also funnily enough The value on the Balance sheet is the exact same as the number from the Items Register Detail Report and not the value from the Item Profile so it looks like the Balance sheet is using the numbers in the Items Register Detail Report which are the right numbers. So it's just the value in the item itself that is wrong and it's all caused by that initial value being wrong. 

  • gavin12345's avatar
    gavin12345
    Ultimate User
    2 years ago

    Hi thedannorris 

    You haven't shared the Item Profile screen (please do) to show the value of the item. And how can you tell that the value on the Balance Sheet is the exact same as the number from the Items Register Detail Report ($5037.88) unless this is the only item you have.

     

    With Inventory there are 2 key values - the account balance of the inventory asset account (1.xxxx) which appears on your financial statements, and the values of all items stored in the Item Register. The 2 should match, however in your case it is unlikely that they do. Generate an Inventory Value Reconciliation (IVR) Report - this shows you the on hand count and value of all items as per the Items Register, and it also shows you the balance of the Inventory asset account, as well as any discrepancy. Any discrepancy should be resolved - just as you would for the Sales Register and Trade Debtors account balance. etc.

     

    Attach a screenshot of the section of the IVR that shows this item's on hand count and value as per the register, as well the the Item Profile screen showing on hand count and value, also discrepancy at end of IVR report for the account used by this item.

     

    Regards

    Gavin

  • thedannorris's avatar
    thedannorris
    Contributing User
    2 years ago

    I can tell because I add up the real value of all of our green beans which is consistent with what is shown on the report and it equals what is on the balance sheet. 

  • thedannorris's avatar
    thedannorris
    Contributing User
    12 months ago

    I'm replying here again, we resolved the issue by putting in some adjustments, however it has arisen again and I can't work out why. 

     

    We put through a build for our Coastal blend which included Brazil 2 among other beans and it went through at the correct price of $8.65, however now Brazil is showing at $39 / kg because the overall value is massively overstated. It must have been correct when we first did the build, otherwise those numbers wouldn’t be right. We deleted the build and still shows incorrectly.

     

    When I look at all beans in this analysis I can see that the actual value of our beans is $21,700 but adding them all together the value is $33,700, so it’s out by $12,000. 

     

    I can’t see anything in any report that tells me why MYOB thinks the Brazil bean is worth $8,000 when it should be worth $2,000. Any ideas on how I can see how and why it’s gotten to this state? Or a recommendation for a consultant to help, I’m clearly out of my depth!

     

  • thedannorris's avatar
    thedannorris
    Contributing User
    12 months ago

    Also one other thing I noticed is these issues seem to come up when we put an inventory build through and instead of putting today's date we accidentally leave it on whatever default date is in there which is sometimes a week or so in the past. When we go in and fix the date up it doesn't fix things, and if we delete the build it still doesn't fix the overstated inventory value. So I'm wondering if when we put a build through, it's updating some other part of MYOB that we need to undo whenever we need to delete a transaction that isn't right?

  • Earl_HD's avatar
    Earl_HD
    MYOB Moderator
    11 months ago

    Hi thedannorris ,

    My apologies for the late response. I recommend reaching out to our virtual assistant, MOCA, as this issue may require individual assistance on the backend. Give it a try! You can engage with MOCA through myob.com/support for any queries or assistance you might need. If MOCA can't provide the help you need, our live chat team is available to pick up from where MOCA left off.

    Regards,
    Earl