Inventory Quantity or Value report

Good day,

Need assistance in creating a query with the query generator.

Basically I want to get inventory quantity or value report on any one specific date selected, by weekly, by monthly (showing what the inventory was at the beginning of the week/month).

Including amount sold, received, and adjusted during the selected weeks and item, brand, vendor, and category.

Any assistsance would be appreciated.

Thanks.