I hav tried but couldn't find anythin wrong in code ,pls help.. [#Menu : Gateway of Tally] add :key item : after @locsalesregister :"HYDRO Report" :risplay : My Voucher Report1 [Report : My Voucher Report1] use :dsp template title : "HYDRO report" Form :My Voucher Report1 Variable : SVFromDate,SVToDate Set : SVFromDate :$$monthstart : ##SVCurrentDate Set : SVToDate : $$monthEND : ##SVCurrentDate [#Menu : Gateway of Tally] [Form :My Voucher Report1] Button : Change Period,Print Button,Export Button,FilterButton,GRPVCH Configure Part AYBOOKHEAD1,My Voucher Report1 [Part : daybookhead1] Use : My Voucher Report1 Delete : Repeat Delete : Scroll Border : ColumnTitles Local : Field : Default : Type : string Local : Field : My Voucher Date : Set As : "Date" Local : Field : MyVoucherParty: Set As : "Particular" Local : Field :FIELD2 : Set As : "Voucher No" Local : Field : FIELD1 : Set As : "BATCH NAME" Local : Field : MYVCHNO: Set As : "QUANTITY" Local : Field : MyVchType : Set As : "Voucher Type" Local : Field : MyVchAmount : Set As : "AMOUNT" ;Local : Field : MyVchAmount : Set As : "Sales" ;Local : Field : MyVchAmount1 : Set As : "Receipt" ;Local : Field : MyVchAmount2 : Set As : "Payment" ;Local : Field : MyVchAmount3 : Set As : "Debit Note" ;Local : Field : MyVchAmount4 : Set As : "Credit Note" ;Local : Field : MyVchAmount5 : Set As : "Journal" ;Local : Field : MyVchAmount6 : Set As : "Purchase" ; ; Local :Field : Default : Style : Large Bold Local: Field: Default: Align: LEFT;Center ;Local: Field: Default:Background: Green [Part :My Voucher Report1] Line : My Voucher Report1 Repeat :My Voucher Report1 :My Voucher Rep Collection Scroll : Vertical Border:THIN [Line :My Voucher Report1] Field :My Voucher Date,MyVoucherParty,FIELD2,FIELD1 Right Field : MyVchNo,MyVchType,MyVchAmount Border:THIN Explode : MyInvExplode [Field :My Voucher Date] Use : Short Date Field Set As : $Date Border : THIN RIGHT [Field : MyVoucherParty] Use : NAme Field Set As : $PArtyLedgerName Border : THIN RIGHT [Field : FIELD1] Use : NAme Field Border : THIN RIGHT ;Set As : $PArtyLedgerName [Field : FIELD2] Use : NAme Field Set As : $REFERENCE Border : THIN RIGHT [Field : MyVchNo] Use : NAme Field Set As : $VoucherNumber Border : THIN RIGHT [Field : MyVchType] Use : Name Field Set As : $VoucherTypeName Border : THIN RIGHT [Field : MyVchAmount] Use : Amount Field Set As : $$FilterAmtTotal:AllInventoryEntries:MyFilter:$Amount Border : THIN RIGHT [System : Formula] [Collection : My Voucher Rep Collection] Type : Vouchers : VoucherType Child of : $$VchTypeStockJrnl Fetch : Date,Amount,VoucherTypeName,REFERENCE ,PArtyLedgerName,VoucherNumber ;SortEFAULT:$REFERENCE [Part : MyInvExplode] Line : MyInvExplode Border:THIN Repeat : MyInvExplode : INVENTORYENTRIESIN [Line : MyInvExplode] Field :My Voucher Date,MyVoucherParty Right Field : MyVchNo,MyVchType,MyVchAmount ;Local : Field : My Voucher Date : Set As : ҠLocal : Field : MyVoucherParty: Set As : $StockItemName Local : Field : MyVchAmount: Set As : $Amount Local : Field : MyVchNo: Set As :"" Local : Field : MyVchType: Set As :"" Border:THIN Explode : My Batch Allocations [Part : My Batch Allocations] Line :My Batch Allocations Repeat :My Batch Allocations : BatchAllocations [Line :My Batch Allocations] Field :My Voucher Date,MyVoucherParty,FIELD2,FIELD1 Right Field : MyVchNo,MyVchType,MyVchAmount ;Local : Field : My Voucher Date : Set As :Ҡ;Local : Field : MyVoucherParty: Set As :$BATCHNAME Local : Field : FIELD1: Set As :$BATCHNAME Local : Field : MyVchAmount: Set As : "" Local : Field : MyVchNo: Set As :$ACTUALQTY Local : Field : MyVchType: Set As :"" ;Local : Field : Default : Color : Red
Replace the code [Collection : My Voucher Rep Collection] Type : Vouchers : VoucherType Belongs To :Yes Child of : $$VchTypeStockJrnl Fetch : Date,Amount,VoucherTypeName,REFERENCE ,PArtyLedgerName,VoucherNumber