Dear All TDL Expers, Please any one can Help Me, I have created one UDF in Sales Voucher for mention the sales man. I need to generate the report Salesman wise consolidated sold items Name and its billed qty like below mentioned. Sales Man - A Item - A 100 Nos Sales Man - B Item - A 2000 Nos i have tried but i got the result as follow Sales Man - A Item - A 2100 Nos Sales Man - B Item - A 2100 Nos I used filter but it is not filtering. Kindly i have attached the code. please kindly help and guide me. Thanks in Advance.
Dear Mutharasan, I add Voucher Collection filter codes in "Red" text, so make changes as per below. [collection : SMItemcollection] Type : vouchers : VoucherType Child of : $$vchTypeSales Belongs to : yes Fetch : MysalesMan, Inventoryentries Filter : RMSameSalesManVoucher ;; (You have to add filter else how can your collection knows which vouchers are belongs to which salesman) [System : Formula] RMSameSalesManVoucher : $MysalesMan = #salesmanNameField With above changes you get solution. Regards, Ritesh Mehta
