ITEMREF expansion

Solved

We would like to expand the Item number to 30 characters by changing the length in the ITM data type.

Has anyone expanded their Product field out to 25 or 30 characters as a customization via the ITM data type? How did it work out and were there limitations or constraints encountered.

We are aware we might have issue with crystal reports truncating the data and perhaps some screen space issues and are prepared to deal with those.

Thanks

  • 0

    This one is a question for the community of Sage X3 partners and customers for feedback. Support provided some direction to Stephen and suggested he post here for additional feedback.

  • +1
    Verified Answer

    In theory, you should be able change the length on the ITM datatype setup, and do a dictionary validation for everything filtered by ITM datatype. What this will do is it will increase the length for all ITM data type fields on all screens and all tables. 

    The thing is, it's under the assumption that all product fields are tagged with ITM datatype. While that may hold true 99% of the time, there could be that 1% out there that are not tagged as ITM due to either oversight or program limitation. 

    One example would be price list. Since you can use any field as pricing criteria, it can not be hardcoded as ITM datatype, instead, it's a generic field that allows 40 character. While this will not cause the problem when you increase to 30 characters, but for those who want to increase beyond 40, this will become an issue.

    I personally believe that the only solution is to make this change in a Dev environment first and test. 9 out 10 you will probably be fine, or the 1% occurs on functions you are not using.  But the key is to do a thorough testing on all processes to make sure nothing breaks on the functions you do use. If you see any error, report it your partner and it's likely a easy fix. 

  • +1 in reply to Mike Tsai
    Verified Answer

    Technical notice:

    Ensure the standard data type you are customizing have a custom Activity Code.

    Truncation is guaranteed without preemptive notice in the future if you did not have a custom Activity Code and Sage X3 decided to revert back to Sage X3 standard as part of X3's Folder Validation.

    You can observe my suffering here but for AX3 and when there's a migration work / update or upgrade work / Sage X3 license changed:  Data type: AX3. How to extend characters? 

  • 0

    Hi Stephen

     You need to modify  ITM, ITF, ITV, ITS, ITM.

    Moreover, there are few screens to check where Item field is defined with A data type.

  • 0

    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.

    >>Support provided some direction to Stephen and suggested he post here for additional feedback.

    I will post progress or lack thereof.

    >>While that may hold true 99% of the time

    I'm going with 80% of the time but a few simple additional actions might get you to 99% or better.