N/A Inventory Value

 Hi Naz2, 
 
Thanks for your post and welcome here to the Community Forum. We are sorry to hear that you are having difficulties due to the N/A value of your item inventory. We appreciate your understanding during this time. 
 
To investigate this further with you, I will be sending a private message to you requesting the necessary information. To access this, please click on your forum display picture in the top right-hand corner of your screen, then choose the envelope icon that appears. 
 
 
Please do not hesitate to post again if you need help in the future. 
 
Cheers,   
Leneth

Hi Naz2,

Thank you for the information. 
 
I have checked your account, and I can see that your company file is offline. 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 have only Partially received items or when you convert the order or bill the partial order, you will need to update the order quantity to match 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 
 
 
Please do not hesitate to post again if you need help in the future. 
Regards,
Earl