Inventory item current value and average cost showing as N/A

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.
Hi_Ursula
Contributing User
6 Posts
Contributing User
Contributing User

6Posts

0Kudos

0Solutions

Solved: Go to Solution

Inventory item current value and average cost showing as N/A

Hello, 

 

I am getting the following message when trying to load a purchase: Processing this purchase would leave the item with a positive on hand quantity and a negative value in inventory. 

 

The system shows there is 1.3 items on hand but the current value and average cost are showing as N/A. 

 

Can you please help.

Kind regards

Ursula

1 REPLY 1
Komal_S
MYOB Moderator
8,280 Posts
MYOB Moderator
MYOB Moderator

8,280Posts

741Kudos

1,164Solutions

Accepted Solution Solved

Re: Inventory item current value and average cost showing as N/A

Hi @Hi_Ursula 

 

So we can investigate further, can you please check the following: 

 

A. Check if the purchase workflow has been completed. 

If there are any orders with received items, they must be converted into bills.

Note: If you've only Partially received items or when you convert the order or you have to bill the partial order, you will need to update the order quantity to match with the received quantity. The pending to receive items must go in a new order.

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.




The Bill will appear on the screen, press record to complete the process.


Check the item values/average cost are now showing correctly, if not move into the next step below.

B. Check for negative on-hand quantities 

 

Go into the Item List then the Inventoried tab. Click the On Hand header, to sort by On hand.
Ensure no items have a Negative On Hand balance. If they do, we can run some scripts to fix the issue for which we will need your serial number. 

 

Check the item values/average cost are now showing correctly, if not move into the next step below.


C. Check for invalid amounts in the Inventory Value Reconciliation

Run the Reports>Inventory>Items>Inventory Value Reconciliation and look for any invalid amounts.

Invalid amounts are: any negatives, 0 On Hand and a Value or any On Hand and $0.00 value

If there are any invalid amounts or if none of the above steps work, please send us your serial number by a Private Message so we can run the scripts. 

Kind regards,
Komal

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