Q: Hey all, is there any way to set the line item 'price level' via a workflow? For more context, I am trying to help our Marketing team automate orders that they send out for promotional purposes (ie. event giveaways and partnerships) and to do so in a way that properly accounts for the sale (0% margin sale COGS should balance out). I am attempting to create a workflow that changes the item price(amount) to equal the item's cost. I have been able to successfully do this in the UI but am having issues when trying to run this workflow with a web services context. (Ultimately I would love for these internal Marketing folks to be able to place an order through our site and not have to work in NS directly themselves.) However, I am running into an issue with this approach... When we upload the order via web services, our discount items get uploaded with a 'custom' price level. Once I update the inventory items price to their cost via my workflow, the discount line item remains at the custom price and when the order attempts to save it bonks because it's now a negative amount. I'm trying to 'reset' the discount item so-to-speak but am not having success. Any suggestions? My one thought was to change the discount line 'price level' back to base price but I'm not sure you can target that column in a Sublist Action on a workflow. Thanks again!

i've not seen price level be a sublist field that you can set via workflow yet. I think you'd have to script that.