I Created my own Form like "Stand Selling Rate Form" I Want to Fetch Rate DateWise My Source Code Working Fine But, it taking only first Rate. [#Line : STKVCH Batch2] Option : STKVCH Batch2LxAuto : (@@Issales );OR @@IsSalesOrder) AND @@CustCmpEnabledLxAuto and @@CustVchEnabledLxAuto [!Line : STKVCH Batch2LxAuto] Add : Right Field : After : VCHBATCH RateUnits : VCHBATCH MonthSchmVal , VCHBATCH TLSVal [Field : VCHBATCH MonthSchmVal] Use : Number Field ; set as : $MonthSchmVal Storage : MonthSchmVal Width : 30 mms Style : Small Bold Align : Center Format : "No Zero" inactive : @@NoBaseUnits OR @@BatchAllocBreak on:Focus : Yes : Set Field : $$Number$$GETru:$StockItemName:$Date)*$$Number:#VchBatchAltBilledQty*-1 [Function : GETru] Parameter : PItemName : String Parameter : PDate : Date Variable : ad : String Return : Number 02 : Walk : RUColl set333:Set:ad:$StkiMonthSchemDate msg323:Msg Box :##ad:$StkiMonthSchemRate 03 : If : $StkiMonthSchemDate<=##PDate ; And $Name=##PItemName 04:Return : $StkiMonthSchemRate 05:End If 06:End Walk [Collection : RUColl] Type : StkiMonthSchemBodyAggr : StockItem Child Of : $StockItemNAme
Unless You explain your problem clearly and Upload full source code we cannot help you. if it confidential mail to vardha.raju@gmail.com. For any help you are most welcome
Use Aggregate ... then make a collection of Aggregate.....Sort it as per your choice.... then use $$FilterValue