In Epicor, is it possible to load a forecast without having it generate demand, but still be able to view the potential workload?
If so, how?
I always defer scheduling questions to @timshuwy, @banderson, or @jkane, but it sounds like you’re asking about “What If?” schedules.
Not that I am aware of. ![]()
The What If is more for playing around with demand that is already in the system. I really can’t think of anything that does that. Maybe someone else knows. ![]()
well, no.. this is not possible within one database. I have seen some companies who have some really advanced research requirements do some things like:
- copy their database to their pilot/training database
- Use this for experiments/trials of future forecasts/changes
- Once they like what they see, then they do the same forecast/change in their production environment.
one company i talked to reciently does this on a weekly basis.
Thanks all! Seems there is no solution unless we run in testing database.
Frankly, it’s not a bad solution. It moves the processing off of your main server, so it doesn’t interfere with current production. It gives a stable point of reference, so new demands are not interring with your impact investigation. And it’s easy to restore to try alternatives. ![]()
Only thing I’ll say is you better keep others out of that environment so they don’t mess with anything.
Right, which is something you can’t do if you’re experimenting in production!
true!
Also look at database snapshots (a SQL thing). You can set a restore point, do some stuff, then restore back to that state in a matter of seconds. It’s pretty slick when you want to set up for a test, do it, then not have to reset up all of the stuff to get to the start of the test. We use it occasionally when we are developing because setting up test scenarios can be super time consuming.
You could also use DMT to delete current forecasts and when you are finished, DMT the forecasts back into the database.