Forum Discussion

FionaMiriam's avatar
FionaMiriam
Experienced Cover User
3 years ago
Solved

Current Value & Average Cost N/A

Hi   I went into an item that we have stocked for years. We just currently do not have any stock on hand or on order.   In the Current Value and the Average Cost there is N/A - see attachment for...
  • FionaMiriam's avatar
    FionaMiriam
    3 years ago

    Hi Komal

     

    Checked our orders, all bills had been converted so that wasn't the issue.

     

    I managed to fix it by doing an inventory journal and adding an item of stock and then removing that item. When I did that it came up with the stock value of $0.01, which would make it a rounding error when the original stock got to zero and MYOB has then thrown an error.

     

    I have not found it on any other item code, so I am going to assume it was something to do with your cost of goods error and then the subsequent 'fix' that was done, or how MYOB is calculating rounding errors.

     

    We are finding lots of anomilies with rounding errors in our sales invoicing as well, but I will start another post about that.

     

    Thanks

Komal_S's avatar
Komal_S
MYOB Staff
3 years ago

Hi FionaMiriam 

If your file is online, we can run a script to reset the current value and average cost to zero for items with zero quantity. Please send me your product serial number and company file name by Private Message so I can arrange it.

FionaMiriam's avatar
FionaMiriam
Experienced Cover User
3 years ago

Hi Komal

 

Do you know what / how this issue has occured? So far I've only seen it on one item card file. I would like to know how this has happened so it can be prevented from happening again.

 

Can you also verify that the information you have requested is appropriate to give to you.

 

Thanks

  • Komal_S's avatar
    Komal_S
    MYOB Staff
    3 years ago

    Hi FionaMiriam 

    This can happen if a previous purchase flow is incomplete. If there are any orders with received items, they must be converted into bills. To convert fully received order items, open the purchase register, click the orders tab, highlight any purchase orders that have the received tick, and press the change to bill button. If it has at any stage happened in the past, it can result in NA values.

    With regards to sending the information, we, MYOB Moderators are MYOB employees, so sending the information through to us is secure. 

    • FionaMiriam's avatar
      FionaMiriam
      Experienced Cover User
      3 years ago

      Hi Komal

       

      Checked our orders, all bills had been converted so that wasn't the issue.

       

      I managed to fix it by doing an inventory journal and adding an item of stock and then removing that item. When I did that it came up with the stock value of $0.01, which would make it a rounding error when the original stock got to zero and MYOB has then thrown an error.

       

      I have not found it on any other item code, so I am going to assume it was something to do with your cost of goods error and then the subsequent 'fix' that was done, or how MYOB is calculating rounding errors.

       

      We are finding lots of anomilies with rounding errors in our sales invoicing as well, but I will start another post about that.

       

      Thanks

      • Komal_S's avatar
        Komal_S
        MYOB Staff
        3 years ago

        Hi FionaMiriam 

        Thanks for providing additional details. I'm glad it was fixed by doing an adjustment and do agree it could be one-off. That said, I will also pass this on to our development teams, please feel free to post if you get similar issues again with other item codes. 

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Level up your skills using MYOB software.

 

Find help guides and technical solutions for all MYOB products here

Explore video tutorials for our software at the MYOB Academy here

 

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.