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!
How do I saved search the average cost of an item to a particular subsidiary?
Currently on my test item I have made 2 transaction for the item to test the average cost.
The first transaction is from the Vendor to our subsidiary MPCN, purchasing the item at $10. The second is MPCN selling the item to our other subsidiary MPUK (my primary and the parent subsidiary) at a markup to total $100.
I've created a saved search to find the average cost of the item and as I had hoped the average cost appears to be tied to the subsidiary and not a mix of the two. The saved search is currently telling me that the average cost of the item is $100 and not $55 or something.
0