I’ve been tasked to use the above field in an BAQ, but I can’t find this column anywhere. The only place I’ve found it is in the Job Closing screen and I assume it’s an Epicor calculated column.
Is there any way I can find the value this points to?
You can look at PartTran and sum all of the receipts to that job num.
I thought is was from Jobprod, but couldn’t find that field. I found the Recv’d to Stock on JobAsmbl, but not Recv’d to Job.
do you have jobs a value shows up on? If you do then in test i would setup a job and run a massive quantity thru and have tracing on to see if there are any clues.
My reasoning for the massive quantity is I have an old Epicor 9 searchall stored procedure you could use that will search every table in a database for a particular value.
Yup cheers, this seems to be the fix!
1 Like