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.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
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