Populating the AddlDesc column in the UPR40300 (Department) table

(0) Share

Report

Posted on by Jackie McNab

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

All responses (4)

Answers (0)

SMike Giuffre 275 on at

Like (0)

Report

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 210 on at

Like (0)

Report

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 275 on at

Like (0)

Report

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 275 on at

Like (0)

Report

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.