Quick BAQ Calculated field for Identifying lowercase values

[kylepbsps (Kyle P)]

Not sure if this is still an issue, but in about 2017, there was an issue with lowercase bins not reporting on Stock Status.
Here is a calculated field you can add to a BAQ to check for these.

There are also posts on writing BPM for preventing lowercase letters during bin creation.
Epicor does have a SQL fix for renaming bins to uppercase you can request though support.

CASE
WHEN LOWER(PartBin.BinNum) COLLATE Latin1_General_CS_AS <> PartBin.BinNum
THEN 1 ELSE 0
END

Alternative Code (searches entire string)

CASE
WHEN PartBin.BinNum LIKE ‘%[a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u,v,w,x,y,z]%’ COLLATE Latin1_General_CS_AS
THEN 1 ELSE 0
END

[kylepbsps (Kyle P)]

BPM for similar task

Force PartNum to be all uppercase

I was able to make a BPM to detect when the PartNum - of a new Part is being created - contains lower case letters. But I can’t seem to get it to change it to uppercase. I’m using a Pre-Proc directive on Erp.Part.ChangePartNum. The method has an argument named ProposedPartNum. I would have though that using a Set Argument/Var widget to set ProposedPartNum to BpmFunc.ToUpper(ProposedPartNum) would do the trick. But it doesn’t. Ideally the BPM works in a way that the Part maintenance form w…

[kylepbsps (Kyle P)]

Another link

Inventory Transfer

So in the Inventory Transfer there is the FromBinNum field. If a user manually inputs this field, it will be saved exactly as typed since it is case-insensitive. Because of this, it’s causing some confusion when people are going and grabbing parts from bins, as 03l01 looks like there’s a letter I in it when the correct bin is 03L01. Here’s what it looks like: [image] I want to make it so that the user can keep entering a bin number without worrying about case sensitivity, but then change the v…