Thanks for your reply. Please see my comment in the attached stock movement list, and amend accordingly. Thank you.
Opening balance + write back - provision=closing balance
Raw mat and WIP have to be separately add or minus respective provision in order to get each other closing balance.