NEED HELP PRICE LEVEL

Discussion in 'Free Source Codes' started by rahul nigotiya, Dec 24, 2019.

    
  1. rahul nigotiya

    rahul nigotiya New Member


    Dear expert, pls help in this code
    i have defined price list and price level for all my customers
    in this code I want that when I have to tell the rate of an item to a party, then I select the party and then select the item, then the price should automatically come from price level
    but i dont know What code to use do to get rate and discount automatically from price level

    pls help

    [#Menu: Gateway OF Tally]
    Add: Toolbar Buttons: ledgerhotkey

    [#Form: Default]
    Add: Toolbar Buttons: After: HelpButton : ledgerhotkey

    [button: ledgerHotKey]
    Key: F5
    Action: alter : ledgerwishrate
    Title: "PARTY WISH ITEM RATE"

    [Report: ledgerwishrate]
    Form: ledgerwishrate
    Set : SVFromDate : @@DSPFromDate
    Set : SVToDate : @@DSPToDate

    Title: "PARTY WISH ITEM RATE"

    [Form: ledgerwishrate]
    No Confirm: yes
    Part: ledgerwishrate,
    Option: Small size form
    Height : 20% Screen
    Width : 100% Screen
    [Part: ledgerwishrate]
    Line:daybookhead,Deactive Item Title,ledgerwishrate,daybookhead1

    [Line :daybookhead]
    Use : Form SubTitle

    Local : Field : Form SubTitle : Set As :$$String:##SVCurrentDate+" "+ " PARTY WISH ITEM RATE " +" "+" Company Name :- "+ @@CmpMailName
    Local : Field : Form SubTitle : Style :parth CMP Name1
    Local : Field : Form SubTitle : Full Width: Yes
    Local : Field : Form SubTitle :Skip : YES
    Local : Field : Form SubTitle :Color: BLACK

    [Line :daybookhead1]
    Field: Simple Field
    Space Top:0.10 Inch

    Local : Field :Simple Field : Set As :" #DILIP "
    Local : Field : Simple Field: Style :parth CMP Name1
    Local : Field : Simple Field : Full Width: Yes
    Local : Field : Simple Field:Skip : YES
    Local : Field : Simple Field :Color : BLACK


    [Part : Deactive Item Title]
    Line : Deactive Item Title
    Border : Thin Box


    [Line : Deactive Item Title]

    Field : Deactive Item SNo,Deactive Item Name,Deactive Item Reason,QUANTITY,RATE5,DIS%,GST%,TOTAL AMT,Stock,
    Border : ColumnTitles
    Local : Field : Default : Align : Centre
    Local : Field : Default : Style : Normal Bold
    Local : Field : Deactive Item SNo : Set as :"PARTY NAME"
    Local : Field : Deactive Item Name : Set as :"PRICE LEVEL"
    Local : Field : Deactive Item Reason : Set as :"ITEM NAME"
    Local : Field : QUANTITY: Set as :"QUANTITY"
    Local : Field : RATE5: Set as :"RATE"
    Local : Field : DIS%: Set as :"DIS%."
    Local : Field : GST%: Set as :"GST@%"
    Local : Field : TOTAL AMT: Set as :"FINAL AMT"
    Local : Field : Stock: Set as :"STOCK"



    [Line: ledgerwishrate]
    Field: Ledgerselect,Short Name field1,itemlist, Short Name fiel,Rate2,discount,gst,final rate,cl stock2
    Border : Flush Column Titles
    Local: Field: Short name field1 : Set as: $$LocaleString:$PriceLevel:ledger:#Ledgerselect
    Local: Field: Short Name fiel : Set as: ""
    Local: Field: Rate2: Set as: ""
    Local: Field: discount : Set as: ""
    Local: Field: gst : Set as: ""
    Local: Field: final rate : Set as: $$LocaleString:$Rate
    Local: Field: cl stock2 : Set as: $$AsInQty:$ClosingBalance:StockItem:#itemlist
    Space Top:0.10 Inch

    [Field: Ledgerselect];;;;;;;;;;;;;;;party name list;;;;;;;;;;;;;;;;;;;;;;;;;;;
    Use: short name field
    Table: Ledger
    Align:Center
    Width : 40
    Border : Thin Left Right
    Show Table: Always
    [Field: pricePl];;;;;;;;;;;;;;;party name list;;;;;;;;;;;;;;;;;;;;;;;;;;;
    Use: short name field
    Table: Price Levels
    Align:Center
    Width : 40
    Border : Thin Left Right
    Show Table: Always

    [Field: Short Name fiel];;;;;;;;;;;;;;;Price level;;;;;;;;;;;;;;;;;;;;;;;;;;;

    Width : 13
    Align:Center

    Set as : $BilledQty
    Style : Normal Bold
    Format : "Symbol, Short Form, No Compact"
    Border : Thin Left Right
    Show Table: Always

    [Field: Rate2];;;;;;;;;;;;;;;Rate;;;;;;;;;;;;;;;;;;;;;;;;;;;
    Use: short name field
    Width : 8
    Align:Center
    Set as:$RateOfVAT:StockItem:$StockItemName
    Border : Thin Left Right
    Show Table: Always

    [Field: discount];;;;;;;;;;;;;;;discount;;;;;;;;;;;;;;;;;;;;;;;;;;;
    Use: short name field
    Width : 13
    Align:Center
    Border : Thin Left Right
    Show Table: Always
    [Field: gst];;;;;;;;;;;;;;;gst;;;;;;;;;;;;;;;;;;;;;;;;;;;
    Use: short name field
    Width : 13
    Align:Center
    Border : Thin Left Right
    Show Table: Always
    [Field: final rate];;;;;;;;;;;;;;;Final rate;;;;;;;;;;;;;;;;;;;;;;;;;;;
    Use: short name field
    Width : 13
    Align:Center
    Border : Thin Left Right
    Show Table: Always


    [Field: cl stock2];;;;;;;;;;;;;;;Item stock;;;;;;;;;;;;;;;;;;;;;;;;;;;
    Width : @@ShortNameWidth
    Max : @@MaxNameWidth
    Style : Normal Bold
    Format : "Symbol, Short Form, No Compact"
    Align:Center
    Border : Thin Left
    Case : Title Case
    Skip:Yes


    [Field: itemlist];;;;;;;;;;;;;;;Item name list;;;;;;;;;;;;;;;;;;;;;;;;;;;
    Use: short name field
    Table: Stock Item
    Width : 29
    Show Table: Always
    [Field: PriceLevels];;;;;;;;;;;;;;;Item name list;;;;;;;;;;;;;;;;;;;;;;;;;;;
    Use: short name field
    Table: Price Levels
    Width : 25
    Show Table: Always

    [Field: Short Name Field1]

    Width : @@ShortNameWidth
    Max : @@MaxNameWidth
    Style : Normal Bold
    Format : "NoZero,Percentage"
    Align:Center
    Skip : YES
    Border : Thin Left Right
    Case : Title Case
    [Field: Short Name Field2]

    Width : @@ShortNameWidth
    Max : @@MaxNameWidth
    Style : Normal Bold
    Format : "Percentage, No Zero"

    Align:Center
    Skip : Yes
    Case : Title Case

    [Field: dis1]

    Width : @@ShortNameWidth
    Max : @@MaxNameWidth
    Style : Normal Bold
    Align:Center
    Set as:$Discount
    Skip : Yes
    Case : Title Case




    ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;title;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

    [Field : Deactive Item SNo]
    Use : Name Field
    Set as : $$Line
    Style : Normal

    Background: BLACK
    Skip : YES
    Color:white

    Width : 40
    Align : Centre
    Border : Thin Right

    [Field : Deactive Item Name]
    Use : Name Field
    Set as : ""
    Width : 18
    Background: BLACK
    Color:white
    Align : Left
    Style : Normal
    Skip : YES
    Border : Thin Right

    [Field : Deactive Item Reason]
    Use : Name Field
    Set as : ""
    Width : 25
    Skip : YES
    Background: BLACK
    Color:white
    Align : Left
    Space Left : 1% Screen
    Style : Normal Italic
    Border : Thin Right
    [Field : QUANTITY]
    Use : Name Field
    Set as : ""
    Width : 10
    Skip : YES
    Background: BLACK
    Color:white
    Align : Left
    Space Left : 1% Screen
    Style : Normal Italic
    Border : Thin Right
    [Field : RATE5]
    Use : Name Field
    Set as : ""
    Width : 10
    Skip : YES
    Background: BLACK
    Color:white
    Align : Left
    Space Left : 1% Screen
    Style : Normal Italic
    Border : Thin Right
    [Field :DIS%]
    Use : Name Field
    Set as : ""
    Width : 9
    Skip : YES
    Background: BLACK
    Color:white
    Align : Left
    Space Left : 1% Screen
    Style : Normal Italic
    Border : Thin Right
    [Field :GST%]
    Use : Name Field
    Set as : ""
    Width : 14
    Skip : YES
    Background: BLACK
    Color:white
    Align : Left
    Space Left : 1% Screen
    Style : Normal Italic
    Border : Thin Right
    [Field :TOTAL AMT]
    Use : Name Field
    Set as : ""
    Width : 12
    Skip : YES
    Background: BLACK
    Color:white
    Align : Left
    Space Left : 1% Screen
    Style : Normal Italic
    Border : Thin Right
    [Field :Stock]
    Use : Name Field
    Set as : ""
    Width : 18
    Skip : YES
    Background: BLACK
    Color:white
    Align : Left
    Space Left : 1% Screen
    Style : Normal Italic
    Border : Thin Right


    ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;title end;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

    ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;FONT;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
    [Style: Parth CMP Name1]
    Font: News706 BT
    Height:100
    Bold: Yes
     

    Attached Files:



  2. teja varma

    teja varma Active Member


    use this function to get price level rate:
    Code:
    $$GetPriceFromLevel:"item name":price level name":($$Date:"1-4-19"):"10"
    for discount:
    Code:
    $$GetDiscountFromLevel:"item name":price level name":($$Date:"1-4-19"):"10"

    parameter 1 : item name
    parameter 2: price level name
    parameter 3: date
    parameter 4 :quantity
     
    Last edited: Dec 26, 2019


  3. rahul nigotiya

    rahul nigotiya New Member


    not working
     


  4. teja varma

    teja varma Active Member


    show the code you are using or did you get any errors
     


  5. rahul nigotiya

    rahul nigotiya New Member


    [Line: ledgerwishrate]
    Local: Field: Rate2: Set as:""

    [Field: Rate2];;;;;;;;;;;;;;;Rate;;;;;;;;;;;;;;;;;;;;;;;;;;;
    Field : STQ StdSalePrice1

    Style : Normal Bold

    [Field: STQ StdSalePrice1]

    Use : Rate Field
    Width : 9

    Set as : $$GetPriceFromLevel:$StockItem:$PriceLevel:($$Date:$Date):$BilledQty
    Align : Left
    Format : "Symbol," + ##ShowForex
    Cells : 1
    Skip:Yes
     


  6. teja varma

    teja varma Active Member


    your code is incomplete please post full code to analyze..

    $StockItem , $Pricelevel methods only work in voucher collection

    you can try hardcode item name and price level to test then you can implement using method values.....
     


  7. rahul nigotiya

    rahul nigotiya New Member


    sir, i am not expert in coding so dont know what is hard code .. i m giving you my full code which i am trying to make .. all the code is working fine except price level rate and discount , main chahta hu ki jab bhi main koi item select karu to rate aur discount price level ( jo already define kar rakha hai) ke hisab se aa jaye ... pls help me in this code .. thnx
     

    Attached Files:



  8. teja varma

    teja varma Active Member


    try this:
    Code:
    [#Menu: Gateway OF Tally]
    Add: Toolbar Buttons: ledgerhotkey
    
    [#Form: Default]
    Add: Toolbar Buttons: After: HelpButton : ledgerhotkey
    
    [button: ledgerHotKey]
    Key: F5
    Action: alter : ledgerwishrate
    Title: "PARTY WISH ITEM RATE"
    
    [Report: ledgerwishrate]
    Form: ledgerwishrate
    Set            : SVFromDate    : @@DSPFromDate
    Set            : SVToDate        : @@DSPToDate
    
    Title: "PARTY WISH ITEM RATE"
    
    [Form: ledgerwishrate]
    No Confirm: yes
    Part: ledgerwishrate,
    Option: Small size form
        Height        : 20% Screen
        Width        : 100% Screen
    [Part: ledgerwishrate]
    Line:daybookhead,Deactive Item Title,ledgerwishrate,daybookhead1
    
    [Line :daybookhead]
    Use         : Form SubTitle   
    
    Local : Field : Form SubTitle    : Set As :$$String:##SVCurrentDate+"              "+ " PARTY WISH ITEM RATE "  +"               "+" Company Name :- "+ @@CmpMailName
    Local : Field : Form SubTitle : Style :Parth CMP Name1
    Local : Field : Form SubTitle : Full Width: Yes
    Local : Field : Form SubTitle :Skip    : YES
    Local : Field : Form SubTitle :Color: BLACK
    
    [Line :daybookhead1]
    Field: Simple Field
    Space Top:0.10 Inch
    Local : Field :Simple Field    : Set As :" #DILIP "
    Local : Field : Simple Field: Style :Parth CMP Name1
    Local : Field : Simple Field : Full Width: Yes
    Local : Field : Simple Field:Skip    : YES
    Local : Field : Simple Field :Color    : BLACK
    
    
    [Part    : Deactive Item Title]
        Line        : Deactive Item Title
        Border        : Thin Box
           
       
    [Line    : Deactive Item Title]
       
        Field    : Deactive Item SNo,Deactive Item Name,Deactive Item Reason,QUANTITY,RATE5,DIS%,GST%,TOTAL AMT,Stock,
        Border : ColumnTitles
        Local    : Field    : Default : Align : Centre
        Local    : Field    : Default : Style : Normal Bold
        Local    : Field    : Deactive Item SNo  : Set as :"PARTY NAME"
        Local    : Field    : Deactive Item Name : Set as :"PRICE LEVEL"
        Local    : Field    : Deactive Item Reason : Set as :"ITEM NAME"
        Local    : Field    : QUANTITY: Set as :"QUANTITY"
        Local    : Field    : RATE5: Set as :"RATE"
        Local    : Field    : DIS%: Set as :"DIS%."
        Local    : Field    : GST%: Set as :"GST@%"
        Local    : Field    : TOTAL AMT: Set as :"FINAL AMT"
        Local    : Field    : Stock: Set as :"STOCK"
    
       
       
    [Line: ledgerwishrate]
    Field: Ledgerselect,Short Name field1,itemlist,Short Name fiel,Rate2,discount,gst2,final rate,cl stock2
    Border : Flush Column Titles
    Local: Field: Short name field1 : Set as: $$LocaleString:$PriceLevel:ledger:#Ledgerselect
    Local: Field: Short Name fiel : Set as: ""
    Local: Field: Rate2: Set as:""
    Local: Field: gst2: Set as: $GSTIGSTRate:StockItem:#itemlist
    Local: Field: final rate : Set as: $LastSalePrice:StockItem:#itemlist*($GSTIGSTRate:StockItem:#itemlist)/100+$LastSalePrice:StockItem:#itemlist
    Local: Field: cl stock2 : Set as: $$AsInQty:$ClosingBalance:StockItem:#itemlist
    Space Top:0.10 Inch
    
    
    
    
    
       
    
    [Part: VCH Display Rate1]
    
    Line    : VCH Display Rate1
    
    [Line: VCH Display Rate1]
    Right Field:Short Name fiel,Rate2,discount,gst,final rate,cl stock2
    Local: Field: Short Name fiel : Set as: ""
    Local: Field: Rate2: Set as: ""
    Local: Field: discount : Set as: ""
    Local: Field: gst : Set as: ""
    Local: Field: final rate : Set as: ""
    Local: Field: cl stock2 : Set as: ""
    
    
    
    
    [Field: Ledgerselect];;;;;;;;;;;;;;;party name list;;;;;;;;;;;;;;;;;;;;;;;;;;;
    Use: short name field
    Table: Ledger
    Align:Center
    Width : 40
    Border  : Thin Left Right
    Show Table: Always
    [Field: pricePl];;;;;;;;;;;;;;;party name list;;;;;;;;;;;;;;;;;;;;;;;;;;;
    Use:Number Field
    Table: Price Levels
    
    Align:Center
    Width : 40
    Border  : Thin Left Right
    Show Table: Always
    
    [Field: Short Name fiel];;;;;;;;;;;;;;;Price level;;;;;;;;;;;;;;;;;;;;;;;;;;;
    
        Width       : @@QtyWidth
        Max         : @@MaxNumberWidth
        Style       : Normal Bold
        Format      : "No Zero"
        Align       : Right
        Key         : Calculator
        Option        : SetAlignLeft    : @@IsRightToLeftScript
    
    [Field: Rate2];;;;;;;;;;;;;;;Rate;;;;;;;;;;;;;;;;;;;;;;;;;;;
    Field    : STQ StdSalePrice1
       
        Style    : Normal Bold
       
    [Field: STQ StdSalePrice1]
       
        Use        : Rate Field
        Width : 9
        Set as    : $$GetPriceFromLevel:#itemlist:#ShortNameField1:($$Date:##SvCurrentDate):#ShortNameFiel
        Align    : Left
        Format    : "Symbol," + ##ShowForex
        Cells    : 1
        Skip:Yes
       
    
        [Field: discount];;;;;;;;;;;;;;;discount;;;;;;;;;;;;;;;;;;;;;;;;;;;
            Use:Number Field
                 Set as :$$GetDiscountFromLevel:#itemlist:#ShortNameField1:($$Date:##SvCurrentDate):#ShortNameFiel
                
                    Format    : "NoZero, Percentage"
                    Align    : Centre
                    Border  : Thin Left Right
                    Background:white
                    Set Always:Yes
                   
               [Field: gst2];;;;;;;;;;;;;;;gst;;;;;;;;;;;;;;;;;;;;;;;;;;;
                   Use         : Number Field
                    Border      : Thin Left
                    Align       : Centre
                    Width       : 5% Page
                    Style       : Small
                    Format        : "Percentage, No Zero"
                    Skip    : YES
    [Field: final rate];;;;;;;;;;;;;;;Final rate;;;;;;;;;;;;;;;;;;;;;;;;;;;
    Use: Rate Field
    Width:8
    
    Align    : Left
        Format    : "Symbol," + ##ShowForex
        Cells    : 1
        Skip:Yes
    
    
        [Field: cl stock2];;;;;;;;;;;;;;;Item stock;;;;;;;;;;;;;;;;;;;;;;;;;;;
        Width       : @@ShortNameWidth
        Max         : @@MaxNameWidth
        Style       : Normal Bold
        Format      : "Symbol, Short Form, No Compact"
        Align:Center
        Border                : Thin Left
        Case        : Title Case
        Skip:Yes
       
    
    [Field: itemlist];;;;;;;;;;;;;;;Item name list;;;;;;;;;;;;;;;;;;;;;;;;;;;
    Use: short name field
    Table: Stock Item
    Width : 29
    Show Table: Always
    [Field: PriceLevels];;;;;;;;;;;;;;;Item name list;;;;;;;;;;;;;;;;;;;;;;;;;;;
    Use: short name field
    Table: Price Levels
    Width : 25
    Show Table: Always
    
    [Field: Short Name Field1]
    
        Width       : @@ShortNameWidth
        Max         : @@MaxNameWidth
        Style       : Normal Bold
         Format      : "NoZero,Percentage"
        Align:Center
        Skip    : YES
        Border  : Thin Left Right
        Case        : Title Case
        [Field: Short Name Field2]
    
        Width       : @@ShortNameWidth
        Max         : @@MaxNameWidth
        Style       : Normal Bold
        Format        : "Percentage, No Zero"
       
        Align:Center
        Skip    : Yes
        Case        : Title Case
       
    [Field: dis1]
    
        Width       : @@ShortNameWidth
        Max         : @@MaxNameWidth
        Style       : Normal Bold
        Align:Center
        Set as:""
        Skip    : Yes
        Case        : Title Case
       
       
    
    
    ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;title;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
    
    [Field    : Deactive Item SNo]
        Use         : Name Field
        Set as         : ""
        Style         : Normal
       
        Background: BLACK
        Skip    : YES
        Color:white
       
        Width : 40
        Align         : Centre
        Border        : Thin Right
       
    [Field    : Deactive Item Name]
        Use        : Name Field
        Set as        : ""
        Width : 18
        Background: BLACK
        Color:white
        Align        : Left
        Style        : Normal
        Skip    : YES
        Border        : Thin Right
       
    [Field    : Deactive Item Reason]
        Use        : Name Field
        Set as        : ""
        Width : 25
        Skip    : YES
        Background: BLACK
        Color:white
        Align        : Left
        Space Left    : 1% Screen
        Style        : Normal Italic
        Border        : Thin Right
    [Field    : QUANTITY]
        Use        : Name Field
        Set as        : ""
        Width : 10
        Skip    : YES
        Background: BLACK
        Color:white
        Align        : Left
        Space Left    : 1% Screen
        Style        : Normal Italic
        Border        : Thin Right
    [Field    : RATE5]
        Use        : Name Field
        Set as        : ""
        Width : 10
        Skip    : YES
        Background: BLACK
        Color:white
        Align        : Left
        Space Left    : 1% Screen
        Style        : Normal Italic
        Border        : Thin Right
    [Field    :DIS%]
        Use        : Name Field
        Set as        : ""
        Width : 9
        Skip    : YES
        Background: BLACK
        Color:white
        Align        : Left
        Space Left    : 1% Screen
        Style        : Normal Italic
        Border        : Thin Right
        [Field    :GST%]
        Use        : Name Field
        Set as        : ""
        Width : 14
        Skip    : YES
        Background: BLACK
        Color:white
        Align        : Left
        Space Left    : 1% Screen
        Style        : Normal Italic
        Border        : Thin Right
        [Field    :TOTAL AMT]
        Use        : Name Field
        Set as        : ""
        Width : 12
        Skip    : YES
        Background: BLACK
        Color:white
        Align        : Left
        Space Left    : 1% Screen
        Style        : Normal Italic
        Border        : Thin Right
        [Field    :Stock]
        Use        : Name Field
        Set as        : ""
        Width : 18
        Skip    : YES
        Background: BLACK
        Color:white
        Align        : Left
        Space Left    : 1% Screen
        Style        : Normal Italic
        Border        : Thin Right
       
    
        ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;title end;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
    
    ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;FONT;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
    [Style: Parth CMP Name1]
    Font: News706 BT
    Height:100
    Bold: Yes
    
    code looks bad ,not well structured and lot of errors
    see sample code snippets and videos provided by tally solutions so you can write better code...

    I just solve pricelist rate and discount part
    remaining things implement yourself
     


  9. rahul nigotiya

    rahul nigotiya New Member


    THANK YOU SO SO MUCH ...YOU SOLVED MY BIG PROBLEM
     


  10. rahul nigotiya

    rahul nigotiya New Member


    sir , with ur help i almost completed my tdl except gst rate .. for gst rate i have used this code
    Local: Field: gst2: Set as: $TotalIGSTTaxAmount:StockItem:#itemlist
    but this code not working .... can you pls help me to get correct code for gst rate
     

    Attached Files:



  11. teja varma

    teja varma Active Member


    To get GST RATE of item (for your env):
    Code:
    $(StockItem,#itemlist).GSTDetails[Last].StatewiseDetails[1, @@IsAnyState].RateDetails[1, @@IsIGST].GSTRate
     


  12. rahul nigotiya

    rahul nigotiya New Member


    this code not working
     


  13. teja varma

    teja varma Active Member


    its working fine I am able to get gst rate as well:
    netrate.PNG
     


  14. neha shruti

    neha shruti New Member


    how to store 2nd discount value in price list price level ??
    need help
     


  15. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    by defining it in [System : UDF]
     


  16. neha shruti

    neha shruti New Member


    done the same but its not working...the value is not getting saved....when reopen price list the field is blank
     



  17. Try This


    [#Line: MPS BodyTitle1]
    Add : Field : After : MPSRateTitle : Icon_Nav_PlLenghtTit;,Icon_Nav_PlBrithTit,Icon_Nav_PlHeightTit,Icon_Nav_PlOurRate

    [#Line: MPS BodyTitle2]
    Add : Field : After : MPSRateTitle : Icon_Nav_PlLenghtTit;,Icon_Nav_PlBrithTit,Icon_Nav_PlHeightTit,Icon_Nav_PlOurRate
    Local : Field : Icon_Nav_PlLenghtTit : Set as : ""
    Local : Field : Icon_Nav_PlBrithTit : Set as : ""
    Local : Field : Icon_Nav_PlHeightTit : Set as : "Ness"
    Local : Field : Icon_Nav_PlOurRate : Set as : "Rate"

    Local : Field : Icon_Nav_PlLenghtTit : Border : Thin left
    Local : Field : Icon_Nav_PlBrithTit : Border : Thin left
    Local : Field : Icon_Nav_PlHeightTit : Border : Thin left
    Local : Field : Icon_Nav_PlOurRate : Border : Thin left right

    [Field : Icon_Nav_PlLenghtTit]
    Use : Name Field
    Set as : "NEW RATE"
    Width : 20 mms
    Align : Center
    Skip : Yes
    Border : Thin left
    ;================================Adding Three Field in Price List Creation
    [System: UDF]
    PLDiscAmt : Amount : 1000
    [#Object: MPL Price Level List]
    Storage : Discount Amt : Amount
    [#Line: MPS Explode]
    Add : Fields : After : MPSExplRate : PL Disc Amt;,PL Disc Amtlen,PL Disc AmtThick
    [Field: PL Disc Amt]
    Use : Amount Field
    Storage : Discount Amt
    Set as : $(StockItem, #MPSStockItemName).FullPriceList[1,($PriceLevel = ##SVPriceLevel AND $Date = ##SVPriceLevelDate)].PriceLevelList[$$Line].PLDiscAmt
    Width : 20 mms
    ;Width:THICK LEFT
    [#Form: Multi Price Set]
    Add : On : Form Accept : Yes : CALL : PL Update UDF
    [Function: PL Update UDF]
    Variable: StockItem : String
    Variable: FromQty : Quantity
    Variable: ToQty : Quantity
    Variable: DiscountAmt : Amount
    00 : WALK COLLECTION : Full Price List
    10 : SET : StockItem : $StockItemName
    20 : WALK COLLECTION : Price Level List
    30 : IF : NOT $$IsEmpty:$DiscountAmt
    40 : SET : FromQty : $StartingFrom
    50 : SET : ToQty : $EndingAt
    60 : SET : DiscountAmt : $DiscountAmt
    70 : MODIFY OBJECT : (Stock Item, ##StockItem).FullPriceList[1, ($PriceLevel = ##SVPriceLevel AND $Date = ##SVPriceLevelDate)].PriceLevelList[1, ($StartingFrom = ##FromQty AND $EndingAt = ##ToQty)].PLDiscAmt[1].PLDiscAmt : ##DiscountAmt
    80 : ENDIF
    90 : END WALK
    100 : END WALK
    [System: UDF]
    PLDiscAmtLen : Amount : 1002
     


  18. neha shruti

    neha shruti New Member


    thank you so much for your supportive help........it's working
     


  19. NSA

    NSA Member


    Sir, I was planning to make UDF to fix the price.

    For Example:

    [#Field: VCHBATCH Rate]
    Set by Condition : $$IsValidPriceLevel:$PriceLevel And $$IsSales:$VoucherTypeName Then $Rate+$UDFStore Else $$Value

    can you please suggest the area where I have to refer?
     


  20. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Do not understand your requirement?

    Show screenshots with remarks and explain whole logic.
     


  21. NSA

    NSA Member


    Sir, My Plan is to fix a base price in Price Level and then Add two UDF field in ledger (Special Customer) . So for the special customer, the rate will be Base Price +/- base price
     


  22. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Have you defined the UDF in the Object???
     


  23. NSA

    NSA Member


    NO sir, Current I was replacing UDF with direct value:

    [#Field: VCHBATCH Rate]
    Set by Condition : $$IsValidPriceLevel:$PriceLevel And $$IsSales:$VoucherTypeName Then $Rate+0.005 Else $$Value

    But in the above case, the VCHBATCH Rate is taking value from Price Level but not adding the 0.005 to it
     


  24. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    In Field: VCHBATCH Rate .... there are many conditions. So based on your Data and settings other conditions must have been active and not your above one. Try to find which one is ACTIVE.......and add your ADDITIONS to that.
     
    NSA likes this.


  25. NSA

    NSA Member


    Thank You Sir
     


Share This Page