Skip to main content

Notifications

Supply chain | Supply Chain Management, Commerce
Answered

KB 4616239 - Retail channel: Item ID field length for the Retail module from 20 to 100

Posted on by 517

Hi All,

Can someone please help me understand what exactly this KB 4616239 is trying to say and what is it that has been fixed by it?

I have applied Quality of life update on my development box and this KB was part of it.

I tried to find Item ID field length but nowhere i can see it has increased to 100. 


Can someone help me understand which Item ID field of what table exactly it is talking here?

here is the link to this KB on LCS.

https://fix.lcs.dynamics.com/Issue/Details/1194685?kb=4616239&bugId=577045&dbType=3&qc=9e6e3f3977adc015eed64754a69c9bdc0d54d05130e95e1caf7a833742de3997

pastedimage1626355336147v1.png

  • Suggested answer
    RE: KB 4616239 - Retail channel: Item ID field length for the Retail module from 20 to 100

    Hi  IamVikky,

    The KB was released to correct a "truncate" in a Stored procedure, so the field in crt schema has 100 chars and the code was truncating the field to 20.

    So, shouldn't have any negative impact in your external components, quite the opposite, you should apply it to fix the issue.

  • VRD Profile Picture
    VRD 517 on at
    RE: KB 4616239 - Retail channel: Item ID field length for the Retail module from 20 to 100

    Hi Diogo,

    Thanks for your response.

    We are actually upgrading our environment to 10.0.19.

    We have other external commerce system which pushes orders to Retail (RCSU) through API. API calls Retail DLLs.

    so just wanted to make sure if there is any negative impact of this.

    I wonder why this field is of different length than Headquarter field.

  • Suggested answer
    RE: KB 4616239 - Retail channel: Item ID field length for the Retail module from 20 to 100

    Hi Vikky,

    Form what I can check this KB is related with a SQL stored procedure from crt schema (Retail/commerce) object where itemid was with nvarchar(20) instead of nvarchar(100).

    This KB is available in 10.0.18, if you want to get it, please update your environemnt to 10.0.18 and in case of you have a CSU to 9.28.## (10.0.18) 

  • VRD Profile Picture
    VRD 517 on at
    RE: KB 4616239 - Retail channel: Item ID field length for the Retail module from 20 to 100

    Hello Moderators,

    Can we please move this to Finance forum? We are using Finance and Operations where we face this issue but I have used Commerce forum sighting the issue related to Commerce module of F&O.

    Thanks.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans