Ok, so we do run only current inventory valuations, and even with supressing negative qts we are still off by a mile(more than 5%gst).

So, after posting everything and doing my day ends, posting all outstanding items. if I export physical inventory worksheet fields"Item number" "Qty" and "unit cost"(same as Actual cost per unit??). then in a separate excel spreadsheet from inventory I have drawn into excel worksheet "item number" "recent cost" and "qty oh" making sure that qty's are the same, I should be able to replace the "unit cost" with "recent cost" and import physical inventory worksheet back into adagio. Then post varience. Is this going to work??????????
I would do this on the last day of the year with everything else closed off and all other stations offline.

I guess I would put my new #'s in the adjusted cost field and import that back in??

Please do not create multiple forum threads for the same topic. Continuing comments should be added to the existing thread only. There are people who have already responded to your GST #1, GST #2 and GST #3 threads. Please refer to those.

What you are trying to do is best accomplished with the help of your Adagio consultant. This is not the sort of thing that can be dealt with effectively on a forum.