This code done for changing stock item rate in bulk using trigger key with counter and increment function. just experimented for learning purpose... i posted the code here to help the beginners like me...
dear sir, how to repeat trigger function key by date wise. i tried but tally is hanging.. Variable : SVFromDate,SVToDate 01:Set : SVFromDate : $$MonthStart:##SVCurrentDate 02:Set : SVToDate : $$MonthEnd:##SVCurrentDate 03: WHILE : $$MonthStart:##SVCurrentDate<=$$MonthEnd:##SVCurrentDate 04: Trigger key :enter,enter,enter, f3, down, down, ctrl+A, down ;;04: INCREMENT : Counter 05: End While 06: Return
Your condition at 03 is always going to be TRUE........ so it is infinite loop. Please do understand properly the words and syntax used, before using them....... it is self explanatory.
[Function: Trigger] Variable Counter: Number Variable Counter2:Number 00:Set: Counter2:$$Number$$Date: (#SvFromDate - #SvToDate)) 01: Log: ##Counter 02: While: ##Counter<##Counter2 03: Trigger Key: Enter, Ctrl + A, Down 04: Increment:##Counter 05: End While I am not very sure this will work or Not Because I didn't tested it....So, Please check the same and try to understand what you are writing
And There is no solution to stop infinite loop because Suppose If I tell that Write Until 1=1 So, How you will stop this loop..... Mathematically it is not possible
bro thank u for valuable reply and help. But code still not working. trigger function not working. its just idle.
In this code, trigger key function is working but infinite loop is happenning... [FUNCTION:trigger] Variable : Counter : Number 01: Log :counter :#SvFromDate 02: While : ##counter< #SvToDate 03: Trigger key :enter,enter,enter, f3, down, down, ctrl+A, down 04: INCREMENT : Counter 05: End While 06: Return
Why are you making a DATE as a counter.........??? In Excel type today's date and then convert it to a number in another cell......... that is the number a DATEVALUE holds........... Also in Tally -- date is not a number...........
In Your Code You are comparing date and Number So, I don't think It will work because The data type has to be same
dear Amit sir and Himanshu bro, Thank u for the reply. now forget the last topic. now i am changing my query by different method. kindly guide me now i want to use trigger function to accept the voucher by date wise. example if i have 20 sales vouchers dated 01-11-2020, i have to use trigger function for this date only(01-11-2020) . how to do.. please give hint and guide me.
You must try to understand the LOGIC........... You have 20 sales voucher...... assume you made a condition and triggered for sales vouchers of that date.......... then what........... Those 20 sales voucher still has the same date.......... so your function will go on and on and on and on..............
Do not understand what your objectives is.......... So learn this........ When you make a function based on some conditional value.......e.g. as per you......all 20 sales vouchers of 01-11-2020 ..... so when you run your function, the conditions needs to be changed........like date change from 1st to 2nd or whatever, else you will just go round and round with no exit. Or as you tried earlier...have a COUNTER ---10 times, 20 times and so on............. here in this case it will EXIT after your counter is finished.
Dear sir, can i end the loop by selection(selected vouchers) Example As per earlier reply, there are 20 vouchers in 1 -11-20 date, I want to end the function after the 20 th voucher. So my question is that I have selected the 20 vouchers. will the loop end by selection.
Yes you can............make a collection of selected voucher and pass it on to your function........... But again the condition within your function is of date ......... if the date is 01-11-2020 ........... so even after you run your function it will still go on and on and on........
In simple terms.... think it this way.......if you want to call your friend......and you know his number starts from 98887_____ ...last 5 numbers you do not have.... So will you try to find his number or will you go through all possible digits from 00000 to 99999 ???? In this same manner you have to apply logic and structure your code accordingly.
O okk sir mujhe pata nhi tha sir me bhi bigenner hi hu mene kiya to koi fark nhi pada to mene puch liya
