Report format

Hello fellow and senior programmers. Kindly help me.
How to pull this report format from tally for sales and purchases
Bellow is the format

SALES
Date : stock name: Qty.: Rate: Amt
1/1/23: onion : 3 : 2 : 6

 

you want to fetch using tdl or xml?

 

For a Report that does not exist by default in Tally, one needs to Create a Custom Report using TDL.

 

Check the Movement Analysis report of Tally... you will get the idea how to develop the same