APEX

Hi,

Our Apex is 24.2.10,

Please see screenshot about my IG grid here. Qty must be multiple of break qty CIP, say this item has break qty=6 and the user types 8, I will round it to 12 automatically by using Qty column's change event like here. it works fine, the problem is Save button doesn't seem clearing out data “changed” status even the data itself is saved, and it only happens with INSERT (new record), I found out this grid is still marked as Changed during refresh , any idea how can I make a clean SAVE for such grid with column value manipulations ? Thank you

var grid$ = apex.region( "CART_IG_ID" ).call( "getCurrentView" ).view$;
       if (qty_hold % cip_qty >0)// not even muliplte of  CIP?     
     // suppress this change otherwise this handler will be triggered again
        $x("QTY_ID").value= Math.ceil(qty_hold /cip_qty)*cip_qty;

       // let's reset the line total
       $x("LINETOTAL_ID").value= (parseInt($v("QTY_ID") ) * price).toFixed(2);
       // make change showing
         grid$.grid("lockActive");
       setTimeout( function() {
        grid$.grid( "setActiveRecordValue", "QTY" );
       grid$.grid( "setActiveRecordValue", "LINETOTAL" );
        grid$.grid( "unlockActive" );
        }, 10 );