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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Microsoft Dynamics RMS (Archived)

sign template fields

(0) ShareShare
ReportReport
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

I have the same question (0)
  • Rick Kirkman Profile Picture
    8 on at

    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.

  • Jeff @ Check Point Software Profile Picture
    13,382 on at

    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.

  • Community Member Profile Picture
    on at

    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!

  • Suggested answer
    Community Member Profile Picture
    on at

    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.

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…

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans