I need Discount for the item group....

[#Field: VCH Discount]
Use : Number Field
width : 3
Forced : Yes
set as : "2%"
Delete : Format
Add : Format :"NoZero,Percentage"

 

I try but cant get the value in Discount Column in Sales Invoice.... Please Guide me....

 

Thanks ..Lot ... Sir ... I will Try.....

 

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. Its working by your Valuable Guidance.... thank... so much Amit sir....

 

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

 

Mr. love Give me an Example please ......