Projection of inventory

  • 23 January 2021
  • 3 replies

Userlevel 2

I was wondering how well our Acumatica distribution takes care of planning purchase orders and inventory projection (calculation). Attached is a possible scenario in Excel format.. I have also submitted this to  ( )., I didn't check D250 but I did search the and didn't find any answer. 

The projection of SOs, shipments, POs, receipts and inventory level for a particular item in to the next 4 weeks is a basic necessity for warehouse people. purchasing people and manufacturing people. It should be available in the inventory module and the MRP module. When inventory falls below the ROP for instance in week 2, a red flag should be raised. A bar chart would be nice.  Thanks for your help. Toon Six ( .


Best answer by toonsix 5 February 2021, 20:13

View original

3 replies

Userlevel 2

I am very interested if there is any solution to this. I do not have MRP but we do have a need for the same tool. 

Userlevel 2

Hi Stacy:

The closest I have seen is a Lite Manufacturing application of Advanced Solutions and Consulting: . This application does have some projection tables.

I hope that the Acumatica will soon have this in their product roadmap. 


Toon Six

Userlevel 2

Thanks Toon!


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 — 2022  Acumatica, Inc. All rights reserved