We are about a year into using ACM and are still refining our reporting specifically around product availability.
We take at once and future orders(a year or more sometimes) and our planning department is trying to get a shortage report based on a inputted time fence.
We allocate inventory to orders 60 days out.
We are trying to write a report to see where were are short of inventory in a 90 day window and a 120 day window.
Short is defined as a)total on hand inventory, less hard orders b)total on hand inventory less hard order and forecasts.
I was going to create a GI based on item time fence to net out the appropriate elements from PX.Objects.AM.AMRPPlan.
This seems cumbersome, how are other doing this?
