UNABLE TO FILTER DEBTORS LIST IN REPORT FILE PLS SEE ATTACHED SCREEN SHORT IT SHOULD DISPLAY ONLY AMC EXPIRED.....DEBTORS INSTEAD IT SHOWING ALL DEBTORS NAME... [Collection: myamccollection] Type : ledger Fetch: name,parent,ledgercontact,ledgermobile,ksamcamt,ksdatefrom,ksdateto,ksamcnextdue Child Of:$$GroupSundryDebtors Family: Yes Filter:ins Filter Filter: ins amtfilter [System: formula] ins amtFilter : $ksamcamt>0 ins Filter : $ksdateto>=@@dspfromdate and $ksdateto<=@@dsptodate ins debfilter : is $$inamcled
PLS HELP...FOR THIS ABOVE /* [System: UDF] Minsamcamt: Amount: 300 minsamcfrom : Date: 301 minsamcto : Date: 302 [#Part: LED Contact] Add: Line: My amc line [Line: My amc line] Field: Medium prompt,ins amc amt,ins amc from,ins amc to Local: Field: Medium prompt :set as : "Amc Amt:" [Field: ins AMC FROM] Use: UNI DATE FIELD Set as: $insamcfrom Storage: minsAMCFROM [Field: ins AMC TO] Use: UNI DATE FIELD Set as: #insamcfrom ;;+30 ;;$insamcto Storage: minsAMCTO [Field: ins amc amt ] Use: amount field Set as: $Minsamcamt Storage: Minsamcamt Color: green Storage: minsamcamt */ ;;=============== ;;; Amc Report ;; ;;=============== [#Menu: Gateway of Tally] Add: Item: "Amc Report " : Display : insamcreport [Report: insamcreport] Form: insamcform Object: Company Column Report : inscolumn Repeat : SVCurrentCompany, SVFromDate, SVToDate [Form: insamcform] Part: insamctitile ,insamcpart Button : PRINTBUTTON ,ExportButton ;;, MailButton, UploadButton [Part:insamctitile] Line : insamctitile [Line: insamctitile] Field : Plain SubTitle Local : Field: Plain SubTitle : Set as: "AMC REPORT" Border: thin box [Part: insamcpart] Line : insamcheading,insamcdetails Bottom Line :insamctotal line Repeat : insamcdetails : myamccollection Scroll : Vertical Border : thin box Common Border:Yes [Line: insamctotal line] Use: insamcdetails Local: Field: default : Type: String Local: Field: insamcamt fld : Type: Amount Local: Field: insamcfrom fld : Set as: "TOTAL==>>" Local: Field: insamcamt fld : set as : $$CollAmtTotal:myamccollection:$ksamcamt Border: thick top [Line: insamcheading] Use: insamcdetails Local: Field: default : Type: String Local: Field: ins Srno fld : Set as:"Sr." Local: Field: ins name fld : Set as: "Name " Local: Field: ins Parent fld: Set as:"Group" Local: Field: ins contact fld: Set as:"Cotact Person" Local: Field: ins mobile fld : Set as:"Mobile" Local:Field:insamcexpiry:Set as:"Expiry Date" Local: Field: insamcfrom fld : set as:"From " Local: Field: insamcto fld : Set as:"TO" Local: Field: insamcamt fld : Set as: "AMC AMT." Local: Field: insamcfrom fld : Set as: "From " Local: Field: insamcto fld : Set as: "TO" Border: thick bottom [Line: insamcdetails] Field: ins srno fld,ins name fld ,insamcfrom fld,insamcto fld,insamcexpiry,ins amcamt fld,ins parent fld,ins contact fld,ins mobile fld [Field : ins srno fld] Use:Number field Set as: $$Line Border: thin right Width: 10 MM [Field: ins Name fld] Use: name field Set as: $name Border: thin right Align:Center [Field : ins contact fld] Use: name field set as : $LedgerContact Border: thin right Align:Center [Field : ins Parentfld] Use: name field set as : $parent Border: thin right Width: 20 mms Align:Left [Field : ins mobile fld] Use: name field set as : $LedgerMobile Border: thin right Width:15 Align:Left [Field: ins amcamt fld] use : Amount field Set as: $ksamcamt Border: thin right Width:10 Align:Center [Field : insamcfrom fld] Use: uni date field Set as: $ksamcdatefrom Border: thin right Width: 10 Align:Center [Field : insamcto fld] Use: uni date field Set as: $ksamcdateto Border: thin right Width: 10 Align:Center [Field :insamcexpiry] Use: uni date field Set as: $ksamcdue Border: thin right Width: 10 Color:RED Align:Center /* [System: Formula] MY Filter : $$IsEmpty:ksamcamt */ [Collection: myamccollection] Type : ledger Fetch: name,parent,ledgercontact,ledgermobile,ksamcamt,ksdatefrom,ksdateto,ksamcnextdue Child Of:$$GroupSundryDebtors ; Family: Yes ;Filter:ins Filter ;Filter: ins amtfilter [System: formula] ins amtFilter : $ksamcamt>0 ins Filter : $ksdateto>=@@dspfromdate and $ksdateto<=@@dsptodate ins debfilter : is $$inamcled