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
[#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: SvFromDateate:"01-04-19" ;;;;; Parm Var: SvToDateate:"31-03-20" Fetch : PartyGSTIN, BillAllocations.*, Reference, AllLedgerEntries.BillAllocations.Name Sort : Default : $Date [system : formula] Myfilter : $$IsPurchase:$VoucherTypeName or $$IsDebitNote:$VoucherTypeName
You seem to be making code without proper studies. You need to research the FIELDS in Developers more and more.
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.