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 / Microsoft Dynamics RMS (Archived) / Change Sub Description...
Microsoft Dynamics RMS (Archived)

Change Sub Description captions in HQ item screen

(0) ShareShare
ReportReport
Posted on by bikerg 30

Currently running 3 store ops and 1 hq.  I would like to change the sub description captions in the item properties window to more useful term.  I know it can be done in Store Ops.  Can it be done in HQ Manger.

*This post is locked for comments

I have the same question (0)
  • Taier P Profile Picture
    Taier P 908 on at
    RE: Change Sub Description captions in HQ item screen

    You can modify the HQLanguage.DAT file using notepad in C:\Program Files\Microsoft Retail Managemen System\Headquarters. Look for S6640 - S6668 near the bottom of the list.

  • Community Member Profile Picture
    Community Member on at
    RE: Change Sub Description captions in HQ item screen

    I am trying to change Sub Description 1 to Supplier Item# & tried changing as you suggested but still not showing caption "Supplier Item#".. Is their something else needs to change? also, what do you change for 3-different type of caption for one caption.

    Please help me with this..

  • Community Member Profile Picture
    Community Member on at
    RE: Change Sub Description captions in HQ item screen

    You need to run an update statement against the customcaption table in HQ to change them.

    select * from customcaption

    backup your database before you run the update statement to change the corresponding values...

    for example

    update customcaption

    set caption = 'new value'

    where style = 'style of the caption you want to change'

    note this change will not go down to the stores; those are changed locally through the application

  • Community Member Profile Picture
    Community Member on at
    RE: Change Sub Description captions in HQ item screen

    I wanted to change following item captions:

    1) Sub Description 1 to Supplier Item#

    2) Sub Description 2 to Size

    3) Sub Description 3 to BPC

    Can you please guide me to make a change? I am not too familiar running SQL query & don't want to screw up database.

    Thank you

  • Community Member Profile Picture
    Community Member on at
    RE: Change Sub Description captions in HQ item screen

    Vinay - if you are the administrator for your RMS system you will need to learn some basic SQL. I was in your shoes several years ago, so it can be done. and it's all free on the internet. google "sql tutorial" and you'll have plenty of results to get you where you need to be.

    run

    select * from customcaption

    then post back your results

  • Community Member Profile Picture
    Community Member on at
    RE: Change Sub Description captions in HQ item screen

    Here is results..

    ID HQID Style Caption DBTimeStamp
    1 0 1  0x0000000000000D49
    2 0 2  0x0000000000000D4A
    3 0 3  0x0000000000000D4B
    4 0 4  0x0000000000000D4C
    5 0 5  0x0000000000000D4D
    6 0 6  0x0000000000000D4E
    7 0 7  0x0000000000000D4F
    8 0 8  0x0000000000000D50
    9 0 9  0x0000000000000D51
    10 0 10  0x0000000000000D52
    11 0 11  0x0000000000000D53
    12 0 12  0x0000000000000D54
    13 0 13  0x0000000000000D55
    14 0 14  0x0000000000000D56
    15 0 15  0x0000000000000D57
    16 0 16 Sub Description 1 0x0000000000000D58
    17 0 17 Sub Description 2 0x0000000000000D59
    18 0 18 Sub Description 3 0x0000000000000D5A
    19 0 19 Custom Text 1 0x0000000000000D5B
    20 0 20 Custom Text 2 0x0000000000000D5C
    21 0 21 Custom Text 3 0x0000000000000D5D
    22 0 22 Custom Text 4 0x0000000000000D5E
    23 0 23 Custom Text 5 0x0000000000000D5F
    24 0 24 Custom Number 1 0x0000000000000D60
    25 0 25 Custom Number 2 0x0000000000000D61
    26 0 26 Custom Number 3 0x0000000000000D62
    27 0 27 Custom Number 4 0x0000000000000D63
    28 0 28 Custom Number 5 0x0000000000000D64
    29 0 29 Custom Date 1 0x0000000000000D65
    30 0 30 Custom Date 2 0x0000000000000D66
    31 0 31 Custom Date 3 0x0000000000000D67
    32 0 32 Custom Date 4 0x0000000000000D68
    33 0 33 Custom Date 5 0x0000000000000D69

    Thanks for your help

  • Community Member Profile Picture
    Community Member on at
    RE: Change Sub Description captions in HQ item screen

    If you want to make the following changes: 1) Sub Description 1 to Supplier Item#

    2) Sub Description 2 to Size 3) Sub Description 3 to BPC

    --Note that the right place to track supplier item number is in the supplier tab of the item's properties as that gets assigned on purchase orders

    backup your database first, I recommend you do this when there are no users in the system

    then run your first update query

    update customcaption

    set caption = 'Supplier Item#'

    where style = 16 and caption = 'Sub Description 1'

    check the item screen to see if the update worked

    if it did, run

    update customcaption

    set caption = 'Size'

    where style = 17 and caption = 'Sub Description 2'

    and then run

    update customcaption

    set caption = 'BPC'

    where style = 18 and caption = 'Sub Description 3'

  • Community Member Profile Picture
    Community Member on at
    RE: Change Sub Description captions in HQ item screen

    Yes, It worked and I just realize what you have suggested to use supplier item# is correct. I will modify this to add useful description of item instead of Supplier item#.

    Thank you for your help.

  • Community Member Profile Picture
    Community Member on at
    RE: Change Sub Description captions in HQ item screen

    Hi Taier,

    Thanks for your help on this.

    Do you know if the HQLanguage.DAT file has changed since? I went to the suggested lines to change my sub descriptions but didn't find them. Instead:

    S6964="Sub Description 1"

    S6966="Sub Description 2"

    S6968="Sub Description 3"

    S6970="Sub-Description 1"

    S6972="Sub-Description 2"

    S6974="Sub-Description 3"

    but I am not sure those are the correct lines to change.

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 > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans