Godown Control

Discussion in 'Tally Developer' started by Taufeeq Shaikh, Nov 27, 2013.

         
  1. Taufeeq Shaikh

    Taufeeq Shaikh Active Member


    Dear All,

    How can we set that if there is no stock in particular godown then it should not show while passing sales entry. I had tried but no effect.:-

    [#Collection: Godown]
    Add: Filter: IsEmpStk

    [#Collection: Godown for Parent]
    Add: Filter: IsEmpStk

    [#Collection: Multi Godown]
    Add: Filter: IsEmpStk

    [#Collection: Godown Under MGodown]
    Add: Filter: IsEmpStk

    [#Collection: Stockable Godown]
    Add: Filter: IsEmpStk

    [#Collection : Godown Summary]
    Add: Filter: IsEmpStk


    [System : Formula]


    IsEmpStk : $GodownItemClBal = 0
     



  2. Dear Shaikh,

    check this

    [#Collection: Stockable Godown VchExtract]

    Filter : SAPPEMPTYFILTER

    [System:Formula]

    SAPPEMPTYFILTER : NOT $$IsEmpty:$GodownItemClBal
     


  3. Taufeeq Shaikh

    Taufeeq Shaikh Active Member


    Great its working. Thank You Very Very Very Much .
     



  4. only for sales and credit note
    [#Field: VCHBATCH Godown]

    Option : SAPPSalCN : ($$IsSales:##SVVoucherType OR $$IsCreditNote:##SVVoucherType)

    [!Field: SAPPSalCN]

    Delete : Table
    Add : Table : SAPP Stockable Godown VchExtract
    Set Always : Yes

    [Collection: SAPP Stockable Godown VchExtract]

    Use : Stockable Godown VchExtract
    Add : Filter : SAPPEMPTYFILTER

    [System:Formula]

    SAPPEMPTYFILTER : NOT $$IsEmpty:$GodownItemClBal
     
    Sanjay Kumar Tanti, Basha and HVPatel like this.


  5. mpal2311

    mpal2311 Active Member


    Not working. Please share full codes.
     


  6. Taufeeq Shaikh

    Taufeeq Shaikh Active Member


    Once Again Good Work Aldrin.
     


  7. HVPatel

    HVPatel Active Member


    In this if already entered old sales entries, and there is no stock now, and user alter old sales voucher, godown changed to stock available. i modified this like below
    Code:
    Option        : SAPPSalCN : $$InCreateMode AND ($$IsSales:##SVVoucherType OR $$IsCreditNote:##SVVoucherType)
     



  8. Only CreateMode

    [#Field: VCHBATCH Godown]

    Option : SAPPSalCN : $$InCreateMode AND ($$IsSales:##SVVoucherType OR $$IsCreditNote:##SVVoucherType)

    [!Field: SAPPSalCN]

    Delete : Table
    Add : Table : SAPP Stockable Godown VchExtract,End of List
    Set Always : Yes

    [Collection: SAPP Stockable Godown VchExtract]

    Use : Stockable Godown VchExtract
    Add : Filter : SAPPEMPTYFILTER

    [System:Formula]

    SAPPEMPTYFILTER : NOT $$IsEmpty:$GodownItemClBal
     


  9. Taufeeq Shaikh

    Taufeeq Shaikh Active Member


    Just a little Bit of modification for not allowing user at the time of alteration to as per HVG88 request.

    [#Field: VCHBATCH Godown]

    Option : SAPPSalCN : $$InCreateMode OR $$InAlterMode AND ($$IsSales:##SVVoucherType OR $$IsCreditNote:##SVVoucherType)

    [!Field: SAPPSalCN]

    Delete : Table
    Add : Table : SAPP Stockable Godown VchExtract
    Set Always : Yes

    [Collection: SAPP Stockable Godown VchExtract]

    Use : Stockable Godown VchExtract
    Add : Filter : SAPPEMPTYFILTER

    [System:Formula]

    SAPPEMPTYFILTER : NOT $$IsEmpty:$GodownItemClBal
     
    Amina kharadi likes this.


  10. HVPatel

    HVPatel Active Member


    Dear Shaikh & Prabhakaran, In create mode it is ok,
    if Stock is Nil (Zero), and user go to alter a voucher (entered during godown having stock), no list of godown showing,
    Requesting to All Experts, please update, if a godown has no stock, and user go to alter vch, it should show list of godown having stock.
    thanks & regards
     


  11. sayed

    sayed Member


    good i want it to ledger control pls
     



  12. Auto Godown Selection is working but
    enter rate and Stop entry
    and Not select next Stock Item...
     


  13. sayed

    sayed Member


    all can help me i want sales and purchase export file from tally to text include
    1- date 2- time 3- sales account\purchase account 4-name of item 5-qty 6-amount
     


  14. Manish Chauhan

    Manish Chauhan New Member


    Good works.............................
     


  15. Avipul93

    Avipul93 New Member


    add to auto fill godown with stock

    [#Field: VCHINV Godown]
    ;Set as:"test3"
    Set as:$$FilterValue:$Name:Godown:First:SAPPEMPTYFILTER
     


Share This Page