Display collection of Vouchers with VchNum, InvNum, Party-BillRef

Discussion in 'Tally Developer' started by naren1234, May 15, 2021.

    
  1. naren1234

    naren1234 Member


    Dear Experts,
    I want to create and export a simple purchase vouchers report by custom period to display Party LedgerName, Voucher Date and following fields :-
    1) Voucher Number (see red box in attached screenshot)
    2) Supplier Invoice No. (see green box in screenshot) and Invoice Date
    3) Bill Reference (blue box in screenshot) --bill reference are manually changed in many vouchers.

    Also, I am unable to retrieve the Supplier GSTIN from the voucher entry (NOT from Ledger Master).

    But below code is Not working. Please help.

    Code:
    [#Menu : Gateway of Tally]
    Add : Item : My Pur and DrN Report : Display : MyReport
    
    [Report: MyReport]
    Form: MyForm
    
    [Form : MyForm]
    Parts : MyPart
    
    [Part : MyPart]
    Line : MyTitle, MyLine
    Repeat : MyLine :MyPurVoucher
    
    [Line : MyTitle]
    Use : MyLine
    Local : Field : MyLedName : Set As : “Party Name”
    Local : Field : MyVchType : Set As : "Voucher Type"
    Local : Field : MyDate : Set As : ”Voucher Date”
    Local : Field : MyVchNo : Set As : ”Voucher No.”
    Local : Field : MySuppInvNo : Set As : ”Supp Inv No.”
    Local : Field : MyBillRef : Set As : ”Billwise Reference”
    Local : Field : PartyGSTIN : Set As : ”Supplier GST No.”
    Local : Field : Default : Type : String
    
    [Line : MyLine]
    Field : MyLedName, MyVchType, MyDate, MyVchNo, MySuppInvNo, MyBillRef, PartyGSTIN
    
    [Field :MyLedName]
    Use : Name Field
    Set As :$PartyLedgerName
    Width : 65
    
    [Field :MyVchType]
    Use : Name Field
    Set As :$VoucherTypeName
    
    [Field : MyDate]
    Use : Uni Date Field
    Set As :$ReferenceDate    ;;- is this correct?
    
    [Field : MyVchNo]
    Use :  Name Field
    Set As :$VoucherNumber    ;;- is this correct?
    
    [Field : MySuppInvNo]
    Use :  Name Field
    Set As :$ReferenceNumber    ;;- is this correct?
    
    [Field : MyBillRef]
    Use :  Name Field
    Set As :$$Table:VCHBILLName      ;;- is this correct?
    
    ;Need to fetch Supplier GST No. updated in the voucher and NOT from supplier Ledger Master
    [Field : MyPartyGSTIN]
    Use :  Name Field
    Set As :$EI BuyerGSTIN          ;;- is this correct?
    
    
    ; Below code was posted by Amit Sir
    [Collection: MyPurVoucher]
    Type : Vouchers
    Fetch : Date,VoucherTypeName,Vouchernumber,PartyLedgerName,Amount,BuyerGSTIN   ;;- is this correct?
    Filter : Myfilter
    Sort : Default : $LedgerName, $Date
    Parm Var: SvFromDate:Date:"01-04-19"
    Parm Var: SvToDate:Date:"31-03-20"
    
    [system : formula]
    Myfilter : $$IsPurchase:$VoucherTypeName or $$IsDebitNote:$VoucherTypeName
    
     

    Attached Files:



  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    [#Menu : Gateway of Tally]
    Add : Item : My Pur and DrN Report : Display : MyReport

    [Report: MyReport]
    Form: MyForm

    [Form : MyForm]
    Parts : MyPart

    [Part : MyPart]
    Line : MyTitle, MyLine
    Repeat : MyLine :MyPurVoucher

    [Line : MyTitle]
    Use : MyLine
    Local : Field : MyLedName : Set As : “Party Name”
    Local : Field : MyVchType : Set As : "Voucher Type"
    Local : Field : MyDate : Set As : ”Voucher Date”
    Local : Field : MyVchNo : Set As : ”Voucher No.”
    Local : Field : MySuppInvNo : Set As : ”Supp Inv No.”
    Local : Field : MyBillRef : Set As : ”Billwise Reference”
    Local : Field : PartyGSTIN : Set As : ”Supplier GST No.”
    Local : Field : Default : Type : String

    [Line : MyLine]
    Field : MyLedName, MyVchType, MyDate, MyVchNo, MySuppInvNo, MyBillRef, PartyGSTIN

    [Field :MyLedName]
    Use : Name Field
    Set As :$PartyLedgerName --- Wrong -- $LedgerName
    Width : 65

    [Field :MyVchType]
    Use : Name Field
    Set As :$VoucherTypeName

    [Field : MyDate]
    Use : Uni Date Field
    Set As :$ReferenceDate ;;- is this correct? Wrong -- $Date

    [Field : MyVchNo]
    Use : Name Field
    Set As :$VoucherNumber ;;- is this correct?

    [Field : MySuppInvNo]
    Use : Name Field
    Set As :$ReferenceNumber ;;- is this correct? Wrong -- $Reference

    [Field : MyBillRef]
    Use : Name Field
    Set As :$$Table:VCHBILLName ;;- is this correct? Wrong -- $AllLedgerEntries.BillAllocations.Name

    ;Need to fetch Supplier GST No. updated in the voucher and NOT from supplier Ledger Master
    [Field : PartyGSTIN] Above...It is PartyGSTIN, here you writing MyPartyGSTIN
    Use : Name Field
    Set As :$EI BuyerGSTIN ;;- is this correct? Wrong -- $PartyGSTIN


    ; Below code was posted by Amit Sir --- I do not recollect such a Collection with Parm Var -- Not mine :)
    [Collection: MyPurVoucher]
    Type : Vouchers
    Fetch : Date,VoucherTypeName,Vouchernumber,PartyLedgerName,Amount,BuyerGSTIN ;;- is this correct?
    Filter : Myfilter
    ;;;;; Sort : Default : $LedgerName, $Date
    ;;;;; Parm Var: SvFromDate:Date:"01-04-19"
    ;;;;; Parm Var: SvToDate:Date:"31-03-20"

    Fetch : PartyGSTIN, BillAllocations.*, Reference, AllLedgerEntries.BillAllocations.Name
    Sort : Default : $Date


    [system : formula]
    Myfilter : $$IsPurchase:$VoucherTypeName or $$IsDebitNote:$VoucherTypeName
     
    Last edited: May 15, 2021
    naren1234 likes this.


  3. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    You seem to be making code without proper studies.

    You need to research the FIELDS in Developers more and more.
     


  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member



  5. naren1234

    naren1234 Member


    Amit Sir, thank you, that was really helpful. That is exactly what I was trying to generate.
    Your suggestions will help me figure what I did wrong.

    Yes, I saw the use of param var in some other code and I added it to the collections.
     


  6. naren1234

    naren1234 Member


    Right sir, I need to squeeze out more time so I can study TDL better.
     


Share This Page