add UDF Field After Bill reference

Discussion in 'Tally Developer' started by Mahesh Sethi, Sep 15, 2020.

    
  1. Mahesh Sethi

    Mahesh Sethi Member


    Dear Experts,

    i am trying to insert UDF field after Bill Ref and want Voucher No store on that field.

    here is the code, pls help....

    [#Line: VCHBILL CTLineOne]

    Add:Field:Before:VCHBILL ExpiryTitleOne:myTitle2

    [Field : MyTitle]
    Field : Simple Field
    Set as : ""
    Skip : Yes
    Width : @@VCHAmountWidth

    [#Line: VCHBILL CTLineTwo]

    Add:Field:Before:VCHBILL ExpiryTitleTwo:myTitle2

    [Field : MyTitle2]
    Field : Simple Field
    Set as : "Voucher Ref."
    Skip : Yes
    Width : @@VCHAmountWidth

    [#Line: VCHBILL CTLineThree]

    Add:Fiield:Before:VCHBILL ExpiryTitleThree:mytitle3

    [Field : MyTitle3]
    Field : Simple Field
    Set as : ""
    Skip : Yes
    Width : @@VCHAmountWidth

    [#Line: VCHBILL Line]
    Add: Line:After:VCHBILL MainLine: Mytitlem

    [Line : MyTitlem]
    Field : MyTitlemm

    [Field : MyTitlemm]
    Field : Name Field
    Set as : $$VchNumber
    Width : @@VCHSmallNameWidth
    Storage : MyTitlemm

    [System : UDF]
    MyTitlemm:String:10018



    Thanks in advance
     

    Attached Files:



  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    First of all... remove... all ...... Field : Simple field..... Actually it is --- Use : Simple field .......... so rectify that.
    Same --- in MyTitlemm --- Use : Name field ........... not Field : Name field.......

    in Set as : ----- #VchNumber
     


  3. Mahesh Sethi

    Mahesh Sethi Member


    Thanks for your replay. Now its working fine, one small issue Voucher ref field show next row in place of before due date

    Thanks Again Bill Ref 1.png
     


  4. Mahesh Sethi

    Mahesh Sethi Member


    Finally Done it,

    Thanks to admin

    Now i have a query If i split the data and this bill is due for payment and show in party's opening balance along with bill reference is that possible to the added udf field go with opening bill reference in next financial year in party's opening balance.

    Pls help me.

    Pls replay
     

    Attached Files:



  5. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Dunno.....you try to split data on DUMMY data and see............
     


  6. Mahesh Sethi

    Mahesh Sethi Member


    Sir,
    I will Try as per you suggested but there is no result ,And i think if i add another udf in opening balance form after bill reference it was happened. I Hope So, and i will try to add udf in ledger op. balance form.

    Thanks
     


  7. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Good...always work on dummy data........always.
     


  8. Mahesh Sethi

    Mahesh Sethi Member


    dear Sir,

    When i search ledger opening balance bill wise reference form it show me the same table, collections & fields which i have used for bill reference during the sale or purchase transaction. I am stuck Pls help me how i go wrong.

    Thanks in advance
     

    Attached Files:



  9. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    The Ledger's Opening Balance field and its sub-form is a different report. If you want to see your details there, then you must add your field in that report also.

    However, if you are passing a NEW entry in the split data, and then the Bill Reference report pops up, your last year data should be visible.
     


  10. Mahesh Sethi

    Mahesh Sethi Member


    dear sir,

    pls explain how i got the ledger opening balance fields or form so that i can put my udf field there.

    thanks in advance
     


  11. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    OpenTally in developer mode. Hover your mouse and you will get the report name. Then search for that name in Tally Developer.
     


  12. Mahesh Sethi

    Mahesh Sethi Member


    Sir,

    Finally i have done and add udf in ledger op balance form and after that i have split the data but the required udf is not full fill as i required .

    screen shoots i have att and code also post here pls guide me where i am wrong.

    Thanks in Advance


    [#Line: VCHBILL CTLineOne]

    Add:Field:Before:VCHBILL ExpiryTitleOne:myTitle

    [Field : MyTitle]
    Use : Simple field
    Set as : "Voucher Ref."
    Skip : Yes
    Width : 20+20 mms ;;@@VCHAmountWidth

    [#Line: VCHBILL CTLineTwo]

    Add:Field:Before:VCHBILL ExpiryTitleTwo:myTitle2

    [Field : MyTitle2]
    Use : Simple field
    Set as : ""
    Skip : Yes
    Width : 20+20 mms ;;@@VCHAmountWidth

    [#Line: VCHBILL CTLineThree]

    Add:Field:Before:VCHBILL ExpiryTitleThree:mytitle3

    [Field : MyTitle3]
    Use : Simple field
    Set as : ""
    Skip : Yes
    Width : 20+20 mms ;;@@VCHAmountWidth

    ;;[#Line: VCHBILL Line]
    [#Line: VCHBILL MainLine]
    Add: Field:After:VCHBILLName: Mytitlem

    ;;[Line : MyTitlem]
    ;; Field : MyTitlemm

    [Field : MyTitlem]
    Use : Name field
    Set as : #VchNumber
    Width : 20+20 mms ;;@@VCHMediumNameWidth
    Storage : MyTitlem

    [System : UDF]
    MyTitlem :String:10018


    [#Line: VCHBILL DueDateLine]
    Add:Field:Before:VCHBILL DueDate:MyTitlemmm

    [Field : MyTitlemmm]
    Use : Name field
    Set as : "" ;;#VchNumber
    Width : 20+20 mms ;;@@VCHMediumNameWidth


    ;;===============================================

    ; Line : LEDALLOC CTLineOne, LEDALLOC CTLineTwo
    [#Line: LEDALLOC CTLineOne]
    add :field: After:LEDALLOC NameTitle: LedOpmytit

    [Field : LedOpmytit]

    Use : Simple Field
    Set as : "Voucher Ref"
    Skip : Yes
    Width : 40 mms

    [#Line: LEDALLOC CTLineTwo]

    add :field: Before:LEDALLOC ExpiryTitleTwo: LedOpmytit2

    [Field : LedOpmytit2]

    Use : Simple Field
    Set as : ""
    Skip : Yes
    Width : 40 mms


    [#Line: LEDALLOC MainLine]

    Add:Field:Before:LEDALLOCExpiry:Ledopmttitt

    [Field : Ledopmttitt]
    Use : Name Field
    Set as : $$MyTitlem
    Skip : Yes
    Width : 40 mms

    [#Line: LEDALLOC DueDateLine]

    Add:Field:Before:LEDALLOCDueDate:Ledopmttitt2

    [Field : Ledopmttitt2]
    Use : Name Field
    Set as : ""
    Skip : Yes
    Width : 40 mms
    before spliting ledger op bal.png
     

    Attached Files:



  13. Mahesh Sethi

    Mahesh Sethi Member


    Dear Admin sir/Experts,

    Pls Guide me where i am wrong and not getting the voucher reference field filled as i want.

    Awaiting for your valuable replay.

    Thanks in advance
     


  14. Mahesh Sethi

    Mahesh Sethi Member


    ALL EXPERTS PLS HELP

    Sir PLS HELP me where i am wrong . when i split the data USD stored field is not getting the data in party ledger's opening UDF field.


    ALL EXPERTS PLS HELP and give me suggestions only.

    thank and waiting for your replay
     


  15. Mahesh Sethi

    Mahesh Sethi Member


    ALL EXPERTS PLS HELP
     


Share This Page