Refresh Part Quantities and Allocations Schedule

Would it be good practice to run the Refresh Part Quantities and Allocations on a schedule. Maybe once every week or 2.

Yes! I find that monthly works well for us.

1 Like

Thanks!

Do you know how to schedule this to run automatically via the system agent scheduling?

Does anyone know how or if I can Schedule “Refresh Part Quantities and Allocations”? Schedule is grayed out when I pull up the menu item.

Do you have schedules in your system to pick?

image

I do, and I have a couple of tasks already on the schedule.

Thanks,

Rich Wagner

support told me they intentionally do not allow you to schedule this with a recurring task out of the box. You may need to do a trace, and make a bpm that calls this process on a schedule via changing a ud table field via powershell and rest or by looking into a third party add in called user process scheduler.

1 Like

That must be new in .300 then, because I didn’t do anything to make that available. But I’m in 10.2.200

I’m on 10.1.400 and it’s not allowed.

We’ve never been able to run it on a schedule since V8. The reason given is that you cannot guarantee that nobody is in the system at the time of the schedule - which one really shouldn’t have anyone in while this is running or you may get spurious results.

That depends on your business hours I guess. We don’t run it on a schedule, but Epicor doesn’t stop me from putting it on one (the example is in a test system). I don’t know what the difference would be between my system and the others were Epicor doesn’t let you do it.

image

This has been for both on-prem and cloud and V8-E10 for me. :thinking:

This has already been answered I guess, but Report Only versus Report and Update gives different options. You cannot run “Report and Update” on a normal schedule like other processes. I just ran it for the first time in quite some time and was looking to add it to all of the other processes we run, but no option. We are a 20x7 shop and I only have small windows to run them. Seems like something I’ll have to run manually once a month or so.

Have a look at the ‘Automation Tool for Epicor’ (ATE). This should let you schedule this process.
I use it to run large reports for Accounting overnight and save them as xlsx files for them to review in the morning. I’ve been told I could even run conversions, but haven’t tried yet.

Does anybody understand why the numbers get off in the first place?

When I run the report and see 600+ pages of changes it makes me feel like we are doing something wrong. That’s just after a couple of months since it was last run. Is there anything we can do to minimize what gets off?

@caleb.grundmeier - Good question!

We used to run it monthly and get 30+ pages. I was able to set it to a recurring schedule in 10.2.300, so now I run it weekly on the weekend (and no longer have to remote in on a Sunday night, woohoo!), and get about 10 pages worth. Good news is that after we upgraded from 10.0.700.4 to 10.2.300 last February, the Refresh Part Bins no longer comes up with anything. We still run that before Refresh Allocations.

FWIW - in 10.2.300.23, It can be scheduled. But cannot be made recurring.

Aha! Calvin is right… Mine ran last week, but no longer on the schedule. At least Refresh PartBin can be recurring. I wonder why Epicor doesn’t allow Allocations if that’s something that everyone needs to run? Yes, I saw the warning and scheduled it when nobody is making material transactions… If Epicor wanted, they could put a stop in place while Refresh Allocations is running (takes <3 minutes for us, btw).

can you add to a process set and schedule that?
maybe this shouldnt be scheduled?