Hello - I am running 2021.2 and trying to figure out why some manufactured parts don’t get rolled when running Cost Rollup wide open. Is it possible there is some limitation to the number of parts it can evaluate? Or some way to tell why it “ignores” some parts?
Did you look at the log file?
2 Likes
Dude - you responded like 20 seconds after I posted. That was incredible! I had not thought to look at the log.. I will try to find it and see if it has any info. Thanks for the suggestion.
2 Likes
It doesn’t show up in the log. I ran it just now for just the one part I was following up on… and it rolled it like nothing. So I don’t think there’s anything inherently wrong with the setup. It just skips some parts. When I look at last rollup date, there are a ton of manufactured parts that have not been getting captured regularly.
1 Like
And the manufactured part is in the group?
1 Like
Is the part marked as manufactured in the site you are in?
1 Like
if the item is marked as Manufactured, the next question is: Have you verified that there is an active/approved revision? is the item marked as Runout or engineering hold? Is the revision in the site that you are rolling up?
3 Likes
If he ran it by itself, and it worked, wouldn’t it rule all that out?
1 Like
I just re-read that. I think I didn’t understand. @dr_dan so it rolls in a group by itself?
1 Like
Yes it does. I haven’t gotten a chance to get back and troubleshoot any further. But yeah this isn’t the first time this has happened. But it’s the first time I investigated and I realized there’s a ton of parts not picked up. I was not aware that I had to do the roll by site. Hard to believe we haven’t been rolling anything in our non main site but maybe that’s what it is.
2 Likes
OK - I did have a chance to look into the different ones that didn’t roll. That vast majority did roll properly. 437 of 4495 did not roll though. It’s a mixture of sites. So far the only common theme I can tell is that there are subassemblies whose revision is in a different site than the parent… but when I roll them by themselves (not wide open), they seem to roll properly. Nothing I can find in the logs. They either are excluded from the roll up altogether or they roll properly. I don’t see errors.
2 Likes
More context: I just rolled 15-20 parts that are heavy movers that had out of date rollup dates in PartRev. Now, all of a sudden, the vast majority of our PartRevs have had their rollup date blanked out. What am I missing? The only goofy thing I can think of is I may have been in a different site when I rolled them than I normally am. Would that do something? I don’t have evidence to suggest that I undid any costs… but the rollup date is now blank.
2 Likes
Nice Dan, well if it’s not in the log then maybe they didn’t code for the exception.
I wonder if there’s anyone @timshuwy knows on the PS team that’s an expert in all the intricacies of the rollup engine.
You’re on to something though, you have to think logically like you are… “would it be able to roll if…?” All the “ifs” could be things like, not an active subassembly revision, etc.
1 Like
Hmm… another thought… if you have a top level item that has phantoms, and those phantoms are not approved, then the top level cannot rollup. I would check the entire BOM structure from top to bottom to make sure that all phantoms and sub-assemblies (pull as assemblies) are approved.
4 Likes
That’s definitely a thing. One of the ones I looked into I found was just approved the same day I ran it. So I know a few items in there were legit unable to roll. But I’m finding the majority will roll if I just select them or a small list of them… But now that I see the Rollup Date randomly clear, I don’t know that my original data was accurate because I was basing it on that field.
2 Likes
That’s where my head was at too.
1 Like
ALso, I can look back at the CostPart table and find these parts whose RollupDate is clear and show that they were rolled and posted… so what makes the RollupDate clear?
1 Like
Ah, so in your original post you were basing whether it rolled or not if it had that date, is that right? That may not be indicative of whether it “rolled” or not
also Dan, what happens if the cost doesn’t change… does that stay clear then?
1 Like
Yes - exactly.
Unsure. I will check and report back.
1 Like
This assumption def something to look into. Looking forward to hearing back. Anything I can learn about costing is great!
1 Like