Filter Button Not working

Discussion in 'Free Source Codes' started by Partha Mondal, Mar 16, 2023.

    
  1. Partha Mondal

    Partha Mondal Member


    Dear Amit Sir,

    My Filter button is not working. Can you help me sir.



    ;;;; Making a AMC Register ;;;;;

    [Report : AMC Register]

    Form : AMC Register
    Title : "A M C - R E G I S T E R"
    Set : SVFromDate : $$FinyearBeg:##SVCurrentDate:$Startingfrom:Company:##SVCurrentCompany
    Set : SVToDate : ##SVCurrentDate
    Set : AMCTypeVar : ""

    [Form : AMC Register]
    Part : AMC_Heading,AMC_Reg_Main
    Button : Change Period
    Button : AMC Type
    Height :100% page
    Width :100% page

    [Part : AMC_Heading]
    Line : AMC_Reg__Heading, AMC_Reg_Period
    Common Border : Yes
    [Line : AMC_Reg__Heading]
    Field : AMC_Reg__Heading

    [Field : AMC_Reg__Heading]
    Set as : "AMC REGISTER"
    Color : Blue
    Style : Large Bold
    Align : Center
    Full Width : Yes

    [Line : AMC_Reg_Period]
    Field : AMC_Reg_Period

    [Field : AMC_Reg_Period]

    Set As : " From " + $$String:##SVFromDate + " To " + $$string:##SVToDate

    Color : Blue
    Style : Large Bold
    Align : Center
    Full Width : Yes

    [Part : AMC_Reg_Main]
    Line : AMC_Reg_Title, AMC_Reg_Details
    Repeat : AMC_Reg_Details : AMC_Reg_Coll
    Scroll : Vertical

    [Line : AMC_Reg_Title]

    Use : AMC_Reg_Details

    Local : Field : Default : Type : String
    Local : Field : Default : Style : Tiny Bold ;Header Title
    Local : Field : Default : Color : Blue
    Local : Field : Default : Line : 2
    Local : Field : Default : Align : Center

    Local : Field : AMCBillNo : Info : "Bill No."
    Local : Field : AMCPartyName : Info : "Party Name"
    Local : Field : PartyMobile : Info : "Mobile No "
    Local : Field : ContractType : Info : "Contract Type"
    Local : Field : R_AMCFrom : Info : "From Date"
    Local : Field : R_AMCTo : Info : "Expires On"
    Local : Field : R_AMC_NextDue : Info : "Contract Next Due Date"
    Local : Field : AMCAmount : Info : "Contract Amount"
    Local : Field : Cont_Status : Info : "Status"
    Local : Field : Pmt_Cont_Type : Info : "Payment Contract Mode"

    Space Bottom : 1
    Border : Flush Totals

    [Line : AMC_Reg_Details]

    Field : AMCBillNo, AMCPartyName, PartyMobile, ContractType, R_AMCFrom, R_AMCTo, R_AMC_NextDue, AMCAmount, Cont_Status, Pmt_Cont_Type, DSPVCHMASTERIDNO
    Option : AlterVchOnEnter : Yes

    [Field : AMCBillNo]
    Use : Name Field
    Set as : $Vouchernumber
    Set Always : Yes
    Align : Center
    Width : 10

    [Field : AMCPartyName]
    Use : Name Field
    Set as : $BasicBuyerName
    Set Always : Yes
    Align : Center
    Width : 20

    [Field : PartyMobile]
    Use : Name Field
    Set as : $Ledgermobile:Ledger:$partyLedgerName
    Set Always : Yes
    Align : Center
    Width : 10

    [Field : ContractType]
    Use : Name Field
    Set as : $AMCTYPE
    Set Always : Yes
    Align : Center
    Width : 12

    [Field : R_AMCFrom]
    Use : Short Date Field
    Set as : $AMCFROM
    Set Always : Yes
    Align : Center
    Width:10

    [Field : R_AMCTo]
    Use : Short Date Field
    Set as : $AMCTo
    Set Always : Yes
    Align : Center
    Width : 10

    [Field : R_AMC_NextDue]
    Use : Short Date Field
    Set as : $AMCNEXTDUE
    Set Always : Yes
    Align : Center
    Width : 10

    [Field : AMCAmount]
    Use : Name Field
    Set as : $TOTCONTAMT
    Set Always : Yes
    Align : Center
    Width : 15

    [Field : Cont_Status]
    Use : Name Field
    Set as : $AMCSTATUS
    Set Always : Yes
    Align : Center
    Width : 6

    [Field : Pmt_Cont_Type]
    Use : Name Field
    Set as : $AMCPMTTYPE
    Set Always : Yes
    Align : Center
    Width : 12

    [Collection : AMC_Reg_Coll]

    Type : Vouchers
    Fetch : Date,Amount,VoucherTypeName,LedgerName,PArtyLedgerName,VoucherNumber, BasicBuyerName, AllLedgerEntries
    Filter : AMCSalesVouchers
    Filter : AMCTypeFilter2

    ;;; Filter Button Creation ;;;;;;

    [Button : AMC Type]

    Title : $$LocaleString:"AMC TYPE"
    Key : Alt+T
    Action : Execute : Change_AMC_Type

    [Report : Change_AMC_Type]
    Form : AMC_Filter
    Set : AMCTypeVar=""

    [Form : AMC_Filter]
    Part : AMC_Filter
    No Confirmation : Yes

    [Part : AMC_Filter]
    Line : AMC_Filter

    [Line : AMC_Filter]
    Field : Medium Prompt, AMC_Filter
    Local : Field : Medium Prompt : Info : "Select AMC Type"
    Local : Field : Medium Prompt : Align : Center

    [Field : AMC_Filter]
    Table : AMC Type
    ShowTable : Always
    Use : Name Field
    Variable : AMCTypeVar
    Modifies : AMCTypeVar
    Width:20

    [Variable : AMCTypeVar]
    Type : String

    [System : Variable]
    AMCTypeVar : ""

    [System : Formulae]

    AMCSalesVouchers : $VoucherTypeName="AMC GST Invoice"

    AMCTypeFilter2 : $AMCTYPE=@@AMCTypeFilter
    AMCTypeFilter : if ##AMCTypeVar="" OR $$IsEmpty:##AMCTypeVar then $AMCTYPE else ##AMCTypeVar
     


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    [Form : AMC Register]
    Local : Field : AMC filter : modifies : AMCTypevaR
     


  3. Partha Mondal

    Partha Mondal Member


    Not working Sir.
     


Share This Page