how to get voucher number of pending bill...

Discussion in 'Tally Developer' started by rajendra mithari, Dec 18, 2013.

    

  1. Dear experts,
    see the code attached
    in payment voucher try this tdl-
    in pending bills collection i added one more field for vouchernumber of that pending bill
    but that collection field unable to set as auto in payment voucher.

    can you help me?
    regards
    mithari
     

    Attached Files:

    • PV.txt
      File size:
      1.4 KB
      Views:
      58


  2. mpal2311

    mpal2311 Active Member


    Please elaborate your query.
     



  3. currently in payment voucher agnst billwise it shows billname,billdate,billdue/due dateand billamount only
    i want to see voucher number of that pending bill for eg. bill no 001 date 15-04-13 due dt 15-05-13 amt 15000 voucher number 1234
    the user want to know the voucher number of the bill of which he is going to pay in payment voucher so that he can got the purchase file and pull the physical copy of bill for confermation of chq signing authority.
    means that authority want to see all those bills physically of which cheque is written.
     


  4. Maulik Patel

    Maulik Patel Active Member


    Dear Mr. Rajendra,
    You have to do following things.

    [#Collection : Pending Bills SRC]
    Add : Compute : MyVchNo : $LedgerEntries.VoucherNumber

    [#Collection: Pending Bills]
    Fetch : MyVchNo

    [Field: fld1]
    Set As : $MyVchNo
     



  5. No sir its not working
    regards
    mithari
    ------------------
    You have to do following things.

    [#Collection : Pending Bills SRC]
    Add : Compute : MyVchNo : $LedgerEntries.VoucherNumber

    [#Collection: Pending Bills]
    Fetch : MyVchNo

    [Field: fld1]
    Set As : $MyVchNo[/quote]
     


  6. Maulik Patel

    Maulik Patel Active Member


    [#Collection: Pending Bills]
    Add : Fetch : MyVchNo : $$Owner:($LedgerEntries.VoucherNumber)

    [Field: fld1]
    Set As : $MyVchNo
     



  7. sorry sir,
    tried many times by many changes also but not working
    pl help
    regards
    mithari
     


  8. Maulik Patel

    Maulik Patel Active Member


    Sir, Are you able to view $LedgerEntries.VoucherNumber in Bill Adjustment selection table?
     



  9. Dear sir,
    yes , in pending bill selection table the added field is showing perfectly see the code and also all snapshots.
    regards
    mithari
     

    Attached Files:



  10. Maulik Patel

    Maulik Patel Active Member


    Sir,

    [#Collection : Pending Bills SRC]
    Add : Compute : MyVchNo : $LedgerEntries.VoucherNumber

    [#Collection: Pending Bills]
    Fetch : MyVchNo

    $$FilterValue:$MyVchNo:pendingBills:First:MyBillFilter
    [System : Formula]
    MyBillFilter : $Name = $$ReqObject:"1653/23.012009"
     


  11. Maulik Patel

    Maulik Patel Active Member


    [Field: fld1]
    Set As : $$FilterValue:$MyVchNo:pendingBills:First:MyBillFilter
     


Share This Page