CAN ANYONE CORRECT THIS $$ COLLECTION $$

THIS COLLECTION IS SHOWING IN BOTH PURCHASE AND SALES REGISTER I WANT ONLY IN SALES REGISTER !! CAN ANONE HELP !!

EXAMPLE

[#Collection : Columnar Filtered Vouchers of COMPANY]
Fetch : SMAAMT,SWAAMT,CASSHAMT

[#Collection: Columnar Vouchers of LEDGERS]
Fetch : SMAAMT,SWAAMT,CASSHAMT

 

[#Collection : Columnar Filtered Vouchers of COMPANY]
Fetch : SMAAMT,SWAAMT,CASSHAMT
Filter : myVoucherTypeFiltr

[#Collection: Columnar Vouchers of LEDGERS]
Fetch : SMAAMT,SWAAMT,CASSHAMT
Filter : myVoucherTypeFiltr

[System : Formula]
myVoucherTypeFiltr : $$IsSales:$VoucherTypeName

 

its working in sales register !! but in purchase register showing blank if we go in list of purchase vouchers

 

Try
myVoucherTypeFiltr : ##VoucherTypeName =$VoucherTypeName

##VoucherTypeName is variable which is which is changed depending upon the report opened.

or you can use your own variable to do the same

 

;---------------------

[#Collection : Columnar Filtered Vouchers of COMPANY]
Fetch : SMAAMT,SWAAMT,CASSHAMT
Filter : myVoucherTypeFiltr

[#Collection: Columnar Vouchers of LEDGERS]
Fetch : SMAAMT,SWAAMT,CASSHAMT
Filter : myVoucherTypeFiltr

[System : Formula]
myVoucherTypeFiltr : ##IsSales =$VoucherTypeName ; ---- FOR SALES REGISTER