how to fetch reference no

Discussion in 'Tally Developer' started by rke, Dec 11, 2020.

    
  1. rke

    rke Member


    Wan to fetch display reference number also but not showing ho can i make this collection
     

    Attached Files:



  2. rke

    rke Member


    i am posting the code pls help to correct my code reference number is not fetching


    [#Line: BILLCol1]
    use :BillDetail


    ;[Field : MyVCHRefTitle]
    ; Use : Shortname Field
    ; Info : "Vch Reference"
    ;



    [#Field: BILLFixed]
    Add: Field : After: BILLParty : BillReference

    [Field:BillReference]
    Use:Name Field
    Set as:" Reference "
    Background:
    Color:Red


    [Field: BillContact]
    Set as : $LedgerMobile:Ledger:$parent

    ;[Field : MyRefNo]
    ; Use : ShortName Field
    ; Set as :$$String:$Narration + " "+ $$String:$Reference + " " + $$String:$VchReferenceDate
    ; Invisible : not ##UseRefInvoucherReporting

    ;[Variable : UseRefInvoucherReporting]
    ;; Type : Logical
    ;;Persist : yes

    ;;[System : Variable]
    ;;UseRefInvoucherReporting : Yes


    [#Collection:LedBill Summary]
    Fetch: Reference,Narration
     

    Attached Files:

    Last edited: Dec 12, 2020


  3. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    From the Photo ...... reference is already there, which you have circled.......

    From the Code.... cannot understand what you want and where ??? and also what exactly you are trying to achieve?
     


  4. rke

    rke Member


    above is not fetching reference no voucher is default is showing as reference number i am trying to fetch reference number of receivable in outstanding report
     


  5. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    The Collection is wrong..........

    Right collection is CompanyReceivables

    Compute your value in this collection by using CollectionField from the collection "LedgerEntries"

    Then use this in your FIELD.
     
    Jaydeep Shah likes this.


  6. rke

    rke Member


    SIR I AM SUCCEEDED TO ADD AND FETCH CONTACT DETAILS BUT NOT ABLE TO FETCH THE REFERENCE AS POSTING THE CODE AGAIN PLS GIVE ME COLLECTION example View attachment 7751
     


  7. Himanshu-2002

    Himanshu-2002 Active Member


    Sir Learn Collection Field by Key Function and Amit Sir Already told the Collection Name Company Receivables... So, You can just use Ctrl + J ( In tally Developer) to find the Collection
     


  8. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    I have already explained in previous post......try to understand and implement it the right way.....

    Capture.PNG
     
    Jaydeep Shah likes this.


  9. rke

    rke Member


    Thank u Amit sir for ur valuable support and knowledge taken from u , I done finally and fetching reference number in my outstanding report
     

    Attached Files:



  10. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Very Good.... glad you are a trier and not require ready codes.

    Sincere efforts are always rewarding and satisfactory. Keep it up buddy.
     
    rke and Jaydeep Shah like this.


Share This Page