web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Smart List Builder - ...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Smart List Builder - Link Unposted Payment Batch to GL distribution

(0) ShareShare
ReportReport
Posted on by WL_ 5

Hi all, 

Quite new to smart list builder especially the table behind it 

One of the tasks that we perform weekly is to check all the coding AP post, however the painful side is they're already posted so there is no way you can correct it apart from do a journal posting 

Does anyone knows if there is a way we can run a smart list before the batch gets posted ? 

I can filter Document Status "unposted" under "Payable Transactions" to find those all of those yet to post batches

However I'm not sure which table can give me the account code that's used for each invoice?   

And if possible would I be able to pull out AA code as well? 

Version: Our GP is the on the very recent version 18.3

Thanks in advance

I have the same question (0)
  • Gavin Profile Picture
    Gavin 2,508 on at

    Hi,

    If you are using eOne smartlist builder then one you can import one of their smartlist templates directly from their web site.

    Below are templates that would include PM distributions and this is the link that explains how to do it. www.eonesolutions.com/.../toc377551035.php

    pastedimage1617714066374v1.png

    If you were to build your own smartlist object the SQL table name for unposted payables distributions is PM10100 (its name in smartlst builder would be PM Distribution WORK OPEN)

    I hope this helps

    Thanks

    Gavin

  • Suggested answer
    Victoria Yudin Profile Picture
    Victoria Yudin 22,769 on at

    HI WL, 

    Another option would be to create a SQL view first, then use it in SmartList Builder. My blog has code for getting all GL distributions for payables transactions here: | SQL view for Payables GL distributions in Dynamics GPVictoria Yudin

    You could leave it as is, or change it to only pull in unposted transactions. Then just set it up as a new SmartList in SmartList Builder.

    Victoria

  • WL_ Profile Picture
    WL_ 5 on at

    Thanks Gavin 

    I have pulled out the transactions and they are exactly what I was looking for 

    Will start fine tune the content to get the rest of the info needed 

    Regards,

    Wendy

  • WL_ Profile Picture
    WL_ 5 on at

    Hi Vctoria

    That is a very resourceful link

    I have been playing with each table you mentioned to see the contents of each

    Can I ask if I wish to incorporate Analytical Accounting code which table/tables should I be using?

    Regards,

    Wendy

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 584 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 499 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 254 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans