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.
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 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.