AUTOMATIC GODOWN SELECTION IN SALE PURCHASE VOUCHER ENTRY

Discussion in 'Free Source Codes' started by sattam, Feb 21, 2018.

    
  1. sattam

    sattam Active Member


    Dear Friends,
    Enjoy the free code.
     

    Attached Files:

    Manoj Kumar S likes this.


  2. Rohit Khedar

    Rohit Khedar Member


    Sattamji hlp me how to enable thih tdl in tally



    [#Menu: Gateway of Tally]
    Add: Key Item : After : @@locInventoryInfo : Agent Info. : G : Alter : Agent Detail Creation : $IsAgentModuleEnabled:Company:##SVCurrentCompany
    ;; Control : Agent Info. : $IsAgentModuleEnabled:Company:##SVCurrentCompany ;; removes the menu
    ;; else use the condition in the menu itself to grey it

    ;; 2:30:50

    [Report: Agent Detail Creation]
    Title : "Agent Details Creation"
    Form : Agent Detail Creation
    Object : Company : ##SVCurrentCompany
    Family : "Agent Master" ;; to have user level control for this form

    [Form: Agent Detail Creation]
    Part : Agent Detail Creation
    Background : Crystal Blue

    [Part: Agent Detail Creation]
    Line : AgentDetailT, AgentDetailB
    Repeat : AgentDetailB : AgentDetail
    Scroll : Vertical
    Common Border : Yes
    Break On : $$IsEndOfList:$AgentName


    [Line: AgentDetailT]
    Use : AgentDetailB

    Local : Field : Default : Type : String
    Local : Field : Default : Style : Normal Bold
    Local : Field : Default : Line : 0
    Local : Field : Default : Align : Center
    Local : Field : Default : Delete: Storage

    Local : Field : AgentName : Info : "Name"
    Local : Field : AgentDoJ : Info : "Date of Joining"
    Local : Field : AgentComm : Info : "Commission (%)"

    ;; Local : Field: CMP AgentName : INFO : "Name of Agent"
    ;; Local : Field: CMP AgentName : Border : Thin Bottom

    Border : Thin Bottom
    Space Bottom : 1

    [Line: AgentDetailB]
    Field : AgentName, AgentDoJ, AgentComm

    [Field: AgentName]
    Type : String
    Table : AgentNameColl, End of List
    Show Table : Always
    Width : 25
    Max : 251
    Storage : AgentName
    Dynamic : "" ;; to refresh the table

    [Field: AgentDoJ]
    Type : Date
    Width : 15
    Max : 12
    Storage : AgentDoJ
    Skip : $$IsEndOfList:$AgentName
    Border : thin left right

    Validate : Not $$IsEmpty:$$Value
    Notify : DoJLessThanBookBeginning : $$Value < $BooksFrom:Company:##SVCurrentCompany

    [Field: AgentComm]
    Type : Number
    Width : 10
    Align : Right
    Max : 2
    Storage : AgentComm
    Skip : $$IsEndOfList:$AgentName
    Validate : Not $$IsEmpty:$$Value
    Control : HighCommission : $$Value > $$Number:15
    ;;Control : LowCommission : $$Value < $$Number:0
    Control : LowCommission : $$Value < $$Number:1

    Format : "NoZero, Percentage" ;; issue does not allow 0% commission



    [System: UDF]
    AgentDetail : Aggregate : 20011
    AgentName : String : 20012
    AgentDoJ : Date : 20013
    AgentComm : Number : 20014

    [System: Formulae]
    DoJLessThanBookBeginning : "Date of Joining is Less than Books Begining"
    HighCommission : "Commission Cannot Exceed 15%"
    LowCommission : "Commission Cannot be less than Zero"
    ;; End of File
     


  3. Rohit Khedar

    Rohit Khedar Member


    Sattamji hlp me how to enable thih tdl in tally



    [#Menu: Gateway of Tally]
    Add: Key Item : After : @@locInventoryInfo : Agent Info. : G : Alter : Agent Detail Creation : $IsAgentModuleEnabled:Company:##SVCurrentCompany
    ;; Control : Agent Info. : $IsAgentModuleEnabled:Company:##SVCurrentCompany ;; removes the menu
    ;; else use the condition in the menu itself to grey it

    ;; 2:30:50

    [Report: Agent Detail Creation]
    Title : "Agent Details Creation"
    Form : Agent Detail Creation
    Object : Company : ##SVCurrentCompany
    Family : "Agent Master" ;; to have user level control for this form

    [Form: Agent Detail Creation]
    Part : Agent Detail Creation
    Background : Crystal Blue

    [Part: Agent Detail Creation]
    Line : AgentDetailT, AgentDetailB
    Repeat : AgentDetailB : AgentDetail
    Scroll : Vertical
    Common Border : Yes
    Break On : $$IsEndOfList:$AgentName


    [Line: AgentDetailT]
    Use : AgentDetailB

    Local : Field : Default : Type : String
    Local : Field : Default : Style : Normal Bold
    Local : Field : Default : Line : 0
    Local : Field : Default : Align : Center
    Local : Field : Default : Delete: Storage

    Local : Field : AgentName : Info : "Name"
    Local : Field : AgentDoJ : Info : "Date of Joining"
    Local : Field : AgentComm : Info : "Commission (%)"

    ;; Local : Field: CMP AgentName : INFO : "Name of Agent"
    ;; Local : Field: CMP AgentName : Border : Thin Bottom

    Border : Thin Bottom
    Space Bottom : 1

    [Line: AgentDetailB]
    Field : AgentName, AgentDoJ, AgentComm

    [Field: AgentName]
    Type : String
    Table : AgentNameColl, End of List
    Show Table : Always
    Width : 25
    Max : 251
    Storage : AgentName
    Dynamic : "" ;; to refresh the table

    [Field: AgentDoJ]
    Type : Date
    Width : 15
    Max : 12
    Storage : AgentDoJ
    Skip : $$IsEndOfList:$AgentName
    Border : thin left right

    Validate : Not $$IsEmpty:$$Value
    Notify : DoJLessThanBookBeginning : $$Value < $BooksFrom:Company:##SVCurrentCompany

    [Field: AgentComm]
    Type : Number
    Width : 10
    Align : Right
    Max : 2
    Storage : AgentComm
    Skip : $$IsEndOfList:$AgentName
    Validate : Not $$IsEmpty:$$Value
    Control : HighCommission : $$Value > $$Number:15
    ;;Control : LowCommission : $$Value < $$Number:0
    Control : LowCommission : $$Value < $$Number:1

    Format : "NoZero, Percentage" ;; issue does not allow 0% commission



    [System: UDF]
    AgentDetail : Aggregate : 20011
    AgentName : String : 20012
    AgentDoJ : Date : 20013
    AgentComm : Number : 20014

    [System: Formulae]
    DoJLessThanBookBeginning : "Date of Joining is Less than Books Begining"
    HighCommission : "Commission Cannot Exceed 15%"
    LowCommission : "Commission Cannot be less than Zero"
    ;; End of File
     


  4. Manoj Kumar S

    Manoj Kumar S New Member


    THANKS FOR UR TDL SIR
     


  5. Manoj Kumar S

    Manoj Kumar S New Member


    THANKS FOR UR TDL SIR
    IT IS WORKING FINE
     


  6. sumamehtra

    sumamehtra Member


    HOW TO SELECT BATCH ALLOCATION GODOWN ON FRONT SCREEN ??
     


  7. Manoj Kumar S

    Manoj Kumar S New Member


    DEAR SIR

    I NEED THIS TDL IN DELIVERY NOTE ALSO CAN YOU HELP ME...
     


  8. sattam

    sattam Active Member


    Here is updated code for Auto Go down Selection for Delivery Note and Receipt Note.
     

    Attached Files:



  9. Manoj Kumar S

    Manoj Kumar S New Member


    THANK YOU VERY MUCH SIR FOR YOUR IMMEDIATE REPLY IT IS VERY MUCH HELPFUL FOR US
     


  10. Manoj Kumar S

    Manoj Kumar S New Member


    Dear sir

    We are using multiple units in our stock for example dozens, pcs

    In default tally shows only pcs or dozens in sales or purchase invoice

    I want both units with their respective quantities in delivery note and in sales invoice..

    Can you help me sir......

    Regards,

    Manoj Kumar S
     


  11. info.ap

    info.ap New Member


    Dear Mr.Sattam, Thanks for such useful codes, sharing knowledge is really good...can you help me out for Batch Expiry Date Ordering i.e. while purchase or sale entry it shows Batch Details Box...(Batch No.Expiry Date etc) here I need Expiry Date in order - near to expiry should be at first and so on...please suggest, Regards
     


  12. info.ap

    info.ap New Member


    Dear Mr.Sattam, Thanks for such useful codes, sharing knowledge is really good...can you help me out for Batch Expiry Date Ordering i.e. while purchase or sale entry it shows Batch Details Box...(Batch No.Expiry Date etc) here I need Expiry Date in order - near to expiry should be at first and so on...please suggest, Regards
     


  13. Dipak_0003

    Dipak_0003 New Member


    Hi, This TDL is good but i have a question. How can you define default godown in Inventory voucher, stock jornal? when we do internal transfer it also has two godown. How can you define default godown in internal stock transfer?
     


  14. sumeet

    sumeet New Member


    Can we use this to set Godown at Voucher level and not at Voucher Type Level. @sattam
     


Share This Page