How To Get Subtotal of Invoice | NetSuite - NSAW - OAC

Vismay Barot

Greetings Community, I was wondering what's the most efficient manner to show Subtotal from a NetSuite Invoice in NSAW - OAC?

For instance, in this case:

$705 will be shown by using Tax Line = "F" & "To Be Fulfilled = "T", like this:

But I don't believe "To Be Fulfilled" is the most ideal, for example this other Invoice:

uses this Item:

And if I use above logic, it won't show anything because To Be Fulfilled = "F" in this case:

Everything said, would like to know:
1. What's the most ideal way to show Subtotal?
2. I know in NetSuite Transaction Saved Search, we can turn off Shipping Line, isn't there something similar in NSAW - OAC? Which only turns off Shipping Line?

Thank You So Much for your time and efforts :)

Gianni Ceresa

Your question being about NetSuite data, it isn't exactly in the best place as it isn't a technical question about an OAC feature.

I believe at some point there was a NSAW category here, but I don't see it anymore.

I would have said you should post this in the NetSuite community, but you already did:

https://community.oracle.com/netsuite/english/discussion/4510471/how-to-get-subtotal-of-invoice-netsuite-nsaw-oac

Mark Chuberka

Could you set the item type in the visualization filter to only return items/kits/assemblies/services? I use that to eliminate the other 'stuff'. I also set the expense type (to current as we only sell in the US at this time).