[#Field: VCH Discount] Use : Number Field width : 3 Forced : Yes set as : "2%" Delete : Format Add : Format :"NoZero,Percentage"
This Code is not working sir any one can guide.. [#Part: MST LED Explode Sundry] Add : Line : At end : SetDisParWisYn [Line : SetDisParWisYn] Field : Medium Prompt, SetDisParWisYn Local : Field : Medium Prompt : Set As : "Set/Alter Party Wise Discount :" [Field : SetDisParWisYn] use : Logical Field Set aS : No Sub form : ItemRateSF : $$Value [Report : ItemRateSF] Form :ItemRateSF [Form :ItemRateSF] Part :ItemRateSF [Part :ItemRateSF] Line : ItemRateSF Repeat : ItemRateSF : ItemRatesAggregate Scroll : Vertical Break on : $$Isend:$MSTSFItemName [Line :ItemRateSF] Field : MSTSFItemName,MSTSFItemRate [Field : MSTSFItemName] Use : Name Field Storage : MSTSFItemName Table : MyStockitems,End of List [Field : MSTSFItemRate] Use : Number Field Storage : MSTSFItemRate Format : "NoZero,Percentage" Inactive: $$IsEnd:$MSTSFItemName [System : UDF] ItemRatesAggregate : Aggregate : 21000 MSTSFItemName : String : 21001 MSTSFItemRate : Number : 21002 [Collection : MyStockitems] Title : "List of Group" Type : Stock Group Format : $Name,25 [#Field: VCH Discount] Delete : Set By Condition Use : Number Field width : 3 Forced : Yes set as : $(Ledger,$PartyLedgerName).ItemRatesAggregate[1,@@IsSameItem].MSTSFItemRate Delete : Format Add : Format :"NoZero,Percentage" [System : Formula] IsSameItem : $$ReqObject:$Parent:StockItem:$StockitemName = $MSTSFItemName
Sir One Issue... Discount calculated in previous date vouchers also... How stop previous voucher not affect?? i am started discount on 21/01/22 but it affect all previous vouchers also....
add this ,should work Add : Set As : If $$InCreateMode then $(Ledger,$PartyLedgerName).ItemRatesAggregate[1,@@IsSameItem].MSTSFItemRate Else $$Value Add : Set By Condition : ($$IsFieldEdited OR $$InAlterMode OR NOT $$IsEmpty:$$Value): $$Value
Its working fine Mr.love.....thanks so Much... pls Guid an other type discount by Item Group only (not Party wise) [System:UDF] RdGDiscount : Number: 100 [#Field: VCH Discount] Delete : Set By Condition Add : Set By Condition : not ($$IsEmpty@GrpDiscount): @@GrpDiscount Color : Blue [System: Formula] GrpDiscount: $RdGDiscount:StockGroup$Parent:StockItem:$StockItemName) Its Giving same problem... As Previous screen shots .... Please Give Solution... Thanks Advance.....
your set by condition is wrong, modify it to fetch value only when it is in create mode , you are directing it to fetch value whenever their is a value in the UDF and that is what it is doing.
Mr.Love, above code Enable Purchase Order & Sales Order Processing "No" then Proper Work But "Yes" not Proper Work