E9.2 Remove blank spaces in front of the batch number (LOTN)

[gmourasoares]

How to remove blank spaces in front of the batch number (LOTN) without losing the traceability batch between the tables? Exist anything tools for this?

 

[arthart]

By definition, LOTN is a 30-character string field. Blank is a valid character. Your issue is to find what process is creating the leading blanks when the LOTN is being recorded, if the blank is actually an undesirable value.

 

[BOster]

We had such a problem with this that we actually took the very rare step and modified the DD LOTN to not allow leading spaces.

 

[cribeiro]

Besides the SQL?! If you are on JDE E1 9.2 and at least Tools Release: EnterpriseOne 9.2.6.x you can have an orchestration w/ the update statement to the LOTN for the tables F4108/F41021/F4111 etc. See the logic extension and use it in the orchestration that will look for LOTNs starting w/ blank space, I would try data request, then a bsfn to find a char (blank spaces, from 0 to 1) if true, get the logic extension to update the tables where this new lot# exists F4108, f41021, f4111, etc.