Ok, I tried to do an inventory adjustment but it wouldn't let me set the cost. Instead it was using the average cost of all pieces that were in stock. The piece was discontinued so the price went down for them to get rid of old stock. I knew that the piece that was lost was an old one that we paid $32 for - I was unable to reflect this in the adjustment so I decided to try the inventory adjustment worksheet.
Here, the additional inventory I added today at the lower cost was net yet processed so the numbers were incorrect... although this is not a good thing that it doesn't update, this worked out well for me since I wanted to use the old cost. However, it is showing the "Estimated Total Value" is "0.00" in error. From previous experience I know that this is the net value of the adjustments you make, but it's obviously not calculating right... the line item reads:
QTY As Of Date Above: 1
Value As Of Date Above: $32
Adjust QTY by: -1 (entered by me)
New Value: 0.00
So the Estimated Total Value is "-32.00" in reality, but NS shows "0.00". If you edit the record and hit refresh it shows a value of -32.00, but then when you save the record it goes back to 0.00.
Is that value of 0.00 saved as part of the adjustment record or is it just an incorrect calculation for display purposes? So, does this bug mess up my accounting numbers or is that number just an after-the-fact calculation that is done incorrectly?
When I refresh and the number changes to -32.00 then I save, the "record has not changed" message comes up so I'm thinking that perhaps that number is not saved? Otherwise if it was already saved as 0.00 and the new value is -32.00 then the record would not be the same and that message wouldn't appear?
Jacob
*edit* Looks like the Inventory Worksheet does update but only shows inventory changes made that day if you choose "Last Transaction of Day" for the "Order in Day" field. I guess it's a good thing I made the adjustment on the same day as adding the new stock because otherwise I wouldn't have been able to make $32 the cost of the adjustment and would have had to use the average cost of current inventory...