kinldy check my udf filter not working

Discussion in 'Free Source Codes' started by GOINDI1311, Dec 19, 2022.

    
  1. GOINDI1311

    GOINDI1311 Member


    [Button:ABFDMonthFilter]
    Key : F6
    Action : Execute : ABFDMonthFilter
    Title : Month

    [Report:ABFDMonthFilter]
    Form : GSTR 2B
    Set : ABFDMonthName : ""


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

    [Part:ABFDMonthFilter]
    Line : ABFDMonthFilter

    [Line:ABFDMonthFilter]
    Field : Medium Prompt,ABFDMonthFilter
    Local : Field : Medium Prompt : Set as : "Select Month : "

    [Field:ABFDMonthFilter]
    Table : ABFDMonthFilter,EndOfList
    ShowTable : Always
    Use : Name Field
    Width : 20
    Border : Thin Box
    Variable : ABFDMonthName
    Modifies : ABFDMonthName

    [Variable:ABFDMonthName]
    Type : String

    [Collection:ABFDCollection2]
    Type : Voucher
    Fetch : MNTH


    [Collection:ABFDMonthFilter]
    Title : "List of Month"
    Type : Voucher
    Belongs To : Yes
    Fetch : MNTH
    Format : $MNTH,25


    [System:Variable]
    ABFDMonthName : ""


    [System:Formula]

    ABFDFilter : $mnth=@@ABFDMonthFill
    ABFDStateFill : if ##ABFDMonthName="" OR $$IsEmpty:##ABFDMonthName then $MNTH Else ##ABFDMonthName upload_2022-12-19_17-1-6.png upload_2022-12-19_17-1-6.png
     


  2. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    1] Status, Month & Year UDF Value Store in Voucher
    2] GSTR2B Report Variable Set as No
     


  3. GOINDI1311

    GOINDI1311 Member


    1] Status, Month & Year UDF Value Store in Voucher : YES PANKAJ JI

    [Field: Month]
    Use : name Field
    Setas : $Month
    Storage : Mnth
    Table: MonthTABLE, End of List
    Show Table:Always
    Align: Left

    [Table:MonthTable]
    List:April,May, June,July,August,September,October,November,December,January,Febuary,March

    [System:UDF]
    Mnth:String:2458

    =======================================
    2] GSTR2B Report Variable Set as No : VARIABLE SET AS

    upload_2022-12-19_18-23-10.png
     


  4. sattam

    sattam Active Member


    what is the definition @@ABFDMonthFill
     


  5. GOINDI1311

    GOINDI1311 Member


    ABFDMonthFill : if ##ABFDMonthName="" OR $$IsEmpty:##ABFDMonthName then $Month Else ##ABFDMonthName
     


  6. sattam

    sattam Active Member


    c
    check your system formula there is a mistake ABFDStateFill
     


  7. GOINDI1311

    GOINDI1311 Member


    upload_2022-12-20_11-51-19.png

    upload_2022-12-20_11-51-36.png

    upload_2022-12-20_11-51-50.png

    BUT MY REPORT IS NOT FILTERING AS PER THIS CODE PLS CHECK



    [Button:ABFDMonthFilter]
    Key : F6
    Action : Execute : ABFDMonthFilter
    Title : Month

    [Report:ABFDMonthFilter]
    Form : ABFDMonthFilter
    Set : ABFDMonthName : ""


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

    [Part:ABFDMonthFilter]
    Line : ABFDMonthFilter

    [Line:ABFDMonthFilter]
    Field : Medium Prompt,ABFDMonthFilter
    Local : Field : Medium Prompt : Set as : "Select Month : "

    [Field:ABFDMonthFilter]
    Table : ABFDMonthFilter,EndOfList
    ShowTable : Always
    Use : Name Field
    Width : 20
    Border : Thin Box
    Variable : ABFDMonthName
    Modifies : ABFDMonthName

    [Variable:ABFDMonthName]
    Type : String

    [Collection:ABFDCollection2]
    Type : Voucher : $$IsPurchase or $$IsDebitNote
    Fetch : Mnth


    [Collection:ABFDMonthFilter]
    Title : "List of Month"
    Type : Voucher
    Belongs To : Yes
    Fetch : Mnth
    Format : $Mnth,25
    Filter : ABFDMonthFilter2


    [System:Variable]
    ABFDMonthName : ""

    [System:Formula]

    ABFDMonthFilter2 : $Mnth=@@ABFDMonthFill
    ABFDMonthFill : if ##ABFDMonthName="" OR $$IsEmpty:##ABFDMonthName then $Mnth Else ##ABFDMonthName
     


  8. sattam

    sattam Active Member


    use filter ABFDMonthFilter2 in your main report collection
     
    GOINDI1311 likes this.


  9. GOINDI1311

    GOINDI1311 Member


    THANK YOU SATTAM SIR JI, IT WORKING FINE NOW
     


Share This Page