Forum Discussion

FionaMiriam's avatar
FionaMiriam
Experienced Cover User
4 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 screen shot.

 

I have never seen this before. Is this an error with this item's card file? Could this have happened after the 'fix'?

 

Thanks

  • FionaMiriam's avatar
    FionaMiriam
    4 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

5 Replies

Replies have been turned off for this discussion
  • Komal_S's avatar
    Komal_S
    MYOB Staff
    4 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
    4 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
    4 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
    4 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
    4 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.