Batches and Serials Stock Audit Query Report

Greetings,

Hi, i am not good in writing a query, appreciate if someone can provide me a query report as below:

Whse, Item No, Serial/ Batch No, Mfr Serial No, Current Serial/ Batch No Cost, Opening Qty, Opening Value, Closing Qty.

Thank you

Regard

Ng