We have a field called 'Inspection Required' on item and the requirement is to get it on the PO line level to display the current value from item, I am able to get the value after creating a transaction line field and choosing not to select 'Store Value'. However, when I change the value at the line level (from yes to no or the other way around), the change is not stored and the record saves with the default value from the item instead. Is there a way I can achieve both? like displaying default value from the item and also have an option to change it on the PO. Ideally, I am also asked that the changed value should change the item value as well so any advice on that would be very much appreciated. Thank you

For setting the value on the PO you could just use NetSuites standard sourcing to accomplish this. When setting up the custom transaction line field go to the sourcing and filtering subtab then set the source list to “Item (Line)”. And the source from to “(your custom item field)” If you do this the value will source from the item record but still allow the user to change it at anytime If you want update the item record with the PO value that would be a scheduled workflow First make an item SAved search of items with the Inspection required = Yes but the Transaction.custcol_inspectionrequired = No. use that saved search as the criteria on your scheduled workflow then the only action is to set the item field to No. then set the duration to every 30 min. (Or whatever timing you think is best)