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).