Product Number Character Length - Need 30 Characters

Question

Hello Sage Community, 
 Is there a way to increase the item number field from 20 to 30 characters? Below is an example of an item that is 24 characters long. 
 HDAMTLN450-3545-180TJ-25 
 HD = heavy duty version 
 AMT = a particular style of #######, with a 185 front housing and standard rear housing 
 LN = fits a ##### #### with the old-style ######### ### bushing 
 450 = 450 ### 
 3545 = for .035 to .045 ####### 
 180TJ = has a ###### installed, instead of the standard AMT ####### front end fitting 
 25 = 25' long ######## 
 This part number gives our assembly department all the information they need.

Stephen · Answer

I think we have successfully gone to 35 characters on ITEMREF. It is not a smooth move. It got ugly. The customer has a case into Sage on an anomaly we have discovered and duplicated that created a lot of issues and that pushed back our go live date because our data became inconsistent and corrupted. We think we have resolved it for now. Still testing.

Regard Hulsbos · Answer

The size of the product code is set by the ITM data type. If you have a technical support consultant, I would recommend having them increase the size of the data type on a TEST environment, and validating its outcome, before applying it to the PRODUCTION environment.

Sage X3

Product Number Character Length - Need 30 Characters

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING