Fetch data from Tally

Fetch Sales data from Tally

Select $Date,$Reference,$VouchertypeName,$PartyLedgerName,$$CollectionField:$Amount:1:LedgerEntries from RTSAllVouchers where $$IsSales:$VoucherTypeName

Fetch Payment data from Tally

Select $Date,$Reference,$VouchertypeName,$PartyLedgerName,$$CollectionField:$Amount:1:LedgerEntries from RTSAllVouchers where $$IsPayment:$VoucherTypeName

Fetch Receipt data from Tally

Select $Date,$Reference,$VouchertypeName,$PartyLedgerName,$$CollectionField:$Amount:1:LedgerEntries from RTSAllVouchers where $$IsReceipt:$VoucherTypeName

PS:
The above requires TDL code which is given underneath :-

[Collection: RTSAllVouchers]
  Type: Voucher
  IsODBCTable: Yes
  Fetch : *,AllLedgerEntries.*,LedgerEntries.*