marcoh
Member
Hi
We are using E1 version 8.12, Tools Release 8.96.1.4
We are new users to the E1 world and i would like to know if the following is possible on our version or indeed if anybody else is using a function to solve problem.
Our problem is relating to inventory and not having enough stock to fulfill customer orders due to irregular demand (i.e. Backorders being created). We are running MRP/DRP and everthing seems to be planning correctly however we are coming across occasions where there is a "Spike" in demand for a part number in one particular month. We have a lead time from our supplier of 3 months so by the time our MRP program picks up this demand it is too late.
What we would like is some indication at Sales order entry time if the quantity being ordered is some percentage greater than demand over the last ?? months.
This way we will know at time of order entry there may be an issue with supply in the near future and we can act accordingly.
Exampel of what typically happens
Demand for part A is going along at 100 pieces a month
We have a formula in MRP to have stock coverage for a couple of months.
Then a customer places an order for 600 pieces in one go
While we may have stock on hand to fill this particular order the effect is to wipe out our reserves and therfore any subsequent sales orders placed until we can replenish the stock on a 3 month lead time.
Thanks for any input
We are using E1 version 8.12, Tools Release 8.96.1.4
We are new users to the E1 world and i would like to know if the following is possible on our version or indeed if anybody else is using a function to solve problem.
Our problem is relating to inventory and not having enough stock to fulfill customer orders due to irregular demand (i.e. Backorders being created). We are running MRP/DRP and everthing seems to be planning correctly however we are coming across occasions where there is a "Spike" in demand for a part number in one particular month. We have a lead time from our supplier of 3 months so by the time our MRP program picks up this demand it is too late.
What we would like is some indication at Sales order entry time if the quantity being ordered is some percentage greater than demand over the last ?? months.
This way we will know at time of order entry there may be an issue with supply in the near future and we can act accordingly.
Exampel of what typically happens
Demand for part A is going along at 100 pieces a month
We have a formula in MRP to have stock coverage for a couple of months.
Then a customer places an order for 600 pieces in one go
While we may have stock on hand to fill this particular order the effect is to wipe out our reserves and therfore any subsequent sales orders placed until we can replenish the stock on a 3 month lead time.
Thanks for any input
