*Confused* Please help.

When using the Transactions/Physical Inventory/Enter-Edit Physical Inventory and the quantity is changed, the adjusted unit cost automatically changes as well.

If we export our physical inventory worksheet and change the quantity, are we suppose to manually enter an Adjusted Unit Cost?

I don't understand why the unit cost would change at all because if an item is lost, the cost for that item should also be lost, leaving the average unit cost on the remaining quantites consistent.

We have 4 stocking locations and we're thinking of exporting the worksheets, entering the new quanties, then importing. Using this method, my question is, how do I post new quantities at each branch location and keep the average unit cost correct in the end? Do we have to enter anything in the adjusted unit cost column at all? Or will Adagio add the cost of each added quantity and subtract the cost of each lost quantity automatically? Therefore keeping the average unit cost of the remaining inventory consistent. Unless there are no quanities left at any location on an item in which case the average unit cost should go to zero.

Also, can the lots be merged to one before we start so we can work with one average unit cost instead of trying to deal with inconsistencies from lot to lot on top of everything else?