CODEWITHSUNDEEP
formulanetsuitesaved-searches
Learning girl
Learning girl

Reputation: 13

How to add Tax Total, Subtotal,Total and Discount Item in a Saved Search for Sales Orders record in Netsuite?

I'm working with a NetSuite application and trying to create a saved search that calculates Tax Total, Subtotal,Total and Discount Item for sales orders. I've attempted to set this up in the "Results" tab of the saved search configuration, but it doesn't seem to be working as expected.

I would appreciate any advice or examples on how to achieve this. Thank you!

enter image description here

Upvotes: 1

Views: 1626

Answers (1)

M.Dubay
M.Dubay

Reputation: 1

Formula Curreny

Tax: {taxtotal} Shipping: {shippingamount}

Subtotal: nvl({totalamount},0) - nvl({discountamount},0) - nvl({taxtotal},0) - nvl({shippingamount},0)

Upvotes: 0

Related Questions