not sure how complex your rules are,   hopefully this helps

use a numeric formula on criteria where value =1 ……… when the “when” statements are =1 then  your rules are met.

case when {inventorylocation} like ‘%Quiet%’ and {locationquantityavailable} =0 then 1 when {inventorylocation} like ‘%Beac%’ and {locationquantityavailable} >1 then 1 else 0 end

You can do it in Celigo , depending on the step/method/objective you are using in Celigo  you can either use handlebars or javascript to reformat the input or output.

If you are trying to convert it to a one-to-many structure javascript id most likely the way to go.

You can most likely do it  via suiteql / custom suitelet

Unfortunately i do not have the exact same issue, but have similar issues with outsource manufacturing.

Can you manually fill in the inventory location at the line level? if not i am stumped.

? do u have the preferred inventory location set for the item?  just a thought. (i have never needed to in my case)

opt1: create user event derivation logic to manage location/department for builds/receipts/fulfillments/transfers per business rules.

opt2: create  workflows but u will most likely still need scripts

Yes only that item will get updated, use the same parameters (begin/end of day). …. Be aware the prebuilt Netsuite reports do not update immediately can take an hr to update (creates confusion sometimes)…… save-searches will update immediately