Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Populating the AddlDesc column in the UPR40300 (Department) table

Posted on by 210

Good morning,

I would like to use the AddlDesc column in the UPR40300 (Department) table by having the person enter the data at the time of adding a new department.  My issue is that it is not displayed on the Department Setup screen.  How do I achieve this online.  I do not want to write a script to update the data in the back end.

Any ideas anyone?

Thank you.

Jackie McNab

*This post is locked for comments

  • SMike Giuffre Profile Picture
    SMike Giuffre 275 on at
    RE: Populating the AddlDesc column in the UPR40300 (Department) table

    Not the only example.  Every try to use the Life Insurance tables?  Window only shows 2 decimals, but the table can contain 5.  I had to create a new window so we could go the full 5 decimals - which is how are rates are quoted by the insurance company.

  • Jackie McNab Profile Picture
    Jackie McNab 210 on at
    RE: Populating the AddlDesc column in the UPR40300 (Department) table

    SMike,  Thanks for your suggestions.  I guess I will have to look at a modification as I want to have it updated at the time of adding a new department.

    It makes no sense though to have a field like that which cannot update via the application.

  • SMike Giuffre Profile Picture
    SMike Giuffre 275 on at
    RE: Populating the AddlDesc column in the UPR40300 (Department) table

    Oh I had another idea.  You can use Access, or possible even Excel to update this table directly outside of GP.  Understand there are definite risks in doing this but maybe those tools can help.

  • SMike Giuffre Profile Picture
    SMike Giuffre 275 on at
    RE: Populating the AddlDesc column in the UPR40300 (Department) table

    Other than a customization (Dex or .Net) or VBA I'm not familiar with any other means to achieve this.

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,064 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans