Skip to main content

Notifications

Microsoft Dynamics RMS forum

sign template fields

Posted on by 555

I am creating new product signs and want to add a line that dynamically calculated. i.e. different in original price and current in dollars, as well as a percentage savings. Is there a way to do this. Where are the fields with in label designer determined and can i edit them?

 

Thanks

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: sign template fields

    you cant directly reference the table fields from the label design.  Also the options for the field drop down is hard coded in the program business rules and not stored in a table.

    You could prepopulate the detail1 field with the saving percentage though

    something like this might work:

    update item set item.SubDescription1 = ABS ((item.MSRP - item.price) / item.MSRP)

    You might have to change it to suite your needs.  Dont know if your are using the MSRP in the item properties.  Also dont know if you want this for every item.  I would suggest a where clause at the end of the update statement.

    for reference.  detail1 = dbo.[item],SubDescription1

    detail2 = dbo.[item].SubDescription2

    etc.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: sign template fields

    Do you know what table.field the items are that are listed in the field box.  Some are obvious, others, like Detail1,2,3 are not and perhaps we could use those fields, but I can't find them in the tables.  Thanks!

  • Jeff @ Check Point Software Profile Picture
    Jeff @ Check Point ... 13,380 on at
    Re: sign template fields

    What you see is what you get.

    Use an existing or create a new size label, select create an Object on the top and then select a type of object, Text, Field, Box, Line, Bar code or Picture, each option has their own possible selections.

    As far as I know, you cannot add anything that's not there.

  • Rick Kirkman Profile Picture
    Rick Kirkman 2 on at
    Re: sign template fields

    I would also appreciate any information about adding custom fields to Label Designer or what fields names are available and the format needed to edit them in a text editor.

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

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,802 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,133 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,154

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans