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

Beginner Asked on April 26, 2020 in Best Practices.
Add Comment
1 Answer(s)

Have you read/tried the approach defined in `Help:Creating Custom Fields with Values Derived from Summary Search Results`?

Beginner Answered on April 26, 2020.

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.

on April 26, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Become a Sponsor   Become a Sponsor