Hi @Solufy I already tried this but it is not fetching the values for me not be able to understand what is the problem as I it is not showing any error as well.
Hi @Solufy I’m extremely sorry for giving you so much trouble but it is still not working.
No value is being fetched to that “total_cartons” field.
Let me explain you all the scenario again:-
There are two field in the Sales Invoice Item table
stock_qty and units_in_carton
and the value in stock_qty is added by the user
and I have defined the value of units_in_carton in the ITEM LIST or Item Master what ever you want to say it like.
Now,
I have opened another field with name “total_cartons”
Now I just want that the value of “total_cartons” would be stock_qty/ units_in_carton.
Please guide me and Thank You So Much for the help
Hi @Solufy don’t know what’s the issue with it I still can’t be able to understand it.
I have written down the code correctly, still the field Total_cartons is coming blank.
Hi @Solufy it’s working now, I need a very small changement in this .
Like if the stock qty = 36 and the units in carton = 12 then then output would be total cartons = 3
And for the case where stock qty = 40 but the units in carton is still = 12 so I want it to fetch the value in total carton still 3.
Like only the closest integer value not a float value in the total cartons field.