Hey Everyone! I’ve never stumbled upon this issue before…we have a part in the part table but Epicor cant find it. [image] [image] Any idea why? GetByID Method: [image]

Space at the end or beginning? In the Db?

Does the Company matter? I notice the BO looks in the current company Also as a general observation, I see that the GetByID, calls InnerGetByID, which actually uses a stored proc for the query

You are for sure looking at the same DB right? (had to ask)

I don’t believe it is company/site related as we really only use one company. Support is saying there could be a bad record in the plantwhse or partplant tables. We shall see. Now what makes the bad record happen to begin with? Thats the million dollar question. I am looking at the same DB hahaa.…

Just curious … What is the little arrow next to the Part field? Something new since 10.1.400? Or is this a customization? [image]

[image] jgehling: Support is saying there could be a bad record in the plantwhse or partplant tables. We shall see. Now what makes the bad record happen to begin with? We get the bad plantwhse record thing pretty often. I run a DataFix Workbench to fix them, at least once a month. But they…

looks like it is because we have a bad warehouse / site combo in the plant whse table How did that happen? hmmmm

We recently had the exact same issue but I was unable to determine what caused the records to be created. I have not been able to replicate the issue in our Test system either so if you can determine a cause I would love to hear it.

Well....this is a weird one Part Exists in SQL But Not Found

Epicor ERP 10

Banderson (Brandon Anderson) February 27, 2019, 5:31pm 8

You can make BAQ’s run when you hover over it. I have one for part where used. (and other things)

Button to New BAQ Window

Topic		Replies	Views
Sales Order Entry - right-click on Part Number - error Epicor ERP 10 e10 , open-with	12	1343	October 30, 2020
Part cost data not found Epicor ERP 10 costing , rma	4	1778	June 16, 2021
Interesting bug in 10.2? BAQ editor Epicor ERP 10	22	1587	October 3, 2018
Part Service error when loading Part into Entry / Tracker Epicor ERP 10 e10 , epicor , error , part	1	501	October 25, 2023
Part Tracker shows conflicting QOH Epicor ERP 10	23	7477	July 21, 2021

Well....this is a weird one Part Exists in SQL But Not Found

Related topics