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.
Update: Narrative Insights has been restored and is now available.
Narrative Insights is Temporarily Unavailable due to an Infrastructure Issue. Learn how This Impacts Your Account and What to Expect While the Feature is Disabled.
Narrative Insights is Temporarily Unavailable due to an Infrastructure Issue. Learn how This Impacts Your Account and What to Expect While the Feature is Disabled.
Search for Comparing How Much A Customer Has Bought vs Quantity Available
Hi there,
I am looking to create a search with the following information.
Item Code
Description
Quantity Ordered
Quantity in Stock Currently
Average Price
Last Order Date
I am trying to get a search that will give me a list of items that a customer has bought within the last 3 months and then compare that to the available stock.
This would then help us with knowing what the customer may buy in the next three months.
I already have a search working somewhat but it will not allow me to show the current available stock from a Transaction search.
Hope someone can help
0