I am not able to create a report showing Item Code, Date, Qty sold, Location from where the material was dispatched, Customer details, Amount (Value).
In accordance with the FAQ, post the Edit screen for your best attempt and the results.
Starting balance also does not show in the report
Custom reports are a selection of the recorded transactions for the period and Where clauses
You have not selected the information you said you want in the report. For example, giving the unit name the alias of location does not make unit name a location. And what does a starting balance have to do with what you want?