Discussions
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
NetSuite has launched SuiteSuccess Wholesale Distribution Edition, in Japan. Please join us the webinar on February 12 that introduces NetSuite solution with demos and case studies for Wholesale Industry.
Register Now
Unbilled Amount Net of Tax
Hello there, this query is related in part to an earlier 'Net of tax issues' thread i started a while back, however that issue was in some respects related on US tax issues, my problem this time is with transactions in our core currency. Below are two formulas i have used to get the Amount Unbilled Net of Tax total in GBP, our primary currency and relatively simple in terms of tax (20% Value Added tax). The first formula was i believe suggested on here, and the second i pulled from Suite Answers, but neither are pulling the desired formula.
i'll take a notable example to illustrate, see below. The first formula is showing a negative figure as it is calculating the full amount of two invoices already issued for this project. As the SO amount is net of tax (highlighted in red) and the full value of the Invoices including tax is £221, 309.49 it's showing a negative amount.