I like to deactivate some seasonal stock as they are discontinued they are not in use i write following code What will be The System formula to filter stock item name from the list of stock items on voucher creation date. Code: [System : UDF] MyDoYouWantToDeActStkItem :Logical :1000 ;. Stock Item Deactivation Value Yes / No MyDeActStkItemDate : Date : 1001. ; Stock Item Deaction Date Value [#Collection : Vch Stock Item Extract] Filter : MyStkDeActFilter ; For Filteration of List of Stock Item List [System : Formula] MyStkDeActFilter: ?????????????????????!?
[#Collection : Vch Stock Item Extract] Compute : InactiveItem : $MyDoYouWantToDeActStkItem:StockItem:$Name Compute : InactiveItemDate :$MyDeActStkItemDate:StockItem:$Name Filter : MyStkDeActFilter [System : Formula] MyStkDeActFilter: NOT $InactiveItem AND $InactiveItemDate < $Date
more i try to learn tdl more i get confused not getting the desired results Sir, will you please help me with sysntax if any for system formula
If you are confused, then you are on RIGHT path........ keep going. If not working, then remove DATE condition.
Amit Ji, We All Know You Are a Very Busy Peraon Then Also Your Replies are very quick not only on this forum but on mail and Facebook messages also. Your Quotes are Really Motivating. Thanks For Helping Us. Good Luck Take Care.