Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL (Archived)

Code Table functionality available in other modules?

Posted on by 1,005

I have an application where it would be handy to have the ability to choose a code on a PO or SL line and have it link to a record in a table that contains multiple columns, similar to the fields in a Code Table record. I'd like to accomplish this using configuration manager, and not custom programming if at all possible. Is there a method to make the code table values available for selection in the user defined fields within modules other than Project & Contract?

*This post is locked for comments

  • George Sagen Profile Picture
    George Sagen 1,005 on at
    Re: Re: Code Table functionality available in other modules?

    Thank you. I'll crack open the manual and get syntax for all this. Appreciate your help.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Code Table functionality available in other modules?

    You would need to add the user field to the screen.  Then you would want to create a PV (record and proc) for the source table where the values are to be stored.  Then set the PV property of the user field object to the PV record.  You can then reuse the same PV on other screens.  In your custom table make sure you add the timestamp column at the end.  You will also want to make sure you know how you will be maintaining the source table whether it be a custom screen or direct SQL access.

  • George Sagen Profile Picture
    George Sagen 1,005 on at
    Re: Re: Code Table functionality available in other modules?

    Sorry, yes I meant Customization Manager. I'd really like to keep my implementation vanilla if possible.

  • pbrattin Profile Picture
    pbrattin 1,850 on at
    Re: Code Table functionality available in other modules?

    I am not sure which module you mean when you say configuration manager. Do you mean Customization Manager? If so, it can be done but AFAIK, it will require some custom programming.

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!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans