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 :)

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).

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