Please Help first line getting group wise stock item but not getting on second line group wise stock

[#Line : EI ColumnOne]

Option : Global EI ColumnOne1@@issales or @IsPurchase) and Not ##SVAcctsInvoice

[!Line : Global EI ColumnOne1]
add : fields: before:VCH ItemTitle : VCH Group
[field : vch Group]
use : name field
Info : "Group"
Width : 24
style : Small bold


[#Line : EI InvInfo]
Option : Global EI ColumnOne2

[#Line : CI InvInfo]
Option : Global EI ColumnOne2@@issales or @IsPurchase) and Not ##SVAcctsInvoice

[!Line : Global EI ColumnOne2]
add : fields:before: VCH StockItem : vchgroup1
[field : vchgroup1]
Use : Create Stock Group
Table : Stock Group Extract, Primary, EndofList,Create Master
Show Table : Always
Key : Create Stock Group, Alter StkGrp
Variable : SV Stock Group
Set as : ""
Modifies : DEFStockGroupName
Common Table: No
Fetch Object : StockGroup : $$Value : BaseUnits, AdditionalUnits, Conversion, Denominator, +
IsBatchWiseOn, HasMfgDate, IsPerishableOn, CostingMethod, +
ValuationMethod, IgnorePhysicalDifference, IgnoreNegativeStock, TreatSalesAsManufactured, +
TreatPurchasesAsConsumed, TreatRejectsAsScrap, AllowUseOfExpiredItems
Width:24
Storage:vchgroup1
[#Field:VCH StockItem]
Show Table:Always
[#Collection: Vch Stock Item Extract]
Filter:vchGroup


[System:Formula]
vchGroup: $$IsEqual:$parent:#vchgroup1


[System:UDF]
vchgroup1:String:1875



//first line group ac wise stock getting correct



//first line group fridge wise stock getting correct


//but second line group fridge wise stock not getting only getting first line group wise stock only

 

problem solved using
comon table : No

[#Field:VCH StockItem]
comon table : No

 

Try This...

[#Line : EI ColumnOne]

Option : Global EI ColumnOne1@@issales or @IsPurchase) and Not ##SVAcctsInvoice

[!Line : Global EI ColumnOne1]
add : fields: before:VCH ItemTitle : VCH Group
[field : vch Group]
use : name field
Info : "Group"
Width : 24
style : Small bold


[#Line : EI InvInfo]
Option : Global EI ColumnOne2

[#Line : CI InvInfo]
Option : Global EI ColumnOne2@@issales or @IsPurchase) and Not ##SVAcctsInvoice

[!Line : Global EI ColumnOne2]
add : fields:before: VCH StockItem : vchgroup1
[field : vchgroup1]
Use : Create Stock Group
Table : Stock Group Extract, Primary, EndofList,Create Master
Show Table : Always
Key : Create Stock Group, Alter StkGrp
Variable : SV Stock Group
Set as : ""
Modifies : DEFStockGroupName
Common Table: No
Fetch Object : StockGroup : $$Value : BaseUnits, AdditionalUnits, Conversion, Denominator, +
IsBatchWiseOn, HasMfgDate, IsPerishableOn, CostingMethod, +
ValuationMethod, IgnorePhysicalDifference, IgnoreNegativeStock, TreatSalesAsManufactured, +
TreatPurchasesAsConsumed, TreatRejectsAsScrap, AllowUseOfExpiredItems
Width:24
Storage:vchgroup1
Dynamic: ""
[#Field:VCH StockItem]
Show Table:Always
Dynamic: ""
;[#Collection: Vch Stock Item Extract]
;Filter:vchGroup
;
;
[System:Formula]
vchGroup: $$IsBelongsTo:#vchgroup1;;$$IsEqual:$parent:#vchgroup1

[#Collection: Vch Stock Item Extract Server]

Use : Vch Stock Item
Filter:vchGroup
/* the existing collection code has been modified due to support Multi Mfgr Journal voucher
.. in Mfgr journal used Extract Collection to fetch the component items from stock item (Multi Component List, Multi Component Item List */

[#Collection: Vch Stock Item Extract Remote]

Title : $$LocaleString:"List of Stock Items"
Collection : VCH StockItemAlias Src, VCH StockItemPartNo Src
Set as : $FirstName
Client Only : Yes
Keep Source : ().
Full Height : Yes
Align : Right
Format : $Name, 25
Format : $VchStkItmBalance : "Base"
Filter:vchGroup

[System:UDF]
vchgroup1:String:1875

 

thank you sir

 

there was issue that only one digit was typing in group
so
Set as : End of List

after a lot of hardwork i found solution




[#Line : EI ColumnOne]

Option : Global EI ColumnOne1@@issales or @IsPurchase) and Not ##SVAcctsInvoice

[!Line : Global EI ColumnOne1]
add : fields: before:VCH ItemTitle : VCH Group
[field : vch Group]
use : name field
Info : "Group"
Width : 24
style : Small bold


[#Line : EI InvInfo]
Option : Global EI ColumnOne2

[#Line : CI InvInfo]
Option : Global EI ColumnOne2@@issales or @IsPurchase) and Not ##SVAcctsInvoice

[!Line : Global EI ColumnOne2]
add : fields:before: VCH StockItem : vchgroup1
[field : vchgroup1]
Use : Create Stock Group
Table : Stock Group Extract, Primary, EndofList,Create Master
Show Table : Always
Key : Create Stock Group, Alter StkGrp
Variable : SV Stock Group
Set as : End of List
Modifies : DEFStockGroupName
Common Table: No
Fetch Object : StockGroup : $$Value : BaseUnits, AdditionalUnits, Conversion, Denominator, +
IsBatchWiseOn, HasMfgDate, IsPerishableOn, CostingMethod, +
ValuationMethod, IgnorePhysicalDifference, IgnoreNegativeStock, TreatSalesAsManufactured, +
TreatPurchasesAsConsumed, TreatRejectsAsScrap, AllowUseOfExpiredItems
Width:24
Storage:vchgroup1
[#Field:VCH StockItem]
Show Table:Always
Dynamic: ""
;[#Collection: Vch Stock Item Extract]
;Filter:vchGroup
;
;
[System:Formula]
vchGroup: $$IsBelongsTo:#vchgroup1;;$$IsEqual:$parent:#vchgroup1

[#Collection: Vch Stock Item Extract Server]

Use : Vch Stock Item
Filter:vchGroup
/* the existing collection code has been modified due to support Multi Mfgr Journal voucher
.. in Mfgr journal used Extract Collection to fetch the component items from stock item (Multi Component List, Multi Component Item List */

[#Collection: Vch Stock Item Extract Remote]

Title : $$LocaleString:"List of Stock Items"
Collection : VCH StockItemAlias Src, VCH StockItemPartNo Src
Set as : $FirstName
Client Only : Yes
Keep Source : ().
Full Height : Yes
Align : Right
Format : $Name, 25
Format : $VchStkItmBalance : "Base"
Filter:vchGroup

[System:UDF]
vchgroup1:String:1875