When looking at time phase for a part, it shows an On-Hand qty of 43.02 (43.0215), as shown here:
This is also reflected in Erp.PartQty.
But when I look at PartBin, I am showing -48.167.
What would cause that discrepancy?
The 43.02 value in Time Phase is the sum of quantities in all bins in the site. You are showing two bin locationsā¦ -48.167 ST and 121 EA. What is the conversion factor of EA to ST? When the two are then summed using a common UOM the value should equal the Time Phase value.
1 Like
Yup, 1 ST = 1 EA. So the math says then that you have -48.167 + 121.000, which comes out to 72.833.
There is a program called āRefresh PartBin QOHā program that checks to be sure the PartBin records match the actual transactions that took placeā¦ I recommend you run that program in Report Only mode to see if perhaps this part needs some attention. If it does, you can run it again in Report and Update mode to fix the issue.
Iāve been waiting for @Ernie to finish before I gave the cheeky answer.
āBecause itās the most unreliable table in Epicor.ā
2 Likes
I was already in the process of running the Refresh PartBin QOH when you posted that, and it just finished:
*****************************************************************************************************************************************************************************************
Processing Started: 10/03/24 11:34:17, UserID = jhecker, Company = KEN, report mode.
No differences found.
Processing Completed: 10/03/24 11:40:22, UserID = jhecker, Company = KEN, report mode.
Total parts processed = 1. Total PartTran records processed = 6012.
*****************************************************************************************************************************************************************************************
It came back with a clean bill of health 
I always look forward to your responses man. They help me keep my sanity 
When you say āitās the most unreliable table in Epicorā, you are referring to PartQty, right?
If I wanted to get a more accurate QOH for a part, what would be the appropriate approach? āSUM(PartBin.OnHandQty) WHERE PartNum = blahblahā ?
1 Like
no, partbin
1 Like
Thatās not a bad thing, but it doesnāt solve the issue.
PartBin is the table @klincecum is referring toā¦ it tends to get confused easily. Thatās why the fix program is a Main Menu item and not buried in the Conversions routines any more.
Are you using hard allocations in Fulfillment Workbench? That shouldnāt affect Time Phase, but worth the look.
Since we are on the subject, does anyone know why this table is so unreliable?
I am not doubting you here, but how in the heck does PartBin have unreliable data?
- 100pcs into Bin ABC - OnHandQty now shows 100
- 25 Out of Bin ABC - OnHandQty should now show 75
- 3 Back into BIN ABC - OnHandQty should now be 78
Does Epicor fail at doing the math, or is it due to UOM conversions not being correct?
1 Like
I had it explained to me once, but that was a long time ago and those brain cells are no longer functional.
1 Like
Thatās just it, I donāt know.
Iām not saying your partbin data is wrong, but in general, partbin certainly can be.
I would put in an idea for them to please put some work into fixing it but there are two problems.
- 1 ā I canāt explain it
- 2 ā Itās probably bad form to start an Idea with āFFSā¦Pleaseā
3 Likes
I couldnāt tell ya. I just came onboard here a week ago and havenāt learned much about how they do things here yet. But if I had to venture a guess, it would be a firm āNoā.
All I remember is itās a vestige of something from pre-Vantage daysā¦ it was a much bigger issue when I started this (long, strange) journey with Epicor on Vantage 8 (I probably had to run the conversion program every month or so), and now itās a pretty rare occurrence. It likely has nothing to do with UOM conversions since they didnāt really exist (in their current form at least) prior to Epicor 9.
1 Like
I canāt think of anything else at the momentā¦ unless someone else has another idea, Iād probably open up a support ticket. Tell them that the OnHand Quantity in Time Phase does not equal the sum of the quantities in the Bin locations, and that the Refresh PartBin QOH program did not find any discrepancies.
Before I do all of that, I really need to get the end user to give me an accurate response to āHow many of that part do we actually have?ā ā¦ I kid you not when I say the response I received was: āSomeā¦not a lot.ā 
1 Like
Huh. Iāve NEVER heard a COMPLETELY non-specific answer like that from a user.
Something new every day!
I am quickly learning that my users here are āsomething specialā.
2 Likes