Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Saved Search not pulling data from Web transactions.
Hi all, I'm having a rather odd issue with my saved search here.
As you can see, the summed totals for Est Ext Cost and Est Gross Profit are really low compared to the Net Revenue.
When I drill down to view the individual lines, it appears to just be skipping lines altogether. The data IS in these column lines on the transactions and it's picking up 0-3 lines per transaction so there really doesn't seem to be any correlation between the transactions as to why this is happening, it's not always just the last item for example.
Here is the formula I'm using. As you might notice, it is correctly picking up on all of the items when they are shipping and setting them to 0.
0