I am trying to fetch stock of particular Item at Main store by using tally's default collections, but my sql query only returning Godown names [Collection: IGColmst] Use : Godown Parm var : pvSVStockItem : String : #SVStockItem Fetch : Name, StkGdwItemBalanceMfg, JobName, ItemClBalanceMfg Filter : StockableGodownFilter;, StockItemNotEmptyFilter ;select $Name, $ItemClBalanceMfg from IGColmst ;[!Collection: Mfgr Stockable GodownExtarct RemoteTop] [Collection: IGCol] Title : @@GodownTitle Use : Master Name Method Format Source Collection : IGColmst ;Mfgr Stockable GodownTop Walk : Name ; Language Name, Name Parm var : pvSVStockItem : String : #SVStockItem Fetch : Name, ItemClBalanceMfg, StkGdwItemBalanceMfg ;Compute : First Name : $..Name[1].Name Format : $StkGdwItemBalanceMfg : "Base" Full Height : Yes Align : Right ;select $Name, $StkGdwItemBalanceMfg form IGCol [Collection: colStockable Godown] Use : Godown Fetch : Name, ItemClBalance, GodownItemClBal ;Filter : StockableGodownFilter Parm var : pvSVStockItem : String : #SVStockItem Search Key : $Name ;select $Name, $ItemClBalance, $GodownItemClBal from colStockableGodown [System: Formulae] #SVStockItem : "Capacitor Terminal Protector Without Hole M 10"
