Hi,
Thank you for reply.
My client just want to see a list of items, stock balance and the total cost of each items. My consideration now is, should I copy all necessary data into another tables inorder to generate closing report, or.. generate report once user press closing stock button and store the report result only nto table? Any comments?

Thnak you