What is Epicor’s strategy with trailing spaces on part numbers? We have about 40 partnums that have a trailing space on it, but Epicor seems to treat them the same as without a trailing space.
Ex: BAQ query shows "116227L18 " as the part number with the trailing space. When I go to part entry, I entered “116227L18” and clicked tab. It pulls in the part with the trailing space!
We’ve marked our parts with leading spaces as inactive, and created correcting part numbers for those. But for the trailing space, I tried creating a new part with just “116227L18” and Epicor barks that the part number exists already…
Should we just ignore the trailing space part numbers, since they can’t seem to be fixed?
[Part].[PartNum] as [Part_PartNum],
[Part].[PartDescription] as [Part_PartDescription],
[Part].[InActive] as [Part_InActive]
from Erp.Part as Part
where (Part.PartNum like '" %"' or Part.PartNum like '"% "')
Bringing this one back from the dead (Glad to see I’m getting to something that bothered me 5 years ago!).
We run the ‘Update Trailing Spaces’ user run conversion monthly, but I’d like to prevent it in the first place.
How do I add TRIM () to my Part in-trans data directive to trim leading and trailing spaces? I’m not sure how to set up the syntax to do everything. Just add .Trim() after? Or make it a second line? Or something else? Safe to do? Will it break bar code scanners (I can’t image folks loading new part numbers that way…)
Update - I tested adding .ToUpper().Trim() to the Warehouse BinNum as an In-trans Data Directive using ‘Set the … Changed Row to the … expression’ . It works almost too well. It also changes existing bins that were in lowercase to uppercase, just by opening them in Warehouse Bin Entry.
Is that good, or bad? I like that it cleans it up, but are there pitfalls with that (i.e. some partbin record recorded in lowercase won’t match the warehouse bin number exactly, since it’s in a different case)? Or am I overthinking it?
I can change the action to ‘Added’ instead of ‘Changed’, and it won’t update the existing records.