hello friends i am doing project category wise product but its not working any suggestion or help please . [#Line: EI InvInfo] Add : Field : At beginning : VCH CategorySelections [#Line: CI InvInfo] Add : Field : At beginning : VCH CategorySelections [Field:VCH CategorySelections] Use : Name Field Table : Stock Category,Not applicable Color : Blue Show Table:Always [#Field : Vch stockitem] Option: vch stockitemcat :$$IsEmpty:#VCHCategorySelections [!Field : vch stockitemcat] Delete : Table Add : Table : vch stockitemcat,End of List Dynamic : "" Show Table:Always [Collection : vch stockitemcat] Child of : #VCHCategorySelections Belongs to : Yes Title : $$LocaleString:"List of Stock Items" Type : Stockitem Format : $$Name, 20 Format : $ClosingBalance : "Base" FullHeight : Yes With Alias : Yes Set as : $Name Align : Right Include : StockItem:Yes Fetch : Name, Language Name, ClosingBalance Fetch : AdditionalUnits Compute : VchStkItmBalance : @@VchStkItmBalance [#Line: EI ColumnOne] Add : Fields : At Beginning : VCH ITEMCAT [#Line: EI ColumnTwo] Add : Fields : At Beginning :VCH ITEMCAT [Field :VCH ITEMCAT] Use : Name Field Info : "Category Name"
Find/locate the original Stockitem collection and add your filter to that.......... Filter would be Stockitem having parent as the StockCategory.