Material Reconciliation in Zoho Creator

Material Reconciliation in Zoho Creator

I have created a Zoho Creator app for my purchase and production. Now I want to create ledger for material code that is Receipt and Consumption and Balance for a particular period.

I don't know how to achieve this.