HOW TO FILTER LEDGER OF THOSE INELIGIBLE FOR INPUT CR SET TO "YES"

Discussion in 'Requests' started by sattam, Mar 16, 2023.

    
  1. sattam

    sattam Active Member


    Dear expert please help

    I want to filter those ledger master of which is ineligible for input tax credit is set to "Yes"
     



  2. Can you explain the Issue with an example ?
     


  3. sattam

    sattam Active Member



  4. sattam

    sattam Active Member


    Please look at above picture

    in ledger master "Is ineligible for input credit :Yes"
    Now I want to filter those ledgers which ineligible for input credit is set to "yes"

    [Collection:My led coll]
    Type:Ledger
    filter: ???????

     



  5. By Creating a New Voucher Type (as per requirement for this type of Transaction). Will serve your purpose ?
     


  6. Bipin Damania

    Bipin Damania Active Member


    Try this..

    Code:
    [Collection : My Ledgers]
        Type : Ledger
        Filter: IsIneligible
       
    [System : Formula]
        IsIneligible : $GSTDetails[@@LastIndes].GSTInEligibleITC="Yes"
    
    upload_2023-3-20_16-36-44.png
     


  7. sattam

    sattam Active Member


    what is the formula
    @@LastIndes
     


  8. sattam

    sattam Active Member


    thanks Bipinji
    I got it
    ($GSTDetails[Last].GSTInEligibleITC)="Yes"
     


Share This Page