Refreshing Part Quantities / Partbin QOH

Kinetic ERP
,
1

I’m assuming the root cause of this issue still hasn’t been resolved since Epicor provides the two menu options to correct it.

In the cases we’ve seen, two things seem consistent:

  1. The parts are manufactured (MFG) job parts
  2. The parts are transferred between sites

Not sure if that’s actually related to the issue, but it’s what we’ve observed.

From the threads I’ve reviewed, Epicor recommends running the correction on a part-by-part basis. We do that when we’re aware of a problem, but with 50,000+ parts, we have no realistic way of knowing an issue exists unless a user reports it.

As we manufacture more parts, this has become a bigger concern because the system sometimes shows inventory that doesn’t actually exist, which has affected our on-time deliveries to our customers.

We also haven’t run MRP on many of these parts yet and are concerned it may plan based on the incorrect quantities.

Has anyone else run into this, and if so, how have you addressed or prevented it?

2 Likes
2

Yes the quantities get out of sync all the time. You can run the utilities on a nightly or weekly schedule wide open.

4 Likes
3

We do what Alisa suggested. We run the Refresh Part Bin process in Report Only mode for all parts weekly on Sundays and then review the log that Monday. If any parts show up, we run the processes for the specific parts as needed.

2 Likes
4

It’s been this way since Vantage 8.0. Plus 1 to @aosemwengie1 suggestion or running it on a schedule

2 Likes
5

Thanks, Alisa. We had done that in the beginning until one day over the weekend when we ran it, it had crashed half way through and came into the office with zero inventory quantities for all of our parts. We’ve been a bit hesitant to do it wide open. We had been doing them part by part since then, but I know that isn’t the best way.

2 Likes
6

Hi Tyler,

This might be the way we will have to d it at least for now.

Thanks

7

Hi Randy,

I figured it went back to at least version 9. When the ‘fix’ is a menu process to run on occasion definitely sends the message of, “we haven’t found the problem, so just run this and you should be fine”. :laughing:

1 Like
8

I run it daily in report mode and made an excel formatted report style so that I can copy and paste the parts that show up into the filter section when I run it in Report and Update mode so that it’s not “wide open”.

2 Likes
9

That make sense. We’ll have to do a report style similar to mimic that so we can run it the same way with the least amount of effort.

Thanks!

10

To clarify I an only running Refresh Part Quantities and Allocations. I don’t run the PArtbin QOH.

11

Your ears must have been burning. I was just discussing with a colleague, “I need to ask which one he is running”. :laughing:

So a couple of other questions pop up though. When a user says, “Hey, this is off. Can you work your voodoo magic”, sometimes we have to run both and then go back for the other to recognize a change is needed. So, I guess we are still a little confused as to are we capturing all of the ones that need to be fixed by only running one of these?

The other question is, what does MRP use to generate suggestions when things may be out of sync? We are only tip-toeing in MRP right now, but this has us worried if the quantities are off and it’s going to suggest a job for XXXX pcs of material.

Another thought is what happens to the inventory G/L totals when this process changes quantities and values of material?

:thinking: :face_with_bags_under_eyes: :woozy_face: :nauseated_face:

1 Like
12

Randy, I can’t answer any of that so I’m sorry. The GLs obviously won’t be right since it takes a part tran to make the financial transaction- which I don’t think either of these programs create.