Generic Inquiry - Product Run Rate formula

  • 10 January 2023
  • 0 replies

Userlevel 3

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.  


0 replies

Be the first to reply!


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved