web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / KB 4616239 - Retail ch...
Supply chain | Supply Chain Management, Commerce
Answered

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

(0) ShareShare
ReportReport
Posted on by VRD

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

I have the same question (0)
  • VRD Profile Picture
    VRD 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.

  • Suggested answer
    Diogo_STMonteiro Profile Picture
    Diogo_STMonteiro on at
    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 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
    Diogo_STMonteiro Profile Picture
    Diogo_STMonteiro on at
    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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Siv Sagar Profile Picture

Siv Sagar 303 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 173 Super User 2025 Season 2

#3
Laurens vd Tang Profile Picture

Laurens vd Tang 93 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans