News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Add Payables Long desc...

Finance | Project Operations, Human Resources, ...

Suggested answer

Add Payables Long description to Financial Account Transactions SmartList

(0) Share

Report

Report

Posted on by Deb@gpsupport

112

Customer created a SmartList under Financial > Account Transactions to get the originating master name, originating doc number and reference (trx description), but implemented the long descriptions in Payables. I know out of the box these are not available in the GL tables, but what table(s) can I connect to the GL to this SmartList to add this from the PM transaction table(s). I can't even find this field in the regular payables transaction SmartList.

Thanks!

Categories:

Microsoft Dynamics GP

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Joseph Markovich 3,900 on at

Like (1)

Report

Add Payables Long description to Financial Account Transactions SmartList

Hi Deb-

There's two options I can think of to deal with this:

1) In the Account Transactions SmartList, do a left outer join on the PM tables.

2) Create your own view using both the built-in Account Transactions view and the PM tables. This might be a better option since you tweak the view to speed it up and handle both open and historical transactions at once.

It's a bummer the PayablesTransactions view doesn't include this field.

Joe

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,445 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans