Help me Change Voucher Class if Turnover Over 50 lakhs.

Discussion in 'Tally Developer' started by Sohail Khan, Jan 16, 2021.

    
  1. Sohail Khan

    Sohail Khan Member


    Dear Experts,
    Please help me Change Voucher Class If Turnover Over 50 Lakhs.
    I use Two Voucher Class namely TCS @ 0.075% and Automatic Entries for non tcs entries.

    [#Field: EI CurrentTurnover]
    Field : Simple Prompt, Simple Field, Amount Forex Field, Short Prompt, TCSEligible
    Local : Field : Short Prompt : Info : $$LocaleString:"TCS"

    [Field: TCSEligible]
    Use : Name Field
    Set as : @@TcsEligible
    Background : @@TcsColor

    [#Field: Chg VchSubType]
    Set as : IF (($CurrentTurnover:Ledger:#EIConsignee) > 5000000) Then "TCS @ 0.075%" Else "Automatic Entries"
    Set Always:Yes

    [System: Formula]
    TcsEligible : IF (($CurrentTurnover:Ledger:#EIConsignee) > 5000000) Then "Eligible" else "Not Eligible"
    TcsColor : IF (($CurrentTurnover:Ledger:#EIConsignee) > 5000000) Then "Green" else "Red"
     


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    So ... what exactly is your problem ???

    Above code.....does not have anything to do with Voucher Class.........

    FYI ........ Voucher class is selected before selection of the Consignee Name........... and therafter the Consignee turnover etc...............
     
    Last edited: Jan 16, 2021
    Jaydeep Shah likes this.


  3. Sohail Khan

    Sohail Khan Member


    Will it work if i move voicher class after turnover line?
     


  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    I do not know.......

    am asking you........ since Voucher is designed as such...........
     


  5. Taufeeq Shaikh

    Taufeeq Shaikh Active Member


    Voucher Class itself is a predefined thing. so your condition or criteria will not get any effect. May be if you can set criteria at Voucher Class creation form..

    I think you should use the logic of Rounding Method used at Voucher Class Creation Form.. As it automatically gets rounded .. Same can be set by referring through Party Turnover Field. This is my suggestion.
     


  6. Sohail Khan

    Sohail Khan Member


    Is there a function that presses key Alt+F8 when i accept field Ei Consignee?
     


  7. Sohail Khan

    Sohail Khan Member


    I saw similar function in the forum in some whatsapp message sender but not able to find it now.
     


  8. balajimg

    balajimg Active Member


    you have to use
    control
    in [#Field:Consignee] to lock if the voucher class is not matching
     


  9. Sohail Khan

    Sohail Khan Member


    I used On field accept attribute and called for voucher class change function assigned in Button. Its working as I wanted.
     


Share This Page