Hey guys, question, how can i access the item discount on the same item line? I see that the discount is on a separate item line. I need to update the sales order email template with the "discounted amount" per item but can't access that directly. I need basically to display the original amount in red and crossed out. Then the discounted amount underneath.

Last time I worked with this, I had to create a script to copy the value from netamountnotax(in a search) into a custom transaction line field. You can either do that in beforeSubmit in create/edit or in beforeLoad in print.

Thank you so much!!

Sorry, if you're using a saved search for filling out the field, you can't do it in beforesubmit. If you want it in beforeSubmit you have to create an algorithm that mimics how Netsuite calculates the application of discounts and subtotals.

For Promotions (similar) we created a custom line field and coped the value from the following line back onto the original line. We updated new SO on a scheduled basis which in turn copied onto Invoices. .Not sure if this will help in your situation.