News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Modifying Lookup Windows

Finance | Project Operations, Human Resources, ...

Suggested answer

Modifying Lookup Windows

(0) Share

Report

Report

Posted on by David Johnson cgb

10

Hello,

I'm wondering if anyone knows where the columns in a lookup window are linked to their respective fields. For example, in the Receivings Transaction Window>> Receipt Number lookup window, there are 4 columns (Receipt Number, Vendor ID, Date, Batch ID). Ultimately I'd like to use modifier to change the Batch ID column to Vendor Document Number. I've successfully swapped those two fields in the Scrolling window in modifier but I can't figure out what the actual columns in the lookup window in modifier are linked to to make the column sort on Vendor Document Number.

Thanks

Categories:

Microsoft Dynamics GP

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

David Musgrave MVP ... 13,928 Most Valuable Professional on at

Like (0)

Report

RE: Modifying Lookup Windows

The fields will be populated automatically as they part of the linked table for the scrolling window.

If you want anything not in the linked table you need to create a local field and use custom code (I recommend GP Power Tools over the "End of Life" VBA) to populate it.

Regards

David

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,214 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans