Dynamic “Last 12 Months Sales” field on Items
I’m looking for an optimal way to store the total quantity sold in the previous 12 months on Inventory Items.
The update will likely be scheduled on a weekly basis.
I tried starting with a Mass Update, however noticed that summing the transaction quantities wasn’t possible.
Is a Map/Reduce script the only option? One that searches for transactions in the past year and sums quantities, and another to search for items without transactions in the past year (but have > 0 stored previously).
Have you read/tried the approach defined in `Help:Creating Custom Fields with Values Derived from Summary Search Results`?
Sorry, I should have mentioned that I’d like to be able to search on the field value so I don’t believe this method would work.