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.
We’re excited to announce that the 2025 Community Recap is now available! This special recap highlights the amazing contributions and achievements of our members over the year and celebrates the collective success of our community.
Check your personalized recap to see the impact you made in 2025 and how your efforts helped shape our community’s growth and success.
View Your 2025 Community Recap
Thank you to everyone for your passion, collaboration, and support. Here’s to building an even stronger community together in the year ahead!
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.