Hi All! Has anyone successfully set up a backorder email that's sent to a customer who placed an order containing an out of stock item? My goal is to include the item(s) that are back ordered in the email body. I can do this via a saved search but I don't like how the results are added below the email body - I'd like to insert the results in the middle of the body.

I've done this with scripting. Though you may be able to accomplish this with a custom Advanced PDF and a workflow.

Doing it via advanced PDF would require the information be contained in an attachment rather than the body of the email, right?

Yes, it would. I see that's not what you're after. I think scripting would be the only route

That's what I'm thinking. Unfortunately I'm fairly new to scripting. In your script, did you loop through the item sublist, check the committed qty, and join into the item record to check if the backorder qty is greater than 0? I've read that the backorder column on a transaction record isn't scriptable

You could get the quantity and quantity committed fields to determine if the item is backordered

I thought so too but I've noticed that Netsuite doesn't always commit inventory for items that have enough available inventory - I've only seen this on sales orders that do have another item that really is backordered. This seems to be a known defect as I've read a suiteanswer that recommended that you join into the item record and check the backorder qty there.

Interesting, I've not run into that issue