hello adeshwar mehta ji maine aapki prblem solve ki hai isi plateform ki help se. 1) pending amount total 2) remove if plese chek ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; [#Menu : Gateway of Tally] Add : Item : Sales Report : DISPLAY : Sales Report [Report : SalesReport] Form : SalesReport Set : variable : svfromdate, svtodate Set : SVFromDate : ##SVToDate Set : SVToDate : ##SVCurrentDate [Form : SalesReport] Part : ASTPURTitle,ASTPURDtls Bottom Part : ASTTotal Height : 100% Screen use : DSP Template [Part : ASTPURTitle] Line : ASTPURTL1,ASTPURTL2 [Line : ASTPURTL1] Field : ASTPURTL1 [Field : ASTPURTL1] Set as : @@cmpmailname Full Width : Yes Align : Centre Style : Large Bold Skip : Yes [Line : ASTPURTL2] Field : ASTPURTL2 Right Field : AStPeriod ; Border : Column Titles [Field : ASTPURTL2] use : Name Field Set as : "Sales Register" Fullwidth : Yes Align : Centre Skip : Yes [Field : Astperiod] Set as : "From "+$$String:##svfromdate+" To "+$$String:##svtodate Skip : Yes [Part : ASTPURDtls] Line : saleTitles,salesdtls Repeat : salesdtls : Salescoll Total : Invamt Total : CollectedAmountInfo Scroll : Vertical [Line : Saletitles] Field :hksn, Invno, invdt,Party,Invamt,CollectedAmountInfo Local : Field : hksn : Info: "S.No." Local : Field : Party : Set as: "Buyer Name" Local : Field : invdt : Set as :"Inv Dt" Local : Field : Invno : Set as :"Invno." Local : Field : Invamt : type : String Local : Field : Invamt : Set as : "Inv.Amt" Local : Field : CollectedAmountInfo : Type : String Local : Field : CollectedAmountInfo : Set as : "Pending Amount" Border : Column Titles [Line : salesdtls] Field : hksn,invno,invdt,Party, Invamt,CollectedAmountInfo Option : AlterOnEnter remove if : $$IsEmpty:#CollectedAmountInfo [Field:hksn] Use:Number Field Set as:$$Line Style:normal [Field : Party] use : Name Field set as : $PartyLedgername Width : 30% Screen [Field : InvNO] use : Name Field Set as : $Vouchernumber Width : 15% Screen [Field : Invdt] Set as : $Date Width : 15% Screen [Field : Invamt] use : Amount Field Set as : $Amount Width : 15% Screen [Field: CollectedAmountInfo] Use : Amount Field Align : Right Width : 15% Screen Style : large bold Set as: $PendingAmount Set always : Yes Skip : Yes Background:Grey [Part : ASTTotal] Line : Asttotal [Line : Asttotal] Field : hksn,Invno,invdt,party, Invamt,CollectedAmountInfo Local : Field : hksn : Info: "" Local : Field : Party : Set as: "Total..." Local : Field : Cstno : Set as : "" Local : Field : invdt : Set as :"" Local : Field : Invno : Set as :"" Local : Field : Invamt : Set as : $$Total:Invamt Local : Field : goods : type : String Local :Field : goods : Set as :"" Local : Field : CollectedAmountInfo : Set as : $$Total:CollectedAmountInfo Border : Column Titles [Collection:CollForBills] Type: Bills Compute : VoucherNumber : $$CollectionField:$VoucherNumber:1:LedgerEntries [Collection: MycollforCollection] Source Collection : CollForBills Fetch : ClosingBalance, VoucherNumber Compute : LedgerName : $$CollectionField:$LedgerName:1:LedgerEntries Search Key : $VoucherNumber [Collection : Salescoll] Type : voucher Filter : IsSale Fetch : Vouchernumber,PartyLedgername,Amount,Buyerscstnumber,Date Compute : qty:$$CollQtyTotal:Inventoryentries:$BilledQty Compute : PendingAmount:$$ReportObject:$$CollectionFieldByKey:$ClosingBalance:$VoucherNumber:MycollforCollection [Collection : SalesColldtl] Source Collection : Salescoll Walk : Inventoryentries By : Vouchernumber: $Vouchernumber Fetch : Vouchernumber,PartyLedgername,Amount,Buyerscstnumber,Date,Amount ;,Stockitemname [System : Formula] Issale : $$IsSales:$vouchertypename ChkParty : $PartyLedgername = ##Newchangecoll ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
dear experts mai tdl me naya member hu is plateform ki help se thoda bahut kuch seekha hai. mujhe dear members i m new in tdl maine isi plateform se thoda bahut seekha hai. mai sale report me pending amount ka coloum nahi balki explode karne per particular bill ke receipt voucher ki detail show karana chahta hu ye kaise hoga please help, exxample Gatway of tally display statement of accounts outstanding ledger then f12 range of bills to show = all bills then alt + f1 is tarah
Sale Report mein collection of vouchers hai...... O/s Report mein collection of Bills hai.... Dono collections alag type ka hai, isliye Tally bhi reporting seperate de rahe hai....... You can combine them, lekin uske liye pehle TDL ki jaankaari chahiye...... it is doable..... lekin pura coding alag karna padega........