How to Fetch all values from Receipt

Dear Experts.,

I tried to fetch all values from Receipt using select query., This sql query works fine but i don't know how to fetch agst.ref bill no and agst.ref bill amount., here i include my select sql query as well as collection also., please give me some solution for this problem.,


SELECT SQL QUERY
---------------------------------
Select $Date,$Reference,$VouchertypeName,$PartyLedgerName,$$CollectionField:$Amount:1:LedgerEntries from VouchersCol where $$IsReceipt:$VoucherTypeName
COLLECTION
---------------------
[Collection: VouchersCol]
Type : Vouchers
IsODBCTable: Yes
Fetch : *,AllLedgerEntries.*,LedgerEntries.*


Thanks.,

 

use Filters

[Collection: VouchersCol]
Type : Vouchers
IsODBCTable: Yes
Fetch : *,AllLedgerEntries.*,LedgerEntries.*,BillAllocations.*
Compute : Billno : $LedgerEntries[1].BillAllocations[1].Name
Filter : <Your conditions to check Bill by Bill Ref.no.>

 

Thanks for your valuable reply., this collection working fine but i got only first bill no., can i get full list of bill no instead of this $LedgerEntries[1].BillAllocations[1].Name (like $$FullList:AllLedgerEntries:$LedgerName)?

 

Keep this as Source Collection

[Collection: VouchersCol]
Type : Vouchers
IsODBCTable: Yes

Create a new collections like this

[Collection : VoucherBillColl]
Source Collection : VouchersColl
Walk : AllLedgerEntries,BillAllocations
by : Name : $Name

Repeat this collection in your report (VoucherBillColl)


you will get all details in BillAllocations Collection of a voucher.

 

Need help on above collection I need all receipt details against each bill i.e. receiptno, receiptid, receiptmode, receiptChequeNo, receiptchqdate.Please help on achieving it

 

sir how we can increse company font size in voucher printing plzzz