Hi Community,
I’m working on GI POLines 2.0, where I can see a bunch of relevant data all in one spot. I’m trying to create a field and formula that will give me a run rate for specific products over a specified date range.
The data I would need is InventoryID - SUM of QTY on SO’s created during a date range, ideally <@Today-180.
I’m struggling to figure out the best place to pull the data and/or write a formula where it will SUM the total quantity sold and allow me add date parameters.
Attached is the GI I’ve been using.
Thanks for the help.
PS - I am running 2022 R1 Commerce Edition. I do not have the manufacturing module.