Categories
- All Categories
- Oracle Analytics Learning Hub
- 19 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 231 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.9K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 86 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How To Get Subtotal of Invoice | NetSuite - NSAW - OAC
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 :)
Best Answer
-
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:
0
Answers
-
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).
1
