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