HELLO SIR , CAN ANYONE HELP ME IN ADDING MINIMUM AND MAXIMUM SELLING PRICE RANGE ... or anything similar to that ... please
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?
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
thanks sir !! if we could add a menu to veiw prices min --- max mode --- something similar to uploaded pic ....
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
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
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!"