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!
AE: Assistance creating Saved Search/Report for goods with Highest Value for ABC ranking
Hi All,
Leading on from my previous post, please could someone help me get to terms with creating a report to determine the high value items for ABC analysis.
You can use Microsoft Excel to do a basic ABC inventory analysis. List each product or resource in descending order according to its product usage value. Calculate the total of each item in the aggregate amount. Determine the values for the A, B and C categories, then assign a group name to each item. The goods with the highest value then get the manager's closest attention
Regards
Nitin
Tagged:
0