Trying to update BinNum on PartTran to fix Stock Status Report

We as having some Stock Status issues and I found in this thread that the Bins having mixed cases and possibly trailing spaces would effect the report.

After some quick investigation, I found that we are definitely having this issue:

I made a uBAQ that would allow me to change these Bins but it doesn’t seem to be doing anything.

bins

I assume that Epicor doesn’t care about the case, but for some reason the Stock Status report does?

I would see if Epicor has a data fix for it.

Yeah, I think it is an SQL/SSRS thing - case sensitive - E10 has some built in handling

I’ve not tried a UBAQ, not sure it would work.
Instead, I changed these values directly in SQL Server Management Studio