Hi, I’m reaching out for some help. I’m working with a client who needs a report showing the historical on-hand quantities of items. Specifically, they need the on-hand quantity for today, 7 days ago, 30 days ago, and 100 days ago. Could you help me create a saved search that will provide this data so I can generate the report for them? Or is there any other way to get the required data?

@Vinay D As you probably know, “on hand” qty is a calculated field. There isn’t an easy way to get beginning on hand qty in the parameters you asked for in saved search because to get that number you have to add-up the effect of all inventory-related transactions since Day 1. As a supply chain professional, I am not sure I can fathom why your client wants this information. Can you ask what they are trying to solve for? What will they use this data for?