Collection Issue

Help me
I have created Voucher type Wise UDF Aggregate Value,,Not able to Collections In Voucher Level.Kindly Advice Or Correct the Code

[#Part : VTYP BehaviourMain]
Add : Line : After : VTYP PrintSave : Voucher Batch PrintConfig


[Line : Voucher Batch PrintConfig]
Field : Long Prompt, Voucher Batch PrintConfig
Local : Field : Long Prompt : Info : $$LocaleString:"Batch Creations"
Local : Field : Long Prompt : Width : @@LongWidth - 1

[Field : Voucher Batch PrintConfig]
Use : Logical Field
Sub Form : Size : $$Value
Set as : No


[Report: Size]
Form : Size
Title : "Size Creation / Alteration"
Object:Voucher Type: ##SvCurrentCompany

[Form: Size]
Part : Size
Horizontal Align : Left


[Part: Size]
Line : SizeTitle, Size
Repeat : Size : Size
Scroll : Vertical
Break On: $$IsEmpty:#SizeName


[Line: SizeTitle]
Field : SizeTitle
Border : Column Titles

[Line: Size]
Field : SizeName

[Field: SizeTitle]
Set as : "Size Type"
Width : 30
Skip : Yes



[Field: SizeName]
Use:Name Field
Type:String:Forced
Storage : SizeNameUDF
Width : 30
Max : 30
Unique : Yes



[System: UDF]
Eisize : String : 5670
Size : Aggregate : 5671
SizeID : String : 5672
SizeNameudf : String : 5673

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
[Collection: ListOfVchBatches]
Title : "Batch"
Type : Size : Voucher Type
Childof : ##SVCurrentCompany
Format : $SizeNameUDF, 30



[#Field: VCHBATCH Name]

Use : Batch Name Field
Use : NewNumberTemplate
Style : Small Bold
Validate : NOT @@HasBatchWise OR NOT $$IsEmpty:$$Value
Invisible : NOT @@IsPhysStock AND NOT @@HasBatchWise
Set always : Yes
Option :Vch Batch name Trader Table@VchTypeBatchEnable

[!Field:Vch Batch name Trader Table]
Delete : Table
Add : Table : ListOfVchBatches
Delete: Option : VCHBATCH OrdrName : @@IsOrderVch OR @@IsJobOrderVouchers
Delete: Option : VCHBATCH NrmlName : NOT @@IsOrderVch AND NOT @@IsJobOrderVouchers AND (NOT @@IsStockJrnl) AND (NOT @@IsPurchase) AND (NOT @@IsRcptNote)
Delete: Option : VCHBATCH JrnlName : @@IsStockJrnl
Delete: Option : VCHBATCH GRNName : @@IsRcptNote OR @@IsPurchase
Width : If @@HasMfgDateSet OR @@HasExpiryDate Then 18 Else @@VCHBatchNameWidth

Show Table : Always
Default Table Item : NOT($$IsSysNameEqual:NewNumber:$Name)
[System:Formula]
VchTypeBatchEnable$VouchertypeName Equal "Sales")

 

Try..

Code:

[#Part : VTYP BehaviourMain]
    Add : Line : After : VTYP PrintSave : Voucher Batch PrintConfig


[Line : Voucher Batch PrintConfig]
    Field : Long Prompt, Voucher Batch PrintConfig
    Local : Field : Long Prompt : Info : $$LocaleString:"Batch Creations"
    Local : Field : Long Prompt : Width : @@LongWidth - 1

[Field : Voucher Batch PrintConfig]
    Use : Logical Field
    Storage    : TypeBatchEnabled
    Sub Form : Size : $$Value
    ;Set as : No
   
[System    : UDF]
    TypeBatchEnabled : Logical    : 5680
   
[System    : Formula]
    VchTypeBatchEnable :  $TypeBatchEnabled:VoucherType:##SvVoucherType
   
[Report: Size]
    Form : Size
    Title : "Size Creation / Alteration"

[Form: Size]
    Part : Size
    Horizontal Align : Left


[Part: Size]
Line : SizeTitle, Size
Repeat : Size : Size
Scroll : Vertical
Break On: $$IsEmpty:#SizeName


[Line: SizeTitle]
Field : SizeTitle
Border : Column Titles

[Line: Size]
Field : SizeName

[Field: SizeTitle]
Set as : "Size Type"
Width : 30
Skip : Yes



[Field: SizeName]
Use:Name Field
Type:String:Forced
Storage : SizeNameUDF
Width : 30
Max : 30
Unique : Yes



[System: UDF]
Eisize : String : 5670
Size : Aggregate : 5671
SizeID : String : 5672
SizeNameudf : String : 5673

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
[Collection: ListOfVchBatches]
   

Title : "Batch"

Type : Size : Voucher Type
Childof : ##SvVoucherType
Format : $SizeNameUDF, 30



[#Field: VCHBATCH Name]

Set always : Yes
Add : Option :Vch Batch name Trader Table: @@VchTypeBatchEnable


[!Field:Vch Batch name Trader Table]
Delete : Tables
Add : Table : ListOfVchBatches
Delete: Options

Show Table : Always
;Default Table Item : NOT($$IsSysNameEqual:NewNumber:$Name)

 

Thank u,,its wrking

 

hi Garima One More Final Query

I have created StockItem Wise UDF Aggregate Value,,Not able to Collections In Voucher Level.


[#Part: STKI Batch]

Add : Line : Voucher Batch PrintConfig


[Line : Voucher Batch PrintConfig]
Field : Long Prompt, Voucher Batch PrintConfig
Local : Field : Long Prompt : Info : $$LocaleString:"Size Creations"
Local : Field : Long Prompt : Width : @@LongWidth - 1

[Field : Voucher Batch PrintConfig]
Use : Logical Field
Storage : TypeBatchEnabled
Sub Form : Size : $$Value
;Set as : No

[System : UDF]
TypeBatchEnabled : Logical : 5680


[Report: Size]
Form : Size
Title : "Alias Creation / Alteration"

[Form: Size]
Part : Size
Horizontal Align : Left


[Part : Size]
Line : SizeTitle, Size
Repeat : Size : Size
Scroll : Vertical
Break On: $$IsEmpty:#SizeName


[Line: SizeTitle]
Field : SizeTitle
Border : Column Titles

[Line: Size]
Field : SizeName

[Field: SizeTitle]
Set as : "Alias"
Width : 30
Skip : Yes



[Field: SizeName]
Use:Name Field
Type:String:Forced
Storage : SizeNameUDF
Width : 30
Max : 30
Unique : Yes



[System: UDF]
Eisize : String : 5670
Size : Aggregate : 5671
SizeID : String : 5672
SizeNameudf : String : 5673

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
[Collection: ListOfVchBatches]


Title : "list Of Sizes"
Type : Size : Stock Item
Childof : ##SVStockItem;##SVStockItemName
Format : $SizeNameUDF, 30

 

same problem i had face, please help on this issue.

 

;try This;
[Collection: ListOfVchBatches]

Title : "list Of Sizes"
Parm Var : pvStockItemName : String : $StockItemName

Type : Size : Stock Item
Childof : ##pvStockItemName
;Childof : ##SVStockItem;##SVStockItemName
Format : $SizeNameUDF, 30