@bgolfer
I believe you can just enter an amount in the Avg. cost field and click save, no? That will generate an adjustment memo that will update the inventory valuation. I'm going by memory here, so... Hopefully, someone smarter than me can chime in.
