I wasn't aware of that. Where is it? I'd like to look at it.
It is unlikely that it will work as total solution for us since we have to calculate the standard cost as well which is also based on the avg unit cost. Our mark up from Avg Unit Cost is not the same across the board. It is dependant on many factors. We update both the standard cost and base price as we receive new product based on the avg unit cost.
The automated function you mentioned might be useful however as a tool to confirm whether we've missed anything.
_________________________
Susan Tennier
TDL Canada
Trenton, Ontario