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 

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

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