We need to weekly review the sales Rank of the Items based on their sales history of it. Require a field on the Items called “Sales Rank”, that has its ranking in total Sales (over the past year)
Our Solution:
- First of all, we will create a search of sales orders as follows:
2. We can create a script scheduled to run weekly once and it loads the search above and fetches the rank on the corresponding row and set that in a field named “Sales Rank”( field type should be an integer, otherwise sorting of this field in reports results in the wrong order) in the item record lying in the same row.