FILTER FORMULA PROBLEM PLS HELP

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

 

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

 

ANY UPDATE...........................?