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.*

DOT in Ledger Name

Case I - Works Fine
Ledger Name: Arihant Industries
SELECT Statement : Select $Name,$Parent From Ledger where $Name="Arihant Industries"

Case II - Does not Work
Ledger Name: Arihant Industries.
SELECT Statement : Select $Name,$Parent From Ledger where $Name="Arihant Industries."

Remarks:-
1) In Case II, the Ledger Name contains a dot (.) in the Ledger Name (viz Arihant Industries.). Using the SELECT SQL to search for the ledger name containing dot returns no result.
2) To resolve the issue, search for "Arihant Industries" (i.e. remove the dot from the Ledger Name)