add minimum and maximum selling price

Discussion in 'Free Source Codes' started by bikash agarwal, Sep 6, 2019.

         

  1. HELLO SIR ,
    CAN ANYONE HELP ME IN ADDING MINIMUM AND MAXIMUM SELLING PRICE RANGE ...
    or anything similar to that ... please :):):):)
     
    Last edited: Sep 7, 2019


  2. teja varma

    teja varma Active Member


    where will you define the maximum and minimum selling price
     



  3. where we create item --- on that page !!
     


  4. teja varma

    teja varma Active Member


    do you want to show the minimum and maximum prices to the user while entering invoice?
    or
    do you want to control the user to enter in that range only?
     



  5. control the user to enter in that range only ... this one
     

    Attached Files:

    • 224.jpg
      224.jpg
      File size:
      290.3 KB
      Views:
      107


  6. teja varma

    teja varma Active Member


    Code:
    [#Part: STKI Batch]
        Add:Line:At End:Globalminprice,Globalmaxprice
       
    [Line:Globalminprice]
        Space Top:0.1
        Field:Medium Prompt,Globalminprice
        Local:Field:Medium Prompt:Set as:"Min Selling Price"
       
    [Field:Globalminprice]
        Use:Rate Price Field
        Set Always:Yes
        Width:10
        Storage:iteminsaleprice
       
    [Line:Globalmaxprice]
        Space Top:0.1
        Field:Medium Prompt,Globalmaxprice
        Local:Field:Medium Prompt:Set as:"Max Selling Price"
       
    [Field:Globalmaxprice]
        Use:Rate Price Field
        Set Always:Yes
        Width:10
        Storage:itemaxsaleprice
       
    [System:UDF]
        itemaxsaleprice:Rate:5628
        iteminsaleprice:Rate:6523
       
    [#Field:VCHBATCH rate]
        Control:notvalidpricerange:if NOT $$InAlterMode and ( $$Value < $iteminsaleprice:Stockitem:$StockItemName or $$Value > $itemaxsaleprice:StockItem:$StockItemName)then Yes else No
       
    [#Field: VCH rate]
        Control:notvalidpricerange:if NOT $$InAlterMode and ($$Value < $iteminsaleprice:Stockitem:$StockItemName  or $$Value > $itemaxsaleprice:StockItem:$StockItemName) then Yes else No
       
    [System:Formulae]
        notvalidpricerange:"Hey the rate you entered is out of selling range!"
    
    
    rest of the things (user control and enable that option for items ) you have to implement according to yours need
     



  7.  



  8. thanks sir !! ;););)

    if we could add a menu to veiw prices min --- max mode ---

    something similar to uploaded pic ....
     

    Attached Files:

    • 558.jpg
      558.jpg
      File size:
      135 KB
      Views:
      108


  9. teja varma

    teja varma Active Member


    yes but you need make to the Enter Min and Max Rates Period wise
    when user enter Min and Max Rates they need to mention From and To Period which those rates are valid
    so that we can display a report according to that periods
     



  10. period wise is ok if we put _ no issue _the whole financial year can be putten as default ...
     



  11. please sir help us !! teja ji ...it will be very kind of you
     


  12. teja varma

    teja varma Active Member


    go ahead and design a report I will guide you
     



  13. please sir !!! i don't about reports !!
     



  14. please sir make a report otheerwise tdl will be half effective !! please help me teja ji
     


  15. teja varma

    teja varma Active Member


    okay but i am not available for few days as i indulge in a project
    i will upload soon
     



  16. please sir put the report for min - max selling prices !! as you said ... upload soon
     


  17. tejeet

    tejeet Member


    sir,
    please check above code,it is not working , it passes voucher entry even it is less or more than minimum & maximum limit specify in stock item, so please update corrected code
     


  18. teja varma

    teja varma Active Member


    it only work in create mode not in alter mode
     


  19. tejeet

    tejeet Member


    dear sir,

    please modify above codes , so that i can work both in create mode & also in alter mode
     


  20. teja varma

    teja varma Active Member


    Code:
    [#Part: STKI Batch]
        Add:Line:At End:Globalminprice,Globalmaxprice
     
    [Line:Globalminprice]
        Space Top:0.1
        Field:Medium Prompt,Globalminprice
        Local:Field:Medium Prompt:Set as:"Min Selling Price"
     
    [Field:Globalminprice]
        Use:Rate Price Field
        Set Always:Yes
        Width:10
        Storage:iteminsaleprice
     
    [Line:Globalmaxprice]
        Space Top:0.1
        Field:Medium Prompt,Globalmaxprice
        Local:Field:Medium Prompt:Set as:"Max Selling Price"
     
    [Field:Globalmaxprice]
        Use:Rate Price Field
        Set Always:Yes
        Width:10
        Storage:itemaxsaleprice
     
    [System:UDF]
        itemaxsaleprice:Rate:5628
        iteminsaleprice:Rate:6523
     
    [#Field:VCHBATCH rate]
        Control:notvalidpricerange:if  ($$Value < $iteminsaleprice:Stockitem:$StockItemName or $$Value > $itemaxsaleprice:StockItem:$StockItemName)then Yes else No
     
    [#Field: VCH rate]
        Control:notvalidpricerange:if  ($$Value < $iteminsaleprice:Stockitem:$StockItemName  or $$Value > $itemaxsaleprice:StockItem:$StockItemName) then Yes else No
     
    [System:Formulae]
        notvalidpricerange:"Hey the rate you entered is out of selling range!"
    
     
    Last edited: Nov 26, 2019


  21. tejeet

    tejeet Member


    dear sir,

    please check above codes - tdl error is reporting so please correct above codes
     


  22. tejeet

    tejeet Member



  23. Jay kumar tailor

    Jay kumar tailor Active Member



  24. teja varma

    teja varma Active Member


    i forget to add braces
    check now its edited
    please try to solve yourself .........
     


Share This Page