set Disount% how

Discussion in 'Requests' started by vaibhav jindal, Mar 17, 2019.

    

  1. [#Field: VCH Discount]
    Use : Number Field
    width : 3
    set as :$(Ledger,$PartyLedgerName).ItemRatesAggregate[1,@@IsSameItem].MSTSFItemRate
    Delete : Format
    Add : Format :"NoZero,Percentage"

    where is i am wrong
     


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Does the RATE exists in the LedgerName or the StockItem ????
     



  3. Yes, in some items
    And in not some items
     



  4. Code:
    [#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 Items"
        Type : Stock Group
        Format : $Name,25
    
    
    [#Field: VCH Discount]
    
    Use         : Number Field
    width : 3
    set as    :$(Ledger,$PartyLedgerName).ItemRatesAggregate[1,@@IsSameItem].MSTSFItemRate
    Delete : Format
    
    Add : Format :"NoZero,Percentage"
    
    
    
    [System : Formula]
    IsSameItem : $$ReqObject:$Parent:StockItem:$StockitemName = $MSTSFItemName
    
    can anybody set its fro me
     


Share This Page