News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP forum Modifying Lookup Windows

Microsoft Dynamics GP forum

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:

Development / Customization / SDK

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

David Musgrave MVP ... 13,835 Moderator 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... 290,554 Super User 2024 Season 2

#2

Martin Dráb 228,588 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans