Can someone please help me in understanding how to create a collection from an aggregate UDF. I have created a subform in the voucher entry and repeated a line in that form over an UDF. Then created a collection of that aggregate udf using the syntax [Type: AggUDF_Method:Voucher] but when I use that collection as a table, it shows me the udfs only from the current voucher. I want to create a table that shows values from all vouchers. Is it possible to do such a thing in Tally ? Any suggestion is very much appreciated.
Here is my code: ;;************************************************************************************ ;;************************************************************************************ [#Part: VCHTitleLeft] Add : Lines: At Beginning: DDView [Line: DDView] Field: DDView [Field: DDView] USe :Name Field Table: DD_Collection Show Table:Always [#Part: DBLLINE Narration] Add : Lines : At Beginning: GoTODDForm [Line:GoTODDForm] Field:GoTODDForm [Field:GOTODDForm] Use:Name Field Set as:"YES" Read Only:Yes Sub Form:Enter_DD [Report:Enter_DD] Form:Enter_DD [Form:Enter_DD] Parts: DDTitle, DDBody Height:50% Screen Width:20% Screen [Part: DDTitle] Line: DDTitle [Line: DDTitle] Field:Info Field Local:Field:InfoField:Info:"DD ID" [Part: DDBody] Line:VCH DD Details Repeat:VCH DD Details: DDID_AggrUDF Height:40% Screen Width:20% Screen Break On:$$IsEmpty:$DDID_UDF [Line: VCH DD Details] Field: VCHDDID [Field:VCHDDID] Use: Name Field Width: 30 Storage: DDID_UDF [Collection: DD_Collection] Type: DDID_AggrUDF:Voucher Sub Title:"DD ID UDF", "DD Rpt Dt" Format:$DDID_UDF, 30 Format:$Date, 15 Collection: End Of List [System:UDF] DDID_UDF: String:2701 DDID_AggrUDF : Aggregate: 2702
[Collection : All Vchs] Type : Vouchers [Collection : DD-Collection] Source Collection : All Vchs Walk : DDID_AggrUDF Sub Title:"DD ID UDF", "DD Rpt Dt" Format:$DDID_UDF, 30 Format:$Date, 15 Collection: End Of List
Thanks balajimg for your reply. Very helpful. I was able to solve this few days back by help of one of our forum members. Now i am stuck in another problem. I am in Voucher creation mode and created a created a field where i want to call $$FilterAmttotal from a collection which is created in the same voucher by using a subform linked to other field in that voucher. However, i am not above to achieve this. If you can help me in this. I will post my code soon. Regards Shetmano
Dear .... Use This [#Part: VCHTitleLeft] Add : Lines: At Beginning: DDView [Line: DDView] Field: DDView [Field: DDView] USe :Name Field Table: DDCollection Show Table:Always [#Part: DBLLINE Narration] Add : Lines : At Beginning: GoTODDForm [Line:GoTODDForm] Field:GoTODDForm [Field:GOTODDForm] Use:Name Field Set as:"YES" Read Only:Yes Sub Form:EnterDD [Report:EnterDD] Form:EnterDD [Form:EnterDD] Parts: DDTitle, DDBody Height:50% Screen Width:20% Screen [Part: DDTitle] Line: DDTitle [Line: DDTitle] Field:Info Field Local:Field:InfoField:Info:"DD ID" [Part: DDBody] Line:VCH DD Details Repeat:VCH DD Details: DDIDAggrUDF Height:40% Screen Width:20% Screen Break On:$$IsEmpty:$DDIDUDF [Line: VCH DD Details] Field: VCHDDID [Field:VCHDDID] Use: Name Field Width: 30 Storage: DDIDUDF [System:UDF] DDIDUDF: String:2701 DDIDAggrUDF : Aggregate: 2702 ;;-------------------------------------- [Collection : All Vchs] Type : Vouchers [Collection : DDCollection] Source Collection : All Vchs Walk : DDIDAggrUDF Sub Title:"DD ID UDF" + "DD Rpt Dt" Format:$DDIDUDF, 30 Format:$Date, 15 Collection: End Of List Manish
how t how to fetch this collection value on particular field of voucher,,not as table but the value automatically fetched up at desired location in line format eg....this in udf field---->xyz abc pqr on the desired field: same value with same pattern to be fetched xyz abc pqr can any one help!!!