Ledger fields in voucher Entry

Discussion in 'Free Source Codes' started by Haresh Hemani, Jan 9, 2019.

    
  1. Haresh Hemani

    Haresh Hemani New Member


    I need help i want a list of Ledger fields including UDF fields in voucher Entry
    Like Maintain bill by bill , credit days ,contract details and other UDF fildes
    code is
    ;;Modify Ledger Master entry screen and add a line 31122018
    [#Part : LED Other Details]

    Add: Line: LED AddtionalDeatils
    Add: Line: LED Agent Name
    Add: Line: LED AgentContactNo
    Add: Line: LED VoterID
    Add: Line: LED AadharCard

    [System : UDF]
    LED AddtionalDeatils : String : 50
    LED Agent Name : String : 100
    LED AgentContactNo : String : 150
    LED VoterID : String : 200
    LED AadharCard : String : 250

    [Line : LED AddtionalDeatils]
    Field : Medium Prompt,LED AddtionalDeatils
    Local : Field : Medium Prompt : Set As: "*** Addtional Deatils *****"
    [Field : LED AddtionalDeatils]
    Use : Name Field
    Storage : LED AddtionalDeatils

    [Line : LED VoterID]
    Field : Medium Prompt,LED VoterID
    Local : Field : Medium Prompt : Set As: "Voter ID :"
    [Field : LED VoterID]
    Use : Name Field
    Set as : $LEDVoterID
    Storage : LED VoterID
    Width : @@VCHNameWidth

    [Line : LED AadharCard]
    Field : Medium Prompt,LED AadharCard
    Local : Field : Medium Prompt : Set As: "Aadhar Card No. :"
    [Field : LED AadharCard]
    Use : Name Field
    Set AS: $LEDAadharCard
    Storage : LED AadharCard

    [Line : LED Agent Name]
    Field : Medium Prompt,LED Agent Name
    Local : Field : Medium Prompt : Set As: "Agent Name :"
    [Field : LED Agent Name]
    Use : Name Field
    SET AS : $LEDAgentName
    Storage : LED Agent Name

    [Line : LED AgentContactNo]
    Field : Medium Prompt,LED AgentContactNo
    Local : Field : Medium Prompt : Set As: "Agent Contract No :"
    [Field : LED AgentContactNo]
    Use : Name Field
    SET AS : $LEDAgentContactNo
    Storage : LED AgentContactNo

    ;; Get Ledger detail in voucher while entry
    [#Part: VCHTitle2Left]
    Add:Line:After:VCH Ref:MyGSTNo
    [Line: MyGSTNo]
    Add: Field: MyGSTNo,MyVoterID,MyAadharCard,MyAgentName,MyAgentContactNo

    Invisible: Not (@@IsPurchase Or @@IsSales Or @@IsCreditNote Or @@IsDebitNote)

    [Field: MyGSTNo]
    Fields : Simple Prompt, Name Field
    Local : Field : Simple Prompt: Set as : "GST No.:"
    Local : Field : name Field : Set as : $PARTYGSTIN:Ledger:$LedgerName
    Local : Field : Default : Skip : Yes
    Width : 1

    [Field: MyVoterID]
    Fields : Simple Prompt, Name Field
    Local : Field : Simple Prompt: Set as : "VoterID.:"
    Local : Field : name Field : Set as : $LEDVoterID:Ledger:$LedgerName
    Local : Field : Default : Skip : Yes
    Width : 1

    [Field: MyAadharCard]
    Fields : Simple Prompt, Name Field
    Local : Field : Simple Prompt: Set as : "Party AadharCard.:"
    Local : Field : name Field : Set as : $LEDAadharCard:Ledger:$LedgerName
    Local : Field : Default : Skip : Yes
    Width : 1

    [Field: MyAgentName]
    Fields : Simple Prompt, Name Field
    Local : Field : Simple Prompt: Set as : "Agent Name.:"
    Local : Field : name Field : Set as : $LEDAgentName:Ledger:$LedgerName
    Local : Field : Default : Skip : Yes
    Width : 1

    [Field: MyAgentContactNo]
    Fields : Simple Prompt, Name Field
    Local : Field : Simple Prompt: Set as : "AgentContactNo.:"
    Local : Field : name Field : Set as : $LEDAgentContactNo:Ledger:$LedgerName
    Local : Field : Default : Skip : Yes
    Width : 1
    ;; end code

    this is not showing properly in voucher and need to add more voucher entry time

    Regards,
    Haresh Hedmani
    +91 9820442909
     


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    IN all your fields.....
    [Field : LED VoterID]
    Use : Name Field
    Set as : $LEDVoterID ;;;;;;;;;;;;;; REMOVE THIS LINE..........
    Storage : LED VoterID
    Width : @@VCHNameWidth

    Objectify all your UDFs

    [#Object : Ledger]
    LEDVoterID : $LEDVoterID ........... similarly do for all other UDFs
     


  3. Atul Khakher

    Atul Khakher Member


    If we are using multiple address then how we can get
     


  4. Haresh Hemani

    Haresh Hemani New Member


    Hi Sir,
    Thanks a lot for providing update but It is not working here so i am attached tdl file please request you to modify and need further help as following
    1. Not showing full line in left part is using i need utilize full line and properly show (see attach JPG file)
    2.Should be work only for one company
    3. Addition more option form ledger to voucher Like Maintain bill by bill , credit days ,contract details , need variable name

    Thanks in advance,
    Regards,
    Haresh Hemani
    +91 9820 442909
     

    Attached Files:

    Last edited: Jan 15, 2019


  5. Rais Ahmed

    Rais Ahmed Member


    Dear Haresji,
    Amit sir guide U to remove line " Set As: " from ledger creation field. but posted tdl u have not removed. Try as experts guide u then see the result.
    1)Concept of new UDF r storage must not have set as. When u want 2 call that storage like in Ur voucher entry set as r needed.
    2) if u want all fields in one line then don't add lines instead in 1 line put more fields then all will come in 1 line.
    3) when u r preparing sales why using accounting voucher use inventory vch, default it has all what u want.
    Hope this will solve ur problem
    Regards
     


  6. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Replace alll..... "Add: Width : @@VCHNameWidth"

    with this............

    Local : Field : Default : Width : @@VCHNameWidth
     


  7. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    If you want for ONE company only....

    then in your fields....use............. INACTIVE : NOT $CmpName = "ABC & Co." ..... this is an example....you need to do R&D yourself in Tally TDE.

    if we give codes, then you will not learn the value of R&D and experience. In case any problems, revert...........
     
    Jaydeep Shah likes this.


  8. Haresh Hemani

    Haresh Hemani New Member


    thanks for update and i got all Fields and value but showing in condense more i want use full line and clear readable in voucher
    i am using [#Part: VCHTitle2LEFT] is other command line to add more Fields
     


  9. Haresh Hemani

    Haresh Hemani New Member


    thanks for update and will do R&D for the same

    can you please tell me variable name form ledger Like Maintain bill by bill , credit days ,contract details
     


  10. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Instead of @@VCHNamewidth....use your own numerals like...........10,12,14 etc
     


  11. Haresh Hemani

    Haresh Hemani New Member



    Up to 3 fields is showing correct but have more then 5 which showing in shrink mode and not shifted to right side is any command for right side ??? in vocher
     


  12. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    then remove default field setting for Width and define width in each and every field as per your requirement.
     


  13. Haresh Hemani

    Haresh Hemani New Member


    Hi Sir,
    Please request you check jpg file and comment as i can see half left part is using rest is total unuse and i used width 30 for each fields
     

    Attached Files:



  14. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Okay....saw you code.......... you are using Tally's default .... Simple Prompt and Name Field...........so they need to be overridden.......

    In your Fields ---> MyGSTNo, MyGSTRegistrationType, MyVoterID, MyAadharCard, MyAgentName, MyAgentContactNo

    Add as under:
    Local : Field : Simple Prompt : Width : 15 ;; (as you require, you can set individually for all fields)
    Local : Field : Name Field : Width : 20 ;; (as you require, you can set individually for all fields)

    Add above two lines in all the fields.
     


  15. Haresh Hemani

    Haresh Hemani New Member



    Hi Sir,
    This also not work no result , see below code

    [Field: MyGSTNo]
    Fields : Simple Prompt, : Width : 15
    Local : Field : Simple Prompt: Set as : "GST No.:"
    Local : Field : Name Field :Width : 20
    Local : Field : Name Field : Set as : $PARTYGSTIN:Ledger:$LedgerName
    Local : Field : Default : Skip : Yes
     


  16. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    You certainly do not read properly nor follow instructions properly.....

    Nowhere I have said to remove your fields definition.......... You have removed your field definition.
    And you have not copied/pasted the code properly either...........

    So kindly read again and implement it properly.
     


  17. Haresh Hemani

    Haresh Hemani New Member


    hi,
    I am sorry for that but there is not clarity what to do i was try to copy but what is command line , request to help
    here issue is that data is showing Left side only and not using full line till end so i am confused what to do
     
    Last edited: Jan 17, 2019


  18. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    [#Form: VCHBASIC Form]
    Add : Parts : After : VCHTitle2 : VCHTitle2A

    [Part : VCHTitle2A]
    Line : MyGSTNo

    [Line: MyGSTNo]
    Add: Field: MyGSTNo,MyVoterID,MyAadharCard,MyAgentName,MyAgentContactNo

    Invisible: Not (@@IsPurchase Or @@IsSales Or @@IsCreditNote Or @@IsDebitNote)

    [Field: MyGSTNo]
    Fields : Simple Prompt, Name Field
    Local : Field : Simple Prompt: Set as : "GST No.:"
    Local : Field : name Field : Set as : $PARTYGSTIN:Ledger:$LedgerName
    Local : Field : Default : Skip : Yes
    Width : 1

    [Field: MyVoterID]
    Fields : Simple Prompt, Name Field
    Local : Field : Simple Prompt: Set as : "VoterID.:"
    Local : Field : name Field : Set as : $LEDVoterID:Ledger:$LedgerName
    Local : Field : Default : Skip : Yes
    Width : 1

    [Field: MyAadharCard]
    Fields : Simple Prompt, Name Field
    Local : Field : Simple Prompt: Set as : "Party AadharCard.:"
    Local : Field : name Field : Set as : $LEDAadharCard:Ledger:$LedgerName
    Local : Field : Default : Skip : Yes
    Width : 1

    [Field: MyAgentName]
    Fields : Simple Prompt, Name Field
    Local : Field : Simple Prompt: Set as : "Agent Name.:"
    Local : Field : name Field : Set as : $LEDAgentName:Ledger:$LedgerName
    Local : Field : Default : Skip : Yes
    Width : 1

    [Field: MyAgentContactNo]
    Fields : Simple Prompt, Name Field
    Local : Field : Simple Prompt: Set as : "AgentContactNo.:"
    Local : Field : name Field : Set as : $LEDAgentContactNo:Ledger:$LedgerName
    Local : Field : Default : Skip : Yes
    Width : 1
     


  19. Haresh Hemani

    Haresh Hemani New Member


    Thanks for the same this is working fine now
     
    Last edited: Jan 17, 2019


  20. nasir

    nasir Member


    amit if i want to fetch data from that fields then how can i set as
    kindly guide
     


  21. Jayaseelan

    Jayaseelan New Member


    I NEED SOURCE CODE FOR CREATING THE AGENT NAME WHILE CREATING THE LEDGER PLEASE SHARE
     


Share This Page